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