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