SQLite Web: app.db

id

Primary key. INTEGER

conversation_id

INTEGER NOT NULL

message_id

TEXT NOT NULL

sender

TEXT NOT NULL

message_type

TEXT NOT NULL (default 'text'

content

[Image analysis] Image description: ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "moderate",
    "issues": []
  },
  "description": "The image shows a close-up view of a person's mouth, with lips retracted to expose the teeth and part of the gums. The upper and lower front teeth are visible, primarily on the right side of the patient (left side of the image). The teeth appear mostly clean and of normal shade. Notable misalignment is observed in the upper canine region, with what looks like anterior crowding. The gum tissue visible appears pink and without obvious swelling or redness. No obvious cavities, restorations, major discolorations, or soft tissue lesions are visible in this view.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_right_canine",
        "observation": "Tooth is outwardly displaced compared to the adjacent teeth, indicating notable malalignment and crowding.",
        "severity_signal": "significant"
      },
      {
        "location": "front_upper",
        "observation": "Teeth appear well-formed and of normal shade, but some minor irregularities in alignment; no visible caries or fractures.",
        "severity_signal": "mild"
      },
      {
        "location": "front_lower",
        "ob

User message context: ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "moderate",
    "issues": ["slight_blur", "partial_view"]
  },
  "description": "The image shows a close-up view of a person's mouth, focusing on the upper and lower anterior teeth while the lips are pulled back in a partial smile/grimace. The lighting is uneven, and some areas are slightly out of focus. Visible teeth are generally clean and appear natural in color. The upper left canine is notably positioned higher than the adjacent teeth and appears to be out of alignment with the rest of the dental arch. The lower front teeth are visible and appear slightly crowded. The gum tissue is partially visible and appears pink without obvious redness or swelling. No obvious dental restorations, fillings, or major discolorations are visible. No soft tissue lesions or active bleeding can be seen.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_left_canine",
        "observation": "Canine is positioned higher than adjacent teeth (ectopic eruption or partial impaction); out of alignment with the dental arch.",
        "severity_signal": "moderate"
      },
      {
        "location": "front_upper",
        "observation": "Incisors present and aligned, no obvious fractures or discolor

TEXT

media_url

TEXT

media_mime_type

TEXT

chatbot_id

INTEGER NOT NULL

created_at

TEXT NOT NULL

status

TEXT (default 'sent'

delivered_at

TEXT

read_at

TEXT

sender_user_id

TEXT

metadata

TEXT

app.db — messages

Update row 50914 in messages