FFFF

Tables (7)

access_logs

  • log_id — INTEGER
  • user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • action_type — TEXT — NOT NULL
  • target_type — TEXT
  • target_id — INTEGER
  • detail — TEXT
  • action_time — TEXT — NOT NULL

fall_events

  • event_id — INTEGER
  • patient_id — INTEGER — Foreign key → patients.patient_id — NOT NULL
  • room_id — INTEGER — Foreign key → rooms.room_id
  • detected_at — TEXT — NOT NULL
  • confidence — REAL
  • alert_sent — INTEGER — NOT NULL
  • alert_sent_at — TEXT
  • alert_target_user_id — INTEGER — Foreign key → users.user_id
  • event_status — TEXT — NOT NULL
  • note — TEXT
  • review_status — TEXT — NOT NULL
  • reviewed_by — INTEGER — Foreign key → users.user_id
  • reviewed_at — TEXT
  • review_note — TEXT

patients

  • patient_id — INTEGER
  • name — TEXT — NOT NULL
  • birth_date — TEXT
  • gender — TEXT
  • room_id — INTEGER — Foreign key → rooms.room_id
  • staff_user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • guardian_user_id — INTEGER — Foreign key → users.user_id
  • is_active — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL

rooms

  • room_id — INTEGER
  • room_number — TEXT — NOT NULL
  • room_name — TEXT
  • camera_stream_url — TEXT
  • is_active — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL

settings

  • setting_id — INTEGER
  • user_id — INTEGER — Foreign key → users.user_id
  • setting_key — TEXT — NOT NULL
  • setting_value — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL

users

  • user_id — INTEGER
  • name — TEXT — NOT NULL
  • email — TEXT — NOT NULL
  • password_hash — TEXT — NOT NULL
  • phone — TEXT — NOT NULL
  • role — TEXT — NOT NULL
  • is_active — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL

videos

  • video_id — INTEGER
  • event_id — INTEGER — Foreign key → fall_events.event_id — NOT NULL
  • file_path — TEXT — NOT NULL
  • thumbnail_path — TEXT
  • recorded_at — TEXT — NOT NULL
  • duration_sec — INTEGER
  • is_deleted — INTEGER — NOT NULL