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

```json
{
  "visible_domain": "dental_xray",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "This is a high-quality lateral cephalometric radiograph showing a full side view of the skull, cervical vertebrae, mandible, maxilla, teeth, and some soft tissue outlines. The cranial outline, nasal cavity, and cervical spine are clearly visible. The teeth in both the upper and lower arches are shown in profile, allowing observation of the incisal and molar relationships, as well as the position of the jaws relative to the cranial base. Several identification marks and measurement scales are visible on the radiograph. The radiograph header includes the patient's name, date of birth, examination date, radiology center, and doctor's name. There is no visible obvious fracture, major lesion, or large radiolucency noted in the craniofacial skeleton. No apparent dental implants, orthodontic brackets, or large restorations are present.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_right",
        "observation": "Visible from canine to molar, tooth profiles appear intact, no clear evidence of gross decay or damage.",
        "severity_signal": "none"
      },
      {
        "location": "upper_left

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