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