happytue772

Tables (14)

ai_diagnosis_results

  • result_id — UUID
  • patient_id — UUID
  • requested_by — UUID
  • created_at — TIMESTAMP
  • model_version — VARCHAR
  • input_summary — TEXT
  • result_text — TEXT
  • predicted_label — VARCHAR
  • confidence_score — DOUBLE

ai_segmentations

  • segmentation_id — UUID
  • patient_id — UUID
  • pacs_id — UUID
  • requested_by — UUID
  • created_at — TIMESTAMP
  • model_name — VARCHAR
  • model_version — VARCHAR
  • segmentation_url — TEXT
  • overlay_preview_url — TEXT
  • volume_estimate — FLOAT

lis_items

  • lis_item_id — UUID
  • lis_order_id — UUID
  • test_code — VARCHAR
  • test_name — VARCHAR
  • result_value — TEXT
  • unit — VARCHAR
  • reference_range — VARCHAR

lis_orders

  • lis_order_id — UUID
  • patient_id — UUID
  • order_code — VARCHAR
  • order_name — VARCHAR
  • collected_at — TIMESTAMP
  • reported_at — TIMESTAMP

messages

  • message_id — UUID
  • sender_id — UUID
  • receiver_id — UUID
  • sender_role — VARCHAR
  • receiver_role — VARCHAR
  • content — TEXT
  • sent_at — TIMESTAMP
  • read_at — TIMESTAMP

notifications

  • notification_id — UUID
  • user_id — UUID
  • user_role — VARCHAR
  • title — VARCHAR
  • message — TEXT
  • is_read — BOOLEAN
  • sent_at — TIMESTAMP

pacs_images

  • pacs_id — UUID
  • patient_id — UUID
  • study_date — DATE
  • modality — VARCHAR
  • body_part — VARCHAR
  • image_url — TEXT
  • description — TEXT

patient_links

  • link_id — UUID
  • patient_id — UUID
  • external_system — VARCHAR
  • external_patient_id — VARCHAR
  • last_synced — TIMESTAMP

patients

  • patient_id — UUID
  • hospital_id — VARCHAR
  • name — VARCHAR
  • sex — CHAR(1)
  • birth_date — DATE
  • created_at — TIMESTAMP

selfcheck_responses

  • response_id — UUID
  • patient_id — UUID
  • template_id — UUID
  • response_json — JSONB
  • submitted_at — TIMESTAMP

selfcheck_templates

  • template_id — UUID
  • title — VARCHAR — NOT NULL
  • question_json — JSONB
  • created_by — UUID
  • created_at — TIMESTAMP

users

  • user_id — UUID
  • email — VARCHAR — NOT NULL
  • password_hash — VARCHAR — NOT NULL
  • name — VARCHAR — NOT NULL
  • role — user_role — NOT NULL
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • last_login — TIMESTAMP

vital_measurements

  • measurement_id — UUID
  • session_id — UUID
  • vital_type — VARCHAR
  • vital_value — TEXT
  • unit — VARCHAR

vital_sessions

  • session_id — UUID
  • patient_id — UUID
  • recorded_at — TIMESTAMP
  • measured_by — VARCHAR