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": ["partial_view"]
  },
  "description": "The image shows the lower part of a person's face, with the mouth open wide. The lower and upper teeth are both partially visible, with a clear view of the lower dental arch. The person is wearing glasses and a white knitted sweater over a light blue collared shirt, with part of a light-colored headscarf visible. There is a metal lingual wire (retainer) on the lower teeth. The gums are partially visible. The photo is taken indoors under artificial lighting, with reflection of lights visible in the glasses.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_front",
        "observation": "All lower anterior teeth appear present; moderate crowding noted. There is a fixed lingual wire (retainer) bonded to the lingual surfaces.",
        "severity_signal": "mild"
      },
      {
        "location": "lower_left",
        "observation": "Posterior teeth visible. Surfaces appear with some yellowish discoloration suggestive of staining or plaque accumulation.",
        "severity_signal": "mild"
      },
      {
        "location": "lower_right",
        "observation

User message context: ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "moderate",
    "issues": ["partial_view", "slight blur"]
  },
  "description": "The image depicts the lower half of a person's face and mouth widely open. The upper and lower front teeth, the lower arch, tongue, lower gum tissue, and a lingual fixed orthodontic retainer attached to the mandibular anterior teeth are visible. The person is wearing glasses, a light beige or tan headscarf, a white textured sweater, and a light blue shirt underneath. Lighting reflections are visible on the glasses. Not all teeth are fully visible, particularly in the posterior areas. The lower anterior teeth show some yellowish discoloration.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_lower",
        "observation": "All anterior mandibular teeth are present. Noticeable yellowish or brownish discoloration on several lower front teeth. Fixed lingual retainer is bonded to these teeth.",
        "severity_signal": "mild"
      },
      {
        "location": "lower_left",
        "observation": "Posterior teeth not fully visible. Part of left premolar and molar region visible in the background. Surfaces suggest possible yellowish deposits.",
        "severity_signal":

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 13017 in messages