ongi
Tables (5)
emergency_notification (긴급 알림)
- id (Key) — BIGINT — Primary key — NOT NULL
- activation (Field) — BOOL
- alert_count (Field2) — BIGINT
- id (Key2) — BIGINT — Foreign key → user.id — NOT NULL
meal_schedule (식사 일정)
- id (Key) — BIGINT — Primary key — NOT NULL
- meal_title (Field) — VARCHAR(15)
- meal_time (Field2) — DATETIME
- meal_status (Field3) — BOOL
- id (Key2) — BIGINT — Foreign key → user.id — NOT NULL
medication_schdule (약 일정)
- id (Key) — BIGINT — Primary key — NOT NULL
- medication_title (Field) — VARCHAR(15)
- medication_time (Field2) — DATETIME
- medication_status (Field3) — BOOL
- id (Key2) — BIGINT — Foreign key → user.id — NOT NULL
user (사용자)
- id (Key) — BIGINT — Primary key — NOT NULL
- role (보호자 관계) — ENUM
- name (노인 이름) — VARCHAR(15)
- phone_number (보호자 번호) — VARCHAR(11)
- age (Field5) — INT
- alert_maximum (Field6) — INT
- Field