정규화

테이블 (5)

appointment

  • appointment_id — INT
  • patient_id — INT
  • doctor_id — INT
  • department_id — INT
  • 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
  • depart_name — VARCHAR(100)
  • description — TEXT
  • phone_number — VARCHAR(20)
  • location — VARCHAR(100)

doctor

  • doctor_id — INT
  • department_id — INT
  • 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
  • patient_id — INT
  • doctor_id — INT
  • department_id — INT
  • consultation_date — DATE
  • diagnosis — TEXT
  • prescription — TEXT
  • symptoms — TEXT
  • followup_date — DATE
  • created_by — VARCHAR(100)

patient

  • patient_id — INT
  • name — VARCHAR(100)
  • birthdate — DATE
  • phone_number — VARCHAR(20)
  • email — VARCHAR(100)
  • join_date — DATE
  • gender — VARCHAR(10)
  • address — VARCHAR(200)
  • is_active — BOOLEAN