Schema for osha_enforcement

CREATE TABLE "inspection" (
   [activity_nr] INTEGER PRIMARY KEY,
   [reporting_id] INTEGER,
   [state_flag] INTEGER,
   [estab_name] TEXT,
   [site_address] TEXT,
   [site_city] TEXT,
   [site_state] TEXT,
   [site_zip] INTEGER,
   [owner_type] TEXT,
   [owner_code] INTEGER,
   [adv_notice] TEXT,
   [safety_hlth] TEXT,
   [sic_code] INTEGER,
   [naics_code] INTEGER,
   [insp_type] TEXT,
   [insp_scope] TEXT,
   [why_no_insp] TEXT,
   [union_status] TEXT,
   [safety_manuf] TEXT,
   [safety_const] TEXT,
   [safety_marit] TEXT,
   [health_manuf] TEXT,
   [health_const] TEXT,
   [health_marit] TEXT,
   [migrant] TEXT,
   [mail_street] TEXT,
   [mail_city] TEXT,
   [mail_state] TEXT,
   [mail_zip] INTEGER,
   [host_est_key] TEXT,
   [nr_in_estab] INTEGER,
   [open_date] TEXT,
   [case_mod_date] TEXT,
   [close_conf_date] TEXT,
   [close_case_date] TEXT,
   [ld_dt] TEXT
);
CREATE TABLE "event_type" (
   [accident_code] TEXT,
   [accident_number] INTEGER PRIMARY KEY,
   [accident_value] TEXT,
   [accident_letter] INTEGER,
   [load_dt] TEXT
);
CREATE TABLE "fatality" (
   [accident_code] TEXT,
   [accident_number] INTEGER PRIMARY KEY,
   [accident_value] TEXT,
   [accident_letter] INTEGER,
   [load_dt] TEXT
);
CREATE TABLE "operator" (
   [accident_code] TEXT,
   [accident_number] INTEGER PRIMARY KEY,
   [accident_value] TEXT,
   [accident_letter] INTEGER,
   [load_dt] TEXT
);
CREATE TABLE "environmental" (
   [accident_code] TEXT,
   [accident_number] INTEGER PRIMARY KEY,
   [accident_value] TEXT,
   [accident_letter] TEXT,
   [load_dt] TEXT
);
CREATE TABLE "human" (
   [accident_code] TEXT,
   [accident_number] INTEGER PRIMARY KEY,
   [accident_value] TEXT,
   [accident_letter] INTEGER,
   [load_dt] TEXT
);
CREATE TABLE "injury" (
   [accident_code] TEXT,
   [accident_number] INTEGER PRIMARY KEY,
   [accident_value] TEXT,
   [accident_letter] INTEGER,
   [load_dt] TEXT
);
CREATE TABLE "occupation" (
   [accident_code] TEXT,
   [accident_number] INTEGER PRIMARY KEY,
   [accident_value] TEXT,
   [accident_letter] INTEGER,
   [load_dt] TEXT
);
CREATE TABLE "body_part" (
   [accident_code] TEXT,
   [accident_number] INTEGER PRIMARY KEY,
   [accident_value] TEXT,
   [accident_letter] INTEGER,
   [load_dt] TEXT
);
CREATE TABLE "injury_source" (
   [accident_code] TEXT,
   [accident_number] INTEGER PRIMARY KEY,
   [accident_value] TEXT,
   [accident_letter] INTEGER,
   [load_dt] TEXT
);
CREATE TABLE "degree_injury" (
   [accident_code] TEXT,
   [accident_number] INTEGER PRIMARY KEY,
   [accident_value] TEXT,
   [accident_letter] INTEGER,
   [load_dt] TEXT
);
CREATE TABLE "task" (
   [accident_code] TEXT,
   [accident_number] INTEGER PRIMARY KEY,
   [accident_value] TEXT,
   [accident_letter] INTEGER,
   [load_dt] TEXT
);
CREATE TABLE "project_type" (
   [accident_code] TEXT,
   [accident_number] INTEGER,
   [accident_value] TEXT,
   [accident_letter] TEXT PRIMARY KEY,
   [load_dt] TEXT
);
CREATE TABLE "end_use" (
   [accident_code] TEXT,
   [accident_number] INTEGER,
   [accident_value] TEXT,
   [accident_letter] TEXT PRIMARY KEY,
   [load_dt] TEXT
);
CREATE TABLE "cost" (
   [accident_code] TEXT,
   [accident_number] INTEGER,
   [accident_value] TEXT,
   [accident_letter] TEXT PRIMARY KEY,
   [load_dt] TEXT
);
CREATE TABLE "accident" (
   [summary_nr] INTEGER PRIMARY KEY,
   [report_id] INTEGER,
   [event_date] TEXT,
   [event_time] INTEGER,
   [event_desc] TEXT,
   [event_keyword] TEXT,
   [const_end_use] TEXT REFERENCES [end_use]([accident_letter]),
   [build_stories] INTEGER,
   [nonbuild_ht] INTEGER,
   [project_cost] TEXT REFERENCES [cost]([accident_letter]),
   [project_type] TEXT REFERENCES [project_type]([accident_letter]),
   [sic_list] TEXT,
   [fatality] TEXT,
   [state_flag] INTEGER,
   [abstract_text] INTEGER,
   [load_dt] TEXT
);
CREATE TABLE "accident_abstract" (
   [summary_nr] INTEGER REFERENCES [accident]([summary_nr]),
   [line_nr] INTEGER,
   [abstract_text] TEXT,
   [load_dt] TEXT
);
CREATE TABLE "accident_injury" (
   [summary_nr] INTEGER REFERENCES [accident]([summary_nr]),
   [rel_insp_nr] INTEGER REFERENCES [inspection]([activity_nr]),
   [age] INTEGER,
   [sex] TEXT,
   [nature_of_inj] INTEGER REFERENCES [injury]([accident_number]),
   [part_of_body] INTEGER REFERENCES [body_part]([accident_number]),
   [src_of_injury] INTEGER REFERENCES [injury_source]([accident_number]),
   [event_type] INTEGER REFERENCES [event_type]([accident_number]),
   [evn_factor] INTEGER REFERENCES [environmental]([accident_number]),
   [hum_factor] INTEGER REFERENCES [human]([accident_number]),
   [occ_code] INTEGER REFERENCES [occupation]([accident_number]),
   [degree_of_inj] INTEGER REFERENCES [degree_injury]([accident_number]),
   [task_assigned] INTEGER REFERENCES [task]([accident_number]),
   [hazsub] TEXT,
   [const_op] INTEGER REFERENCES [operator]([accident_number]),
   [const_op_cause] INTEGER REFERENCES [operator]([accident_number]),
   [fat_cause] INTEGER REFERENCES [fatality]([accident_number]),
   [fall_distance] INTEGER,
   [fall_ht] INTEGER,
   [injury_line_nr] INTEGER,
   [load_dt] TEXT
);
CREATE TABLE "optional_info" (
   [activity_nr] INTEGER REFERENCES [inspection]([activity_nr]),
   [opt_type] TEXT,
   [opt_id] INTEGER,
   [opt_value] TEXT,
   [opt_info_id] INTEGER,
   [load_dt] TEXT
);
CREATE TABLE "related_activity" (
   [activity_nr] INTEGER REFERENCES [inspection]([activity_nr]),
   [rel_type] TEXT,
   [rel_act_nr] INTEGER,
   [rel_safety] TEXT,
   [rel_health] TEXT,
   [load_dt] TEXT
);
CREATE TABLE "strategic_codes" (
   [activity_nr] INTEGER REFERENCES [inspection]([activity_nr]),
   [prog_type] TEXT,
   [prog_value] TEXT,
   [load_dt] TEXT
);
CREATE TABLE "violation" (
   [activity_nr] INTEGER REFERENCES [inspection]([activity_nr]),
   [citation_id] TEXT,
   [delete_flag] TEXT,
   [standard] TEXT,
   [viol_type] TEXT,
   [issuance_date] TEXT,
   [abate_date] TEXT,
   [abate_complete] TEXT,
   [current_penalty] FLOAT,
   [initial_penalty] FLOAT,
   [contest_date] TEXT,
   [final_order_date] TEXT,
   [nr_instances] INTEGER,
   [nr_exposed] INTEGER,
   [rec] TEXT,
   [gravity] INTEGER,
   [emphasis] TEXT,
   [hazcat] TEXT,
   [fta_insp_nr] INTEGER,
   [fta_issuance_date] TEXT,
   [fta_penalty] FLOAT,
   [fta_contest_date] TEXT,
   [fta_final_order_date] TEXT,
   [hazsub1] TEXT,
   [hazsub2] TEXT,
   [hazsub3] TEXT,
   [hazsub4] TEXT,
   [hazsub5] TEXT,
   [load_dt] TEXT
);
CREATE TABLE "violation_event" (
   [activity_nr] INTEGER REFERENCES [violation]([activity_nr]),
   [citation_id] TEXT,
   [pen_fta] TEXT,
   [hist_event] TEXT,
   [hist_date] TEXT,
   [hist_penalty] FLOAT,
   [hist_abate_date] TEXT,
   [hist_vtype] TEXT,
   [hist_insp_nr] INTEGER,
   [load_dt] TEXT
);
CREATE TABLE "violation_gen_duty_std" (
   [activity_nr] INTEGER REFERENCES [violation]([activity_nr]),
   [citation_id] TEXT,
   [line_nr] INTEGER,
   [line_text] TEXT,
   [load_dt] TEXT
);
CREATE TABLE sqlite_stat1(tbl,idx,stat)