정규화_2
테이블 (5)
appointment
- appointment_id — INT — 기본 키 — NOT NULL
- patient_id — INT — NOT NULL
- doctor_id — INT — NOT NULL
- department_id — INT — NOT NULL
- appointment_date — DATE
- appointment_time — TIME
- status — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- first_visit — BOOLEAN
- payment_status — VARCHAR(50)
- reservation_method — VARCHAR(50)
department
- department_id — INT — 기본 키 — NOT NULL
- depart_name — VARCHAR(100)
- description — TEXT
- phone_number — VARCHAR(20)
- location — VARCHAR(100)
doctor
- doctor_id — INT — 기본 키 — NOT NULL
- department_id — INT — NOT NULL
- name — VARCHAR(100)
- specialty — VARCHAR(100)
- hospital_name — VARCHAR(100)
- phone_number — VARCHAR(20)
- gender — VARCHAR(10)
- email — VARCHAR(100)
- license_number — VARCHAR(50)
- available_days — VARCHAR(50)
- is_on_duty — BOOLEAN
medical_record
- record_id — INT — 기본 키 — NOT NULL
- patient_id — INT — NOT NULL
- doctor_id — INT — NOT NULL
- department_id — INT — NOT NULL
- consultation_date — DATE
- diagnosis — TEXT
- prescription — TEXT
- symptoms — TEXT
- followup_date — DATE
- created_by — VARCHAR(100)
patient
- patient_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(100)
- birthdate — DATE
- phone_number — VARCHAR(20)
- email — VARCHAR(100)
- join_date — DATE
- gender — VARCHAR(10)
- address — VARCHAR(200)
- is_active — BOOLEAN