ㄷ

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