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
  • email
  • birth
  • gender
  • password