erd
Tables (13)
care_request_analysis
- analysis_id — SERIAL
- request_id — VARCHAR(50) — Foreign key → care_requests.request_id
- intent — VARCHAR(50)
- parameters — JSONB
- confidence — DOUBLE
- clarification_question — TEXT
- risk_tag — VARCHAR(50)
- created_at — TIMESTAMP
care_requests
- request_id — VARCHAR(50)
- patient_id — VARCHAR(50) — Foreign key → patients.patient_id
- session_id — VARCHAR(100)
- input_type — VARCHAR(20)
- raw_payload — TEXT
- status — VARCHAR(30) — NOT NULL
- route_type — VARCHAR(50)
- emergency_priority — VARCHAR(10)
- created_at — TIMESTAMP
- canceled_at — TIMESTAMP
conversation_logs
- log_id — SERIAL
- patient_id — VARCHAR(50) — Foreign key → patients.patient_id
- session_id — VARCHAR(100)
- user_message — TEXT
- ai_response — TEXT
- route_type — VARCHAR(30)
- created_at — TIMESTAMP
item_policies
- item_id — SERIAL
- item_name — VARCHAR(100) — NOT NULL
- is_allowed — BOOLEAN
- location_info — VARCHAR(100)
- category — VARCHAR(50)
- updated_at — TIMESTAMP
nurse_call_events
- call_event_id — SERIAL
- request_id — VARCHAR(50) — Foreign key → care_requests.request_id
- patient_id — VARCHAR(50) — Foreign key → patients.patient_id
- status — VARCHAR(20)
- priority — VARCHAR(10)
- operator_id — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
patient_records
- record_id — SERIAL
- patient_id — VARCHAR(50) — Foreign key → patients.patient_id
- request_id — VARCHAR(50) — Foreign key → care_requests.request_id
- record_type — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- risk_tag — VARCHAR(50)
- action_status — VARCHAR(20)
- operator_id — VARCHAR(50)
- created_at — TIMESTAMP
patient_tablet_mapping
- mapping_id — SERIAL
- patient_id — VARCHAR(50) — Foreign key → patients.patient_id
- tablet_id — VARCHAR(50) — NOT NULL
- ward_id — VARCHAR(50)
- access_token — TEXT
- refresh_token — TEXT
- status — VARCHAR(20)
- updated_at — TIMESTAMP
patients
- patient_id — VARCHAR(50)
- name — VARCHAR(100) — NOT NULL
- ward_id — VARCHAR(50)
- created_at — TIMESTAMP
robot_command_log
- command_id — SERIAL
- request_id — VARCHAR(50) — Foreign key → care_requests.request_id
- robot_id — VARCHAR(50)
- command_payload — JSONB — NOT NULL
- status — VARCHAR(20)
- failure_reason — TEXT
- grpc_call_id — VARCHAR(100)
- deadline — TIMESTAMP
- created_at — TIMESTAMP
search_logs
- log_id — SERIAL
- request_id — VARCHAR(50) — Foreign key → care_requests.request_id
- query — VARCHAR(255)
- search_summary — TEXT
- is_success — BOOLEAN
- created_at — TIMESTAMP
system_config
- config_key — VARCHAR(50)
- config_value — TEXT — NOT NULL
- description — TEXT
- updated_at — TIMESTAMP
system_logs
- log_id — BIGSERIAL
- level — VARCHAR(10)
- message — TEXT
- trace_id — VARCHAR(100)
- created_at — TIMESTAMP
ws_delivery_log
- log_id — SERIAL
- request_id — VARCHAR(50) — Foreign key → care_requests.request_id
- status — VARCHAR(30)
- is_delivered — BOOLEAN
- created_at — TIMESTAMP