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