개발공작실 erd

테이블 (3)

admin_accounts

  • login_id — VARCHAR(100) — 기본 키 — NOT NULL
  • password_hash — VARCHAR(60) — NOT NULL

primary_users

  • login_id — VARCHAR(20) — 기본 키 — NOT NULL
  • password_hash — VARCHAR(60) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • birth_date — DATE — NOT NULL
  • gender — ENUM('MALE', 'FEMALE') — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • diagnosis_result — ENUM('NORMAL', 'ABNORMAL')

self_diagnosis_records

  • diagnosis_date — DATE — 기본 키 — NOT NULL
  • login_id (login_id2) — VARCHAR(20) — 외래 키 → primary_users.login_id — NOT NULL
  • diagnosis_result — ENUM('NORMAL', 'ABNORMAL') — NOT NULL
  • selected_symptoms — VARCHAR(64) — NOT NULL
  • body_temperature — DECIMAL(3, 1)
  • vaccination_status — ENUM('VACCINATED', 'NOT_VACCINATED')
  • last_vaccination_date — DATE
  • symptom_onset — VARCHAR(20)
  • acute_respiratory_symptom — ENUM('YES', 'NO')
  • digestive_symptom — ENUM('YES', 'NO')
  • recent_patient_contact — ENUM('YES', 'NO')
  • symptoms_after_contact — ENUM('YES', 'NO')
  • household_infection — ENUM('YES', 'NO')
  • household_member_recovered — ENUM('YES', 'NO')