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] ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image is an intraoral photograph focused on the lower dental arch and palate. The mouth is open with a cheek/lip retractor in place, providing a clear view of all mandibular teeth. The lower permanent teeth are present, and the occlusal surfaces are visible. Gum tissue appears generally healthy with a coral pink coloration and no significant swelling, ulcerations, or obvious recession. No visible calculus or substantial plaque deposits are apparent, but there are some areas of mild staining on the occlusal surfaces of the premolars and molars. Tooth alignment appears to be good with minimal crowding. There are no visible crowns, fillings, or orthodontic appliances. The palatal mucosa also appears healthy.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "lower_left_molars",
        "observation": "Occlusal surfaces show some mild stains or grooves but no gross caries or fractures visible.",
        "severity_signal": "mild"
      },
      {
        "location": "lower_right_molars",
        "observation": "Occlusal surfaces show some mild stains or grooves but no gross caries or fractures visible

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