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