Schema for whisard

CREATE TABLE "cases" (
   [case_id] INTEGER PRIMARY KEY,
   [trade_nm] TEXT,
   [legal_name] TEXT,
   [street_addr_1_txt] TEXT,
   [cty_nm] TEXT,
   [st_cd] TEXT,
   [zip_cd] INTEGER,
   [naic_cd] TEXT,
   [naics_code_description] TEXT,
   [case_violtn_cnt] INTEGER,
   [cmp_assd] FLOAT,
   [ee_violtd_cnt] INTEGER,
   [bw_atp_amt] FLOAT,
   [ee_atp_cnt] INTEGER,
   [findings_start_date] TEXT,
   [findings_end_date] TEXT,
   [flsa_repeat_violator] TEXT,
   [load_dt] TEXT
);
CREATE TABLE "violations" (
   [id] INTEGER PRIMARY KEY,
   [case_id] INTEGER REFERENCES [cases]([case_id]),
   [type] TEXT,
   [violations] INTEGER,
   [back_wages] FLOAT,
   [employees] INTEGER,
   [civil_money_penalty] FLOAT
);
CREATE TABLE "flsa_details" (
   [violation_id] INTEGER REFERENCES [violations]([id]),
   [type] TEXT,
   [back_wages] FLOAT
);
CREATE TABLE sqlite_stat1(tbl,idx,stat)