CareEye
Tables (7)
alert
- alert_id — Primary key — NOT NULL
- fall_event_id — Foreign key → fall_event.fall_event_id — NOT NULL
- user_id — Foreign key → user.user_id — NOT NULL
- nurse_id — Foreign key → nurse.nurse_id — NOT NULL
- send_at
fall_event
- fall_event_id — Primary key — NOT NULL
- senior_id — Foreign key → senior.senior_id — NOT NULL
- detected_at
- severity
nurse
- nurse_id — Primary key — NOT NULL
- nursename (nurse_name)
- nursephone (nurse_phone)
room
- room_id — Primary key — NOT NULL
- roomnumber (room_number)
room_nurse (nurse_room)
- room_id — Foreign key → room.room_id — NOT NULL
- nurse_id — Foreign key → nurse.nurse_id — NOT NULL
senior
- senior_id — Primary key — NOT NULL
- hospital_id
- roomnumber (room_number)
- birth_date (senior_birth)
- gender (senior_gender)
- name (senior_name)
- note (special_note)
- user_id — Foreign key → user.user_id — NOT NULL
user
- user_id — Primary key — NOT NULL
- birth
- phone (phone_number)
- email
- username
- gender
- id
- password