개발공작실 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')