Schema for whisard

CREATE TABLE cases(case_id BIGINT, trade_nm VARCHAR, legal_name VARCHAR, street_addr_1_txt VARCHAR, cty_nm VARCHAR, st_cd VARCHAR, zip_cd BIGINT, naic_cd VARCHAR, naics_code_description VARCHAR, case_violtn_cnt BIGINT, cmp_assd DOUBLE, ee_violtd_cnt BIGINT, bw_atp_amt DOUBLE, ee_atp_cnt BIGINT, findings_start_date DATE, findings_end_date DATE, flsa_repeat_violator VARCHAR, load_dt TIMESTAMP, PRIMARY KEY(case_id));
CREATE TABLE flsa_details(violation_id BIGINT, "type" VARCHAR, back_wages DOUBLE, FOREIGN KEY (violation_id) REFERENCES violations(id));
CREATE TABLE violations(id BIGINT, case_id BIGINT, "type" VARCHAR, violations BIGINT, back_wages DOUBLE, employees BIGINT, civil_money_penalty DOUBLE, PRIMARY KEY(id), FOREIGN KEY (case_id) REFERENCES cases(case_id));