Befor 3NF
Tables (7)
alert
- alert_id — Primary key — NOT NULL
- send_at
fall_event
- fall_event_id — Primary key — NOT NULL
- detected_at
- severity
nurse
- nurse_id — Primary key — NOT NULL
- nurse_name
- nurse_phone
room
- room_id — Primary key — NOT NULL
- room_number
room_nurse
- room_id — NOT NULL
- nurse_id — NOT NULL
senior
- senior_id — Primary key — NOT NULL
- hospital_id
- senior_name
- senior_birth
- senior_gender
- risk_level
- special_note
user
- user_id — Primary key — NOT NULL
- username
- phone_number
- birth
- gender
- password