careBridge

Tables (5)

alert

  • alert_id — NUMBER(19) — Primary key — NOT NULL
  • log_id — NUMBER(19) — Foreign key → care_log.log_id — NOT NULL
  • message — VARCHAR2(500 CHAR) — NOT NULL
  • status — VARCHAR2(20 CHAR) — NOT NULL
  • created_at — TIMESTAMP(6) — NOT NULL
  • resolved_at — TIMESTAMP(6)

care_log

  • log_id — NUMBER(19) — Primary key — NOT NULL
  • schedule_id — NUMBER(19) — Foreign key → care_schedule.schedule_id — NOT NULL
  • content — VARCHAR2(1000 CHAR) — NOT NULL
  • created_at — TIMESTAMP(6) — NOT NULL

care_schedule

  • schedule_id — NUMBER(19) — Primary key — NOT NULL
  • senior_id — NUMBER(19) — Foreign key → senior.senior_id — NOT NULL
  • caregiver_id — NUMBER(19) — Foreign key → caregiver.caregiver_id — NOT NULL
  • visit_at — TIMESTAMP(6) — NOT NULL
  • status — VARCHAR2(20 CHAR) — NOT NULL
  • completed_at — TIMESTAMP(6)
  • created_at — TIMESTAMP(6) — NOT NULL

caregiver

  • caregiver_id — NUMBER(19) — Primary key — NOT NULL
  • name — VARCHAR2(100 CHAR) — NOT NULL

senior

  • senior_id — NUMBER(19) — Primary key — NOT NULL
  • name — VARCHAR2(100 CHAR) — NOT NULL
  • birth_date — DATE — NOT NULL
  • phone — VARCHAR2(30 CHAR)
  • note — VARCHAR2(500 CHAR)
  • created_at — TIMESTAMP(6) — NOT NULL