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