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": "document",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image is a clinical laboratory result form from 'Laboratoire d'Analyses Medicales Biodiagnostica,' showing a full blood count and coagulation profile. The document is in French (with some Arabic), and contains detailed hematological parameters such as white and red blood cell counts, hemoglobin, hematocrit, and differential counts (neutrophils, eosinophils, basophils, lymphocytes, monocytes), platelet count, sedimentation rates, and hemostasis parameters (bleeding time, prothrombin rate, activated cephalin time). It is addressed to a specific patient (Madame YAKOUBI HAMZAOUI NAOUAL), processed by Dr. HAITAM BOUTAIB, and issued in Tangier. The date on the form is 06/07/26. A blue stamp and signature are visible in the lower right section. The lower border contains laboratory contact details, email, and website. The document is resting on a green-bordered surface, with a visible computer keyboard at the top background.",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": "",
    "bone_level": null

User message context: ```json
{
  "visible_domain": "document",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows a laboratory hematology report from 'Laboratoire d'Analyses Medicales Biodiagnostica' in Tangier. The document lists various hematological parameters with measured values and their reference ranges. It includes patient details, doctor's name, laboratory address, contact information, date of sample (06/07/26), and a stamp. The document contains categories such as Hemogramme, Formule Sanguine, Numeration des Plaquettes, Vitesse de Sedimentation, and Hemostase. All text is clearly visible and readable.",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": null,
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": [],
    "missing_teeth": null,
    "alignment": null,
    "calculus_plaque": null,
    "periapical_areas": null,
    "other_findings": null
  },
  "text_visible": [
    "LABORATOIRE D’ANALYSES MEDICALES BIODIAGNOSTICA",
    "Laboratoire d’analyses médicales biodiagnostica",
    "T

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