hospital
Tables (26)
badfood
- badfood_num — number(99999) — NOT NULL
- badfood_image — varchar2(100) — NOT NULL
- badfood_name — varchar2(100) — NOT NULL
- badfood_kcal — varchar2(10) — NOT NULL
- badfood_reson — varchar2(1000) — NOT NULL
badfoodbadfood_num
- badfood_num — number(99999) — NOT NULL
- badfood_image — varchar2(100) — NOT NULL
- badfood_name — varchar2(100) — NOT NULL
- badfood_kcal — varchar2(10) — NOT NULL
- badfood_reson — varchar2(1000) — NOT NULL
boardQA
- board_sortnum — number(99999) — NOT NULL
- board_customer_id — references
- board_subject — varchar2(500) — NOT NULL
- board_content — varchar2(4000) — NOT NULL
- board_writedate — Timestamp
- board_replycode — number(1)
- board_reply — varchar2(4000)
boardQAboard_sortnum
- board_sortnum — number(99999) — NOT NULL
- board_customer_id — references
- board_subject — varchar2(500) — NOT NULL
- board_content — varchar2(4000) — NOT NULL
- board_writedate — Timestamp
- board_replycode — number(1)
- board_reply — varchar2(4000)
customer
- customer_num — number(9) — NOT NULL
- customer_id — varchar2(100) — NOT NULL
- customer_pw — varchar2(255) — NOT NULL
- customer_repw — varchar2(100)
- customer_email — varchar2(100) — NOT NULL
- customer_name — varchar2(100) — NOT NULL
- customer_phone — varchar2(100) — NOT NULL
- customer_joindate — Timestamp
- customer_fingerprint — varchar2(1000)
- customer_logindate — Timestamp
- customer_inactive — number(1)
- authority — varchar2(20)
customercustomer_num
- customer_num — number(9) — NOT NULL
- customer_id — varchar2(100) — NOT NULL
- customer_pw — varchar2(255) — NOT NULL
- customer_repw — varchar2(100)
- customer_email — varchar2(100) — NOT NULL
- customer_name — varchar2(100) — NOT NULL
- customer_phone — varchar2(100) — NOT NULL
- customer_joindate — Timestamp
- customer_fingerprint — varchar2(1000)
- customer_logindate — Timestamp
- customer_inactive — number(1)
- authority — varchar2(20)
diagnosis
- diagnosis_num — number(6) — NOT NULL
- diagnosis — Timestamp
- diagnosis_customer_num — references
- diagnosis_customer_name — references
- diseage_code — references
- diagnosis_bp — varchar2(10) — NOT NULL
- diagnosis_rr — varchar2(10) — NOT NULL
- diagnosis_pr — varchar2(10) — NOT NULL
- diagnosis_pt — varchar2(10) — NOT NULL
- diagnosis_cc — varchar2(100) — NOT NULL
- diagnosis_phx — varchar2(100) — NOT NULL
- diagnosis_fhx — varchar2(100) — NOT NULL
- diagnosis_pi — varchar2(1000) — NOT NULL
- diagnosis_ros — varchar2(100) — NOT NULL
- diagnosis_pex — varchar2(1000) — NOT NULL
- diagnosis_ps — varchar2(100)
- diagnosis_ps1 — varchar2(100)
- diagnosis_ps2 — varchar2(100)
- diagnosis_ps3 — varchar2(100)
- diagnosis_ps4 — varchar2(100) — NOT NULL
- customer_payment — number(1)
diagnosisdiagnosis_num
- diagnosis_num — number(6) — NOT NULL
- diagnosis — Timestamp
- diagnosis_customer_num — references
- diagnosis_customer_name — references
- diseage_code — references
- diagnosis_bp — varchar2(10) — NOT NULL
- diagnosis_rr — varchar2(10) — NOT NULL
- diagnosis_pr — varchar2(10) — NOT NULL
- diagnosis_pt — varchar2(10) — NOT NULL
- diagnosis_cc — varchar2(100) — NOT NULL
- diagnosis_phx — varchar2(100) — NOT NULL
- diagnosis_fhx — varchar2(100) — NOT NULL
- diagnosis_pi — varchar2(1000) — NOT NULL
- diagnosis_ros — varchar2(100) — NOT NULL
- diagnosis_pex — varchar2(1000) — NOT NULL
- diagnosis_ps — varchar2(100)
- diagnosis_ps1 — varchar2(100)
- diagnosis_ps2 — varchar2(100)
- diagnosis_ps3 — varchar2(100)
- diagnosis_ps4 — varchar2(100) — NOT NULL
- customer_payment — number(1)
disease
- disease_code — varchar2(20) — NOT NULL
- disease_name — varchar2(100) — NOT NULL
diseasedisease_code
- disease_code — varchar2(20) — NOT NULL
- disease_name — varchar2(100) — NOT NULL
doctor
- doctor_num — number(9) — NOT NULL
- doctor_faceimg — varchar2(100) — NOT NULL
- doctor_id — varchar2(100) — NOT NULL
- doctor_pw — varchar2(255) — NOT NULL
- doctor_name — varchar2(100) — NOT NULL
- doctor_email — varchar2(100) — NOT NULL
- doctor_phone — varchar2(100) — NOT NULL
- doctor_major — varchar2(100) — NOT NULL
- doctor_position — varchar2(100) — NOT NULL
- authority — varchar2(20)
doctordoctor_num
- doctor_num — number(9) — NOT NULL
- doctor_faceimg — varchar2(100) — NOT NULL
- doctor_id — varchar2(100) — NOT NULL
- doctor_pw — varchar2(255) — NOT NULL
- doctor_name — varchar2(100) — NOT NULL
- doctor_email — varchar2(100) — NOT NULL
- doctor_phone — varchar2(100) — NOT NULL
- doctor_major — varchar2(100) — NOT NULL
- doctor_position — varchar2(100) — NOT NULL
- authority — varchar2(20)
drug
- drug_atccode — varchar2(20) — NOT NULL
- drug_name — varchar2(50) — NOT NULL
- drug_enptname — varchar2(50) — NOT NULL
- drug_formulation — varchar2(50) — NOT NULL
- drug_color — varchar2(50) — NOT NULL
- drug_shape — varchar2(50) — NOT NULL
- drug_size_l — varchar2(50) — NOT NULL
- drug_size_s — varchar2(50) — NOT NULL
- drug_size_w — varchar2(50) — NOT NULL
- drug_division — varchar2(20) — NOT NULL
- drug_productimage — varchar2(100) — NOT NULL
- drug_effect — varchar2(1000) — NOT NULL
- drug_dosage — varchar2(1000) — NOT NULL
drugdrug_atccode
- drug_atccode — varchar2(20) — NOT NULL
- drug_name — varchar2(50) — NOT NULL
- drug_enptname — varchar2(50) — NOT NULL
- drug_formulation — varchar2(50) — NOT NULL
- drug_color — varchar2(50) — NOT NULL
- drug_shape — varchar2(50) — NOT NULL
- drug_size_l — varchar2(50) — NOT NULL
- drug_size_s — varchar2(50) — NOT NULL
- drug_size_w — varchar2(50) — NOT NULL
- drug_division — varchar2(20) — NOT NULL
- drug_productimage — varchar2(100) — NOT NULL
- drug_effect — varchar2(1000) — NOT NULL
- drug_dosage — varchar2(1000) — NOT NULL
healthceck3
- healthcheck_hexercise_day — varchar2(10) — NOT NULL
- healthcheck_hexercise_hour — varchar2(10) — NOT NULL
- healthcheck_hexercise_min — varchar2(10) — NOT NULL
- healthcheck_mexercise_day — varchar2(10) — NOT NULL
- healthcheck_mexercise_hour — varchar2(10) — NOT NULL
- healthcheck_mexercise_min — varchar2(10) — NOT NULL
- healthcheck_strengthtraining — varchar2(10) — NOT NULL
healthceck3healthcheck_hexercise_day
- healthcheck_hexercise_day — varchar2(10) — NOT NULL
- healthcheck_hexercise_hour — varchar2(10) — NOT NULL
- healthcheck_hexercise_min — varchar2(10) — NOT NULL
- healthcheck_mexercise_day — varchar2(10) — NOT NULL
- healthcheck_mexercise_hour — varchar2(10) — NOT NULL
- healthcheck_mexercise_min — varchar2(10) — NOT NULL
- healthcheck_strengthtraining — varchar2(10) — NOT NULL
healthcheck
- healthcheck_customer_num — references
- healthcheck_customer_email — references
- healthcheck_customer_phone — references
- healthcheck_phx_stroke_diagnosis — number(1) — NOT NULL
- healthcheck_phx_stroke_medication — number(1) — NOT NULL
- healthcheck_phx_myocardial_diagnosis — number(1) — NOT NULL
- healthcheck_phx_myocardial_medication — number(1) — NOT NULL
- healthcheck_phx_bp_diagnosis — number(1) — NOT NULL
- healthcheck_phx_bp_medication — number(1) — NOT NULL
- healthcheck_phx_diabetes_diagnosis — number(1) — NOT NULL
- healthcheck_phx_diabetes_medication — number(1) — NOT NULL
- healthcheck_phx_dyslipidemia_diagnosis — number(1) — NOT NULL
- healthcheck_phx_dyslipidemia_medication — number(1) — NOT NULL
- healthcheck_phx_tuberculosis_diagnosis — number(1) — NOT NULL
- healthcheck_phx_tuberculosis_medication — number(1) — NOT NULL
- healthcheck_phx_etc_diagnosis — number(1) — NOT NULL
- healthcheck_phx_etc_medication — number(1) — NOT NULL
- healthcheck_fhx_stroke_diagnosis — number(1) — NOT NULL
- healthcheck_fhx_myocardial_diagnosis — number(1) — NOT NULL
- healthcheck_fhx_bp_diagnosis — number(1) — NOT NULL
- healthcheck_fhx_diabetes_diagnosis — number(1) — NOT NULL
- healthcheck_fhx_etc_diagnosis — number(1) — NOT NULL
- healthcheck_hepatitis_diagnosis — number(1) — NOT NULL
healthcheck1
- healthcheck_smoke_diagnosis — number(1) — NOT NULL
- healthcheck_smoke_ayear — varchar2(10) — NOT NULL
- healthcheck_smoke_acount — varchar2(10) — NOT NULL
- healthcheck_smoke_nyear — varchar2(10) — NOT NULL
- healthcheck_smoke_ncount — varchar2(10) — NOT NULL
- healthcheck_esmoke_use — number(1) — NOT NULL
- healthcheck_esmoke_year — number(1) — NOT NULL
healthcheck1healthcheck_smoke_diagnosis
- healthcheck_smoke_diagnosis — number(1) — NOT NULL
- healthcheck_smoke_ayear — varchar2(10) — NOT NULL
- healthcheck_smoke_acount — varchar2(10) — NOT NULL
- healthcheck_smoke_nyear — varchar2(10) — NOT NULL
- healthcheck_smoke_ncount — varchar2(10) — NOT NULL
- healthcheck_esmoke_use — number(1) — NOT NULL
- healthcheck_esmoke_year — number(1) — NOT NULL
healthcheck2
- healthcheck_drink_week — varchar2(10) — NOT NULL
- healthcheck_drink_month — varchar2(10) — NOT NULL
- healthcheck_drink_year — varchar2(10) — NOT NULL
- healthcheck_drink_not — varchar2(10) — NOT NULL
- healthcheck_drink_sdcount — varchar2(10) — NOT NULL
- healthcheck_drink_mdcount — varchar2(10) — NOT NULL
- healthcheck_drink_bdcount — varchar2(10) — NOT NULL
- healthcheck_drink_brdcount — varchar2(10) — NOT NULL
- healthcheck_drink_wdcount — varchar2(10) — NOT NULL
- healthcheck_drink_smcount — varchar2(10) — NOT NULL
- healthcheck_drink_mmcount — varchar2(10) — NOT NULL
- healthcheck_drink_bmcount — varchar2(10) — NOT NULL
- healthcheck_drink_brmcount — varchar2(10) — NOT NULL
- healthcheck_drink_wmcount — varchar2(10) — NOT NULL
healthcheck2healthcheck_drink_week
- healthcheck_drink_week — varchar2(10) — NOT NULL
- healthcheck_drink_month — varchar2(10) — NOT NULL
- healthcheck_drink_year — varchar2(10) — NOT NULL
- healthcheck_drink_not — varchar2(10) — NOT NULL
- healthcheck_drink_sdcount — varchar2(10) — NOT NULL
- healthcheck_drink_mdcount — varchar2(10) — NOT NULL
- healthcheck_drink_bdcount — varchar2(10) — NOT NULL
- healthcheck_drink_brdcount — varchar2(10) — NOT NULL
- healthcheck_drink_wdcount — varchar2(10) — NOT NULL
- healthcheck_drink_smcount — varchar2(10) — NOT NULL
- healthcheck_drink_mmcount — varchar2(10) — NOT NULL
- healthcheck_drink_bmcount — varchar2(10) — NOT NULL
- healthcheck_drink_brmcount — varchar2(10) — NOT NULL
- healthcheck_drink_wmcount — varchar2(10) — NOT NULL
healthcheckhealthcheck_customer_num
- healthcheck_customer_num — references
- healthcheck_customer_email — references
- healthcheck_customer_phone — references
- healthcheck_phx_stroke_diagnosis — number(1) — NOT NULL
- healthcheck_phx_stroke_medication — number(1) — NOT NULL
- healthcheck_phx_myocardial_diagnosis — number(1) — NOT NULL
- healthcheck_phx_myocardial_medication — number(1) — NOT NULL
- healthcheck_phx_bp_diagnosis — number(1) — NOT NULL
- healthcheck_phx_bp_medication — number(1) — NOT NULL
- healthcheck_phx_diabetes_diagnosis — number(1) — NOT NULL
- healthcheck_phx_diabetes_medication — number(1) — NOT NULL
- healthcheck_phx_dyslipidemia_diagnosis — number(1) — NOT NULL
- healthcheck_phx_dyslipidemia_medication — number(1) — NOT NULL
- healthcheck_phx_tuberculosis_diagnosis — number(1) — NOT NULL
- healthcheck_phx_tuberculosis_medication — number(1) — NOT NULL
- healthcheck_phx_etc_diagnosis — number(1) — NOT NULL
- healthcheck_phx_etc_medication — number(1) — NOT NULL
- healthcheck_fhx_stroke_diagnosis — number(1) — NOT NULL
- healthcheck_fhx_myocardial_diagnosis — number(1) — NOT NULL
- healthcheck_fhx_bp_diagnosis — number(1) — NOT NULL
- healthcheck_fhx_diabetes_diagnosis — number(1) — NOT NULL
- healthcheck_fhx_etc_diagnosis — number(1) — NOT NULL
- healthcheck_hepatitis_diagnosis — number(1) — NOT NULL
hospital_reservation
- reservation_num — number(9) — NOT NULL
- reservation_date — Timestamp
- reservation_customer_num — references
- reservation_customer_name — references
- reservation_doctor_num — references
hospital_reservationreservation_num
- reservation_num — number(9) — NOT NULL
- reservation_date — Timestamp
- reservation_customer_num — references
- reservation_customer_name — references
- reservation_doctor_num — references
payment
- payment_num — number(999999) — NOT NULL
- payment_customer_id — references
- payment_diagnosis_num — references
paymentpayment_num
- payment_num — number(999999) — NOT NULL
- payment_customer_id — references
- payment_diagnosis_num — references