CapstonDesign
Tables (4)
Guardian (CopyOfUntitled3)
- id (Key) — bigint(20) — Primary key — NOT NULL
- household_id (Key2) — bigint(20) — Foreign key → Household.id — NOT NULL
- name (Field) — varchar(255)
- age (Field2) — int(3)
- phone_number (Field3) — varchar(255)
Household (Untitled)
- id (Key) — bigint(20 — Primary key — NOT NULL
- address (Field) — varchar(255)
- risk (Field2) — varchar(255)
- resident_name (Field3) — varchar(255)
- resident_age (Field4) — int(3)
- resident_phone_number (Field5) — varchar(255)
Schedule (일정)
- id (Key) — bigint(20) — Primary key — NOT NULL
- user_id (Key3) — bigint(20) — Foreign key → User.id — NOT NULL
- household_id (Key2) — bigint(20) — Foreign key → Household.id — NOT NULL
- date (Field) — DateTime
User (복지사)
- id (Key) — bigint(20) — Primary key — NOT NULL
- email (Key2) — varchar(255) — NOT NULL
- password (Field) — varchar(255)
- name (Field2) — varchar(255)
- phone_number (Field3) — varchar(255)