데이터처리와활용_과제_스키마

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