Schema for osha_enforcement

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