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": "good",
    "issues": []
  },
  "description": "The image consists of three intraoral photographs (centered on lower arch, both arches, and frontal smile) of an adult male. The teeth exhibit significant yellow-brown discoloration, notable calculus and plaque deposits, and several missing or broken teeth. The upper central incisors are widely spaced and one has a prosthetic or composite restoration. Severe calculus accumulation is present especially on the lower anterior teeth. The gingival tissues appear erythematous and inflamed in some areas, indicating possible gingivitis or periodontal involvement. The smile photo further shows crowding and misalignment in both upper and lower arches. Multiple restored, decayed, and fractured teeth are seen. No visible text or identifiers are present.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Significant gap between upper central incisors; left central incisor appears to have prosthetic or composite restoration; both incisors show discoloration.",
        "severity_signal": "moderate"
      },
      {
        "location": "upper_left",
        "observation": "Posterior teeth show heavy brownish deposits and possible caries. At least one missing

User message context: ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image consists of three intraoral photographs of an adult male's mouth at various angles. The first (left) image is an open mouth view from below, showing both upper and lower arches, tongue, and palate. The second (center) image is a frontal intraoral view with the mouth wide open, visualization of teeth, gums, anterior palate, and floor of the mouth. The third (right) image is a closed-mouth smile, displaying the upper and lower anterior teeth and part of the lips and chin. Teeth exhibit generalized yellow-brown discoloration and mild-moderate plaque/calculus deposition. Several teeth have visible gaps (diastemas); anterior upper teeth include a prominent midline gap. There appears to be moderate misalignment (malocclusion) with crowding and rotation in the lower anterior segment. Several teeth exhibit visible structural defects, possible decay, and/or crown loss. The gingiva appears inflamed and reddish in areas, especially the lower front. The oral mucosa, tongue, and palate do not show obvious focal lesions. There are no clear signs of recent bleeding or acute swelling.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "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 15794 in messages