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": "moderate",
    "issues": []
  },
  "description": "The image shows an open mouth, focusing primarily on the lower dental arch and the lower part of the upper front teeth. The gums, lower teeth, and parts of the tongue and oral mucosa are visible. Multiple teeth are visible in both upper and lower arches. There is a metal framework or bar present on the lower dental arch, possibly related to dental restoration (e.g. partial denture or orthodontic retainer). The lower teeth show varying shades, with yellowish-brown discoloration and possible buildup near the gumline. Some upper teeth (especially anterior) appear to be prosthetic or have crowns due to their uniform color and shape. The right upper molar area appears to have a large metallic crown or restoration. Gums are partially visible but not in complete detail. There are no visible soft tissue lesions or obvious swelling. The individual's skin, chin, and part of a cream/white sweater are also visible.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_front",
        "observation": "Multiple teeth present with notable yellow to brownish discoloration, irregular alignment, and possible calculus or plaque accumulation at the gumline.",

User message context: ```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "moderate",
    "issues": []
  },
  "description": "The image shows the lower half of a person's face with their mouth open. Visible are the upper and lower anterior teeth, parts of the lower premolars and molars, and a portion of the posterior upper arch. The person appears to have a metallic bar or partial denture involving the lower jaw. Several teeth are yellowish with visible calculus and staining, particularly in the lower anterior and premolar regions. The gum tissue is only partially visible, but some redness and possible recession may be present near the lower teeth. There is a large metallic restoration or crown on an upper left molar, as well as metal framework extending across the lower arch. The overall oral hygiene appears to be compromised with visible plaque and calculus.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_right",
        "observation": "Multiple lower right anterior and posterior teeth are present with visible yellow-brown discoloration and apparent calculus deposits.",
        "severity_signal": "moderate"
      },
      {
        "location": "lower_left",
        "observation": "Lower left anterior and posterior teeth present, with visible staining and calculus, especially at the gum margin.",

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