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": "building",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows a street scene with several multi-story buildings. One of the main buildings on the left has multiple signs, including a large blue sign in Arabic with a medical symbol on it. The windows on the ground floor have frosted design elements and display the CNOPS logo and text in Arabic and French. Another sign above a door says 'إقامة المجد لله' (Residence of the Glory to God). There is a Moroccan flag next to the entrance. On the same building, multiple air conditioning units are visible. Neighboring buildings are residential or mixed-use, with open balconies, some laundry hanging, and additional businesses at street level including 'Picasso' (possibly a shop or café) and various professional signs. Cars are parked along the sidewalk, including a black hatchback and an Audi SUV. The street sign 'YAMAMA' is visible on the beige building. The overall area appears urban, with mostly neutral colored façades (grey, beige, brown, white).",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": "",
    "bone_level": null,
    "root_canals": null,
    "restorations_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 13479 in messages