효순이들

테이블 (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