ㄷ
Tables (13)
care_request_analysis
- analysis_id — BIGSERIAL
- request_id — VARCHAR(50) — Foreign key → care_requests.request_id — NOT NULL
- intent — VARCHAR(50)
- parameters — JSONB
- confidence — NUMERIC(5,4)
- clarification_question — TEXT
- risk_tag — VARCHAR(50)
- created_at — TIMESTAMP — NOT NULL
care_requests
- request_id — VARCHAR(50)
- patient_id — VARCHAR(50) — Foreign key → patients.patient_id — NOT NULL
- assignment_id — BIGINT — Foreign key → patient_tablet_assignments.assignment_id
- input_type — VARCHAR(20) — NOT NULL
- raw_text — TEXT
- status — VARCHAR(30) — NOT NULL
- route_type — VARCHAR(30)
- priority — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- completed_at — TIMESTAMP
- canceled_at — TIMESTAMP
conversation_logs
- conversation_id — BIGSERIAL
- patient_id — VARCHAR(50) — Foreign key → patients.patient_id — NOT NULL
- request_id — VARCHAR(50) — Foreign key → care_requests.request_id
- speaker_type — VARCHAR(20) — NOT NULL
- message — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
nurse_call_events
- call_id — BIGSERIAL
- patient_id — VARCHAR(50) — Foreign key → patients.patient_id — NOT NULL
- request_id — VARCHAR(50) — Foreign key → care_requests.request_id
- call_status — VARCHAR(20) — NOT NULL
- handled_by — VARCHAR(50) — Foreign key → users.user_id
- handled_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
patient_records
- record_id — BIGSERIAL
- patient_id — VARCHAR(50) — Foreign key → patients.patient_id — NOT NULL
- request_id — VARCHAR(50) — Foreign key → care_requests.request_id
- record_type — VARCHAR(30) — NOT NULL
- content — TEXT — NOT NULL
- keyword — VARCHAR(100)
- target_role — VARCHAR(30)
- action_status — VARCHAR(20) — NOT NULL
- checked_by — VARCHAR(50) — Foreign key → users.user_id
- checked_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
patient_tablet_assignments
- assignment_id — BIGSERIAL
- patient_id — VARCHAR(50) — Foreign key → patients.patient_id — NOT NULL
- tablet_id — VARCHAR(50) — Foreign key → tablets.tablet_id — NOT NULL
- assignment_status — VARCHAR(20) — NOT NULL
- assigned_at — TIMESTAMP — NOT NULL
- released_at — TIMESTAMP
- release_reason — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
patients
- patient_id — VARCHAR(50)
- patient_name — VARCHAR(100) — NOT NULL
- ward_id — VARCHAR(50) — Foreign key → wards.ward_id
- status — VARCHAR(20) — NOT NULL
- admitted_at — TIMESTAMP
- discharged_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
robot_command_logs
- command_id — BIGSERIAL
- request_id — VARCHAR(50) — Foreign key → care_requests.request_id — NOT NULL
- command_type — VARCHAR(50) — NOT NULL
- command_status — VARCHAR(20) — NOT NULL
- target_item — VARCHAR(100)
- fail_reason — TEXT
- issued_at — TIMESTAMP — NOT NULL
- completed_at — TIMESTAMP
system_logs
- log_id — BIGSERIAL
- log_level — VARCHAR(20) — NOT NULL
- source_module — VARCHAR(50) — NOT NULL
- message — TEXT — NOT NULL
- related_request_id — VARCHAR(50) — Foreign key → care_requests.request_id
- created_at — TIMESTAMP — NOT NULL
tablet_auth_sessions
- session_id — BIGSERIAL
- assignment_id — BIGINT — Foreign key → patient_tablet_assignments.assignment_id — NOT NULL
- access_token — TEXT
- refresh_token — TEXT
- session_status — VARCHAR(20) — NOT NULL
- issued_at — TIMESTAMP — NOT NULL
- expires_at — TIMESTAMP
- revoked_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
tablets
- tablet_id — VARCHAR(50)
- device_name — VARCHAR(100)
- serial_no — VARCHAR(100)
- ward_id — VARCHAR(50) — Foreign key → wards.ward_id
- install_position — VARCHAR(100)
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
users
- user_id — VARCHAR(50)
- user_name — VARCHAR(100) — NOT NULL
- role — VARCHAR(30) — NOT NULL
- phone_no — VARCHAR(30)
- created_at — TIMESTAMP — NOT NULL
wards
- ward_id — VARCHAR(50)
- ward_name — VARCHAR(100) — NOT NULL
- room_no — VARCHAR(50)
- bed_no — VARCHAR(50)
- created_at — TIMESTAMP — NOT NULL