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