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