테스트DB_0228
테이블 (4)
medication_schedule
- schedule_id — INT
- relationship_id — INT — NOT NULL
- medication_date — DATE — NOT NULL
- meal_time — ENUM('식전', '식후') — NOT NULL
- medication_name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
medication_time
- time_id — INT
- schedule_id — INT — NOT NULL
- time_slot — ENUM( '아침', '점심', '저녁', '취침 전' ) — NOT NULL
- created_at — TIMESTAMP
user
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- email — VARCHAR(100)
- role — ENUM('guardian', 'patient') — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_relationship
- relationship_id — INT
- guardian_id — INT — NOT NULL
- patient_id — INT — NOT NULL
- relationship_type — ENUM( '자녀', '손자녀', '배우자', '어머니', '아버지', '조부모', '친구', '기타' ) — NOT NULL
- created_at — TIMESTAMP