효순이들
테이블 (5)
보행 영상 기록 (video_record)
- video_id — BIGINT — 기본 키 — NOT NULL
- patient_Id — BIGINT — 외래 키 → 환자.patient_Id — NOT NULL
- record_date — DATE — NOT NULL
- AI_walking_updrs_score — DECIMAL(5,2) — NOT NULL
- video_url — TEXT — NOT NULL
- AI_walking_comment — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
복약 기록 (medication_record)
- medication_id — BIGINT — 기본 키 — NOT NULL
- patient_Id — BIGINT — 외래 키 → 환자.patient_Id — NOT NULL
- morning_taken — ENUM("NONE","YES","NO") — NOT NULL
- lunch_taken — ENUM("NONE","YES","NO") — NOT NULL
- dinner_taken — ENUM("NONE","YES","NO") — NOT NULL
- record_date — DATE — NOT NULL
- medication_notes — TEXT
알림 (notification)
- notification_id — BIGINT — 기본 키 — NOT NULL
- patient_Id — BIGINT — 외래 키 → 환자.patient_Id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- is_read — BOOLEAN — NOT NULL
- content — VARCHAR(255) — NOT NULL
- title — VARCHAR(100) — NOT NULL
월별 보고서 (month_report)
- report_id — BIGINT — 기본 키 — NOT NULL
- patient_Id — BIGINT — 외래 키 → 환자.patient_Id — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- ai_comment_summary — TEXT — NOT NULL
- meditation_summary — TEXT
- created_at — DATETIME — NOT NULL
환자 (patient)
- patient_Id — BIGINT — 기본 키 — NOT NULL
- login_id — VARCHAR(20) — NOT NULL
- gender — ENUM('M', 'F') — NOT NULL
- birth — DATE
- medication_status — ENUM('ON','OFF') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- login_password — VARCHAR(60) — NOT NULL