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 shows a close-up intraoral view of an adult mouth. The lips are retracted with a dental cheek retractor, fully exposing the upper and lower teeth and gingiva. All anterior and premolar teeth are visible, with partial visualization of the first molars. The teeth display a yellowish shade with some areas of whiter enamel, especially on the upper front teeth. There are no obvious carious lesions, chips, or fractures visible. Mild to moderate gingival redness is noted, particularly at the lower anterior region, with some apparent recession exposing more of the tooth root. The gingival contours are uneven, and some papillae appear blunted. The teeth present mild crowding in the lower incisors, and there is some overlapping. The alignment of the upper and lower arches is generally acceptable, though midline is slightly off. The visible oral mucosa appears moist, with no ulceration or white lesions observed. There are no apparent restorations, crowns, fillings, or orthodontic appliances. No visible calculus, though some mild yellow staining may be present at the cervical third of the teeth.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location":

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