Reverse Engineer SQL

Tables (7)

hospital_info

  • hpid (hpid2) — VARCHAR(20) — Foreign key → trauma_scores.hpid — NOT NULL
  • bed_type — VARCHAR(20) — Foreign key → trauma_scores.bed_type — NOT NULL
  • hpid (hpid22) — VARCHAR(20) — Foreign key → trauma_scores.hpid — NOT NULL
  • bed_type (bed_type2) — VARCHAR(20) — Foreign key → trauma_scores.bed_type — NOT NULL
  • hpid (hpid23) — VARCHAR(20) — Foreign key → trauma_info.hpid — NOT NULL
  • bed_type (bed_type3) — VARCHAR(20) — Foreign key → trauma_info.bed_type — NOT NULL
  • hpid (hpid222) — VARCHAR(20) — Foreign key → trauma_info.hpid — NOT NULL
  • bed_type (bed_type22) — VARCHAR(20) — Foreign key → trauma_info.bed_type — NOT NULL
  • hpid (hpid232) — VARCHAR(20) — Foreign key → trauma_info.hpid — NOT NULL
  • bed_type (bed_type32) — VARCHAR(20) — Foreign key → trauma_info.bed_type — NOT NULL
  • hpid (hpid2222) — VARCHAR(20) — Foreign key → trauma_info.hpid — NOT NULL
  • bed_type (bed_type222) — VARCHAR(20) — Foreign key → trauma_info.bed_type — NOT NULL
  • hpid — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • tel — VARCHAR(50) — NOT NULL
  • emer_tel — VARCHAR(50)

hospital_list

  • hpid (hpid2) — VARCHAR(20) — Foreign key → hospital_info.hpid — NOT NULL
  • bed_type — VARCHAR(20) — Foreign key → hospital_info.bed_type — NOT NULL
  • hpid (hpid22) — VARCHAR(20) — Foreign key → hospital_info.hpid — NOT NULL
  • bed_type (bed_type2) — VARCHAR(20) — Foreign key → hospital_info.bed_type — NOT NULL
  • hpid (hpid23) — VARCHAR(20) — Foreign key → hospital_info.hpid — NOT NULL
  • bed_type (bed_type3) — VARCHAR(20) — Foreign key → hospital_info.bed_type — NOT NULL
  • hpid (hpid222) — VARCHAR(20) — Foreign key → hospital_info.hpid — NOT NULL
  • bed_type (bed_type22) — VARCHAR(20) — Foreign key → hospital_info.bed_type — NOT NULL
  • hpid (hpid232) — VARCHAR(20) — Foreign key → hospital_info.hpid — NOT NULL
  • bed_type (bed_type32) — VARCHAR(20) — Foreign key → hospital_info.bed_type — NOT NULL
  • hpid (hpid2222) — VARCHAR(20) — Foreign key → hospital_info.hpid — NOT NULL
  • bed_type (bed_type222) — VARCHAR(20) — Foreign key → hospital_info.bed_type — NOT NULL
  • hpid (hpid3) — VARCHAR(20) — Foreign key → hospital_scores.hpid — NOT NULL
  • bed_type (bed_type4) — VARCHAR(20) — Foreign key → hospital_scores.bed_type — NOT NULL
  • hpid (hpid24) — VARCHAR(20) — Foreign key → trauma_list.hpid — NOT NULL
  • bed_type (bed_type5) — VARCHAR(20) — Foreign key → trauma_list.bed_type — NOT NULL
  • hpid (hpid223) — VARCHAR(20) — Foreign key → trauma_list.hpid — NOT NULL
  • bed_type (bed_type23) — VARCHAR(20) — Foreign key → trauma_list.bed_type — NOT NULL
  • hpid — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • latitude — DECIMAL(12,9) — NOT NULL
  • longitude — DECIMAL(12,9) — NOT NULL

hospital_scores

  • hpid — VARCHAR(20) — Primary key — NOT NULL
  • bed_type — VARCHAR(20) — Primary key — NOT NULL
  • available — INT — NOT NULL
  • total — INT — NOT NULL
  • distance — DECIMAL(12,9) — NOT NULL

input

  • hpid — VARCHAR(20) — Foreign key → hospital_scores.hpid — NOT NULL
  • bed_type — VARCHAR(20) — Foreign key → hospital_scores.bed_type — NOT NULL
  • hpid (hpid2) — VARCHAR(20) — Foreign key → hospital_info.hpid — NOT NULL
  • bed_type (bed_type2) — VARCHAR(20) — Foreign key → hospital_info.bed_type — NOT NULL
  • hpid (hpid22) — VARCHAR(20) — Foreign key → hospital_info.hpid — NOT NULL
  • bed_type (bed_type22) — VARCHAR(20) — Foreign key → hospital_info.bed_type — NOT NULL
  • hpid (hpid23) — VARCHAR(20) — Foreign key → hospital_info.hpid — NOT NULL
  • bed_type (bed_type3) — VARCHAR(20) — Foreign key → hospital_info.bed_type — NOT NULL
  • hpid (hpid222) — VARCHAR(20) — Foreign key → hospital_info.hpid — NOT NULL
  • bed_type (bed_type222) — VARCHAR(20) — Foreign key → hospital_info.bed_type — NOT NULL
  • hpid (hpid232) — VARCHAR(20) — Foreign key → hospital_info.hpid — NOT NULL
  • bed_type (bed_type32) — VARCHAR(20) — Foreign key → hospital_info.bed_type — NOT NULL
  • hpid (hpid2222) — VARCHAR(20) — Foreign key → hospital_info.hpid — NOT NULL
  • bed_type (bed_type2222) — VARCHAR(20) — Foreign key → hospital_info.bed_type — NOT NULL
  • input_id — INT — NOT NULL
  • user_id — VARCHAR(20) — NOT NULL
  • latitude — DECIMAL(12,9) — NOT NULL
  • longitude — DECIMAL(12,9) — NOT NULL
  • region — VARCHAR(100) — NOT NULL

trauma_info

  • hpid (hpid2) — VARCHAR(20) — Foreign key → trauma_scores.hpid — NOT NULL
  • bed_type — VARCHAR(20) — Foreign key → trauma_scores.bed_type — NOT NULL
  • hpid (hpid22) — VARCHAR(20) — Foreign key → trauma_scores.hpid — NOT NULL
  • bed_type (bed_type2) — VARCHAR(20) — Foreign key → trauma_scores.bed_type — NOT NULL
  • hpid (hpid23) — VARCHAR(20) — Foreign key → trauma_list.hpid — NOT NULL
  • bed_type (bed_type3) — VARCHAR(20) — Foreign key → trauma_list.bed_type — NOT NULL
  • hpid (hpid222) — VARCHAR(20) — Foreign key → trauma_list.hpid — NOT NULL
  • bed_type (bed_type22) — VARCHAR(20) — Foreign key → trauma_list.bed_type — NOT NULL
  • hpid — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • tel — VARCHAR(50) — NOT NULL
  • emer_tel — VARCHAR(50)

trauma_list

  • hpid (hpid2) — VARCHAR(20) — Foreign key → trauma_scores.hpid — NOT NULL
  • bed_type — VARCHAR(20) — Foreign key → trauma_scores.bed_type — NOT NULL
  • hpid (hpid22) — VARCHAR(20) — Foreign key → trauma_scores.hpid — NOT NULL
  • bed_type (bed_type2) — VARCHAR(20) — Foreign key → trauma_scores.bed_type — NOT NULL
  • hpid — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • latitude — DECIMAL(12,9) — NOT NULL
  • longitude — DECIMAL(12,9) — NOT NULL

trauma_scores

  • hpid — VARCHAR(20) — Primary key — NOT NULL
  • bed_type — VARCHAR(20) — Primary key — NOT NULL
  • hpid (hpid2) — VARCHAR(20) — Foreign key → hospital_scores.hpid — NOT NULL
  • bed_type (bed_type2) — VARCHAR(20) — Foreign key → hospital_scores.bed_type — NOT NULL
  • available — INT — NOT NULL
  • total — INT — NOT NULL
  • distance — DECIMAL(12,9) — NOT NULL