데이터처리와활용_과제_스키마
테이블 (10)
Appointment
- AppointmentID — INT
- PatientID — INT
- DoctorID — INT
- AppointmentDate — DATE
- AppointmentTime — TIME
- Status — VARCHAR(50)
Department
- DepartmentID — INT
- Name — VARCHAR(100)
- Description — TEXT
- PhoneNumber — VARCHAR(20)
- Location — VARCHAR(100)
Doctor
- DoctorID — INT
- Name — VARCHAR(100)
- Specialty — VARCHAR(100)
- HospitalName — VARCHAR(100)
- PhoneNumber — VARCHAR(20)
- DepartmentID — INT
MedicalRecord
- RecordID — INT
- PatientID — INT
- DoctorID — INT
- ConsultationDate — DATE
- Diagnosis — TEXT
- Prescription — TEXT
Patient
- PatientID — INT
- Name — VARCHAR(100)
- BirthDate — DATE
- PhoneNumber — VARCHAR(20)
- Email — VARCHAR(100)
- JoinDate — DATE
appointment
- appointment_id — INT
- 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 — INTEGER — NOT NULL
- depart_name — VARCHAR
- description — TEXT
- phone_number — NUMBER
- location — VARCHAR
doctor
- doctor_id — INTEGER — NOT NULL
- name — VARCHAR
- specailty — VARCHAR
- hospitalname — VARCHAR
- phonenumber — VARCHAR
- gender — VARCHAR
- email — VARCHAR
- licenseNumber — INTEGER
- availableDays — VARCHAR
- isonduty — BOOLEAN
medical_record
- record_id — INT
- 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
- name — VARCHAR(100) — NOT NULL
- birthdate — DATE
- phone_number — VARCHAR(20)
- email — VARCHAR(100)
- join_date — DATE
- gender — VARCHAR(10)
- address — VARCHAR(200)
- is_active — BOOLEAN