dataPU

Tables (4)

clinic_record_info

  • clinic_record_id — INT
  • b_patient_id — INT
  • b_doctor_id — INT
  • reservation_date — DATE
  • reservation_time — DATETIME
  • reservation_status — VARCHAR(1)

clinic_reservation_info

  • clinic_reservation_id — INT
  • a_patient_id — INT
  • a_doctor_id — INT
  • reservation_date — DATE
  • reservation_time — DATETIME
  • reservation_status — VARCHAR(1)

doctor_information

  • doctor_id — INT
  • doctor_name — VARCHAR(50)
  • specialized_field — VARCHAR(50)
  • hospital_name — VARCHAR(50)
  • doctor_phone — VARCHAR(30)

patient_information

  • patient_id — INT
  • patient_name — VARCHAR(50)
  • birth_ymd — DATE
  • patient_phone — VARCHAR(30)
  • email — VARCHAR(100)
  • accession — DATETIME