Schema for cats

CREATE TABLE c_10k(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, disposition_method VARCHAR, disposition_date DATE, disposition_timing VARCHAR, board_work_awarded VARCHAR, board_deter_date DATE);
CREATE TABLE c_advice(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, advice_submission DATE, advice_rcvd_submission DATE, advice_scope VARCHAR, advice_memo_date DATE, advice_deter_rcvd_reg DATE, file_received_advice DATE);
CREATE TABLE c_alj_decision(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, brief_due_date DATE, eot_request_rcvd_alj DATE, eot_brief_party VARCHAR, eot_deter_date DATE, eot_determination VARCHAR, alj_date_filed DATE, alj_brief_rcvd_region DATE, alj_brief_party VARCHAR, alj_brief_type VARCHAR, determination_date DATE, determination VARCHAR);
CREATE TABLE c_alj_decision_bb(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, blue_book_code VARCHAR);
CREATE TABLE c_alj_motion(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, date_filed DATE, motion_type BIGINT, party_filing VARCHAR, determination_date DATE, motion_determination VARCHAR);
CREATE TABLE c_alleg_action(c_case_number VARCHAR, allegation_sequence BIGINT, "sequence" BIGINT, action_result VARCHAR, action_date TIMESTAMP, action_type VARCHAR);
CREATE TABLE c_allegation(c_case_number VARCHAR, allegation_sequence BIGINT, nlra_section VARCHAR, allegation_keyname VARCHAR);
CREATE TABLE c_amendment(c_case_number VARCHAR, "sequence" BIGINT, amendment_date DATE, amendment_type VARCHAR, amendment_reason VARCHAR);
CREATE TABLE c_appeal(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, appeal_expiration_date DATE, eot_date_filed DATE, eot_party VARCHAR, eot_date_determination DATE, eot_determination VARCHAR, appeal_date_filed DATE, appeal_action VARCHAR, appeal_rcvd_in_region DATE, appeal_file_oa DATE, appeal_rcvd_oa DATE, appeal_file_rtrn_reg DATE, appeal_file_rcvd_reg DATE, appeal_date_determination DATE, appeal_determination VARCHAR, appeal_party VARCHAR);
CREATE TABLE c_bankruptcy(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, bank_pet_filed DATE, bank_pet_party VARCHAR, bank_pet_court BIGINT, bank_pet_case_num VARCHAR, bank_pet_type VARCHAR, poc_bar_date DATE, poc_category VARCHAR, poc_date DATE, dis_bank_date DATE, dis_bank_act VARCHAR, chapter_11_approved DATE, amount_claimed DOUBLE, amount_received DOUBLE);
CREATE TABLE c_board_dec_bb(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, blue_book_code VARCHAR);
CREATE TABLE c_board_decision(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, transfer_order_date DATE, exception_due_date DATE, exceptions_eot_date_filed DATE, exceptions_eot_party_filing VARCHAR, exceptions_eot_deter_date DATE, exceptions_eot_determination VARCHAR, oral_arg_req DATE, oral_argument_req_party VARCHAR, oral_arg_order_date VARCHAR, oral_arg_sch_date DATE, oral_arg_date VARCHAR, exceptions_date_filed DATE, decision_date DATE, date_received_region DATE, determination VARCHAR, citation VARCHAR, request_date DATE, request_party VARCHAR, request_deter_date DATE, request_determination VARCHAR, motion_eot_date_filed VARCHAR, motion_eot_party_filing VARCHAR, motion_eot_deter_date VARCHAR, motion_eot_determination VARCHAR);
CREATE TABLE c_board_other_motions(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, other_motion_date DATE, other_motion_party VARCHAR, other_motion_type VARCHAR, other_motion_deter_date DATE, other_motion_deter VARCHAR);
CREATE TABLE c_case(c_case_number VARCHAR, status VARCHAR, nlrb_office_id BIGINT, case_type VARCHAR, docket_num BIGINT, case_suffix_num BIGINT, case_name VARCHAR, date_filed DATE, date_closed DATE, disposition_due DATE, disposition_accomplished VARCHAR, charged_party_on_charge VARCHAR, charging_party_on_charge VARCHAR, inquiry_id VARCHAR, employer_involved_on_charge VARCHAR, io_assist VARCHAR, naics_code BIGINT, num_8a3_discriminatees BIGINT, num_8b2_discriminatees BIGINT, num_employees BIGINT, postal VARCHAR, investigation_complete DATE, disposition_date DATE, dispute_loc_city VARCHAR, dispute_loc_state VARCHAR, dispute_loc_county BIGINT, dispute_loc_zip VARCHAR);
CREATE TABLE c_case_case_group(c_case_group_id VARCHAR, c_case_number VARCHAR, "sequence" BIGINT, lead VARCHAR, date_case_added TIMESTAMP, date_case_removed DATE);
CREATE TABLE c_case_group(c_case_group_id VARCHAR, case_group_type VARCHAR, date_dissolved DATE, date_created DATE);
CREATE TABLE c_closing(c_case_number VARCHAR, action_sequence BIGINT, date_closed DATE, close_method VARCHAR, close_timing VARCHAR, date_file_sent_archives DATE, date_file_to_records TIMESTAMP, date_file_destroyed DATE, preclosing_letter DATE, notice_of_closing_date DATE);
CREATE TABLE c_collection_activities(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, liens_filed_date VARCHAR, liens_filed_court BIGINT, liens_filed_amount DOUBLE, liens_filed_citation VARCHAR, escrow_established VARCHAR, escrow_location VARCHAR, escrow_terms VARCHAR, garnishment_date DATE, garnishment_party VARCHAR, garnishment_court BIGINT, garnishment_citation VARCHAR);
CREATE TABLE c_complaint(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, issued DATE, contain_noh VARCHAR, answer_to_complaint DATE, date_of_withdrawal_order DATE);
CREATE TABLE c_compliance_goals(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, letter_date DATE, letter_type VARCHAR, posting_goal DATE, not_post_party VARCHAR, posting_type VARCHAR, notices_post_dates DATE, post_expires DATE, reinstatement_goal DATE, reinstatement_offered DATE, closing_goal DATE, backpay_received DATE);
CREATE TABLE c_compliance_spec(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, comp_spec_issued DATE, backpay_estimate_number BIGINT, backpay_estimate_amount DOUBLE, date_spec_answer_received DATE, date_spec_withdrawn VARCHAR, date_sw_approved DATE, sw_action VARCHAR, "scope" VARCHAR, sw_participation VARCHAR);
CREATE TABLE c_contempt(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, petition_date DATE, brief_rcvd_date VARCHAR, brief_rcvd_party VARCHAR, brief_pleading VARCHAR, oral_arg_sch_date VARCHAR, oral_arg_date VARCHAR, court_deter_date DATE, court_action_type VARCHAR, court_action_action VARCHAR, som_date_deter VARCHAR, som_determination VARCHAR, som_filed VARCHAR, request_date VARCHAR, request_party VARCHAR, request_deter_date VARCHAR, request_determination BIGINT, date_received_region DATE, citation VARCHAR, court BIGINT, eot_date_filed BIGINT, eot_party BIGINT, eot_determination_date BIGINT, eot_determination BIGINT, date_settlement_approved VARCHAR, settlement_type VARCHAR);
CREATE TABLE c_deferral(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, request_party VARCHAR, request_received DATE, "scope" VARCHAR, date_deferral_issued DATE, deferral_type VARCHAR, date_deferral_checked DATE, date_deferral_extended DATE, willingness_date DATE, willingness_type VARCHAR, date_processing_resumed DATE);
CREATE TABLE c_discovery(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, district_court_date VARCHAR, district_court_court BIGINT, district_court_citation VARCHAR, date_subpoena_issued VARCHAR, date_subpoena_answered VARCHAR, discovery_initiated VARCHAR, party VARCHAR, accordance_with BIGINT, interrogatories VARCHAR, court_action VARCHAR, court_determination VARCHAR);
CREATE TABLE c_dismissal(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, revoked_reason VARCHAR, date_issued DATE, "scope" VARCHAR, revoked_date DATE, adjusted VARCHAR);
CREATE TABLE c_enforcement(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, petition_date DATE, petition_party VARCHAR, petition_court BIGINT, brief_rcvd_date DATE, brief_rcvd_party VARCHAR, brief_pleading VARCHAR, oral_arg_sch_date DATE, oral_arg_date DATE, court_deter_date DATE, court_action_type VARCHAR, court_action_action BIGINT, case_citation VARCHAR, som_date DATE, som_determination VARCHAR, request_date DATE, request_party VARCHAR, request_deter_date DATE, request_determination BIGINT, date_received_region DATE, som_date_deter VARCHAR, eot_date_filed BIGINT, eot_party BIGINT, eot_determination_date BIGINT, eot_determination BIGINT, date_settlement_approved DATE, settlement_type VARCHAR);
CREATE TABLE c_hearing(c_case_number VARCHAR, hearing_type VARCHAR, action_sequence BIGINT, recurrence BIGINT, scheduled_hearing_date DATE, hearing_opened DATE, hearing_closed DATE, record_form VARCHAR, date_notice_issued DATE, date_rescheduled_issued DATE, p_p_rcvd_region DATE, p_p_deter_source VARCHAR, p_p_determination VARCHAR, p_p_party VARCHAR, p_p_deter_date DATE, hearing_days_on_record BIGINT, length_of_transcript BIGINT, hearing_time VARCHAR, hearing_city VARCHAR, hearing_state VARCHAR, hearing_address VARCHAR);
CREATE TABLE c_impact_category(c_case_number VARCHAR, history_sequence BIGINT, determination_due_date DATE, disposition_due_date DATE, investigation BIGINT, investigation_date DATE, litigation BIGINT, litigation_date DATE, compliance BIGINT, compliance_date DATE);
CREATE TABLE c_inj_10j_appeal(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, appeal_date DATE, appeal_party VARCHAR, appeal_court BIGINT, appellate_date VARCHAR, appellate_decision VARCHAR, appellage_citation VARCHAR);
CREATE TABLE c_injunction_10j(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, advice_submit_board DATE, board_determination VARCHAR, board_deter_date DATE, board_rcvd_region DATE, reason_cease VARCHAR, cease_action_date DATE, pet_10j_court BIGINT, pet_10j_filed_date DATE, pet_10j_court_case_name VARCHAR, pet_10j_withdrawn_date VARCHAR, date_answer_resp_rcvd DATE, brief_10j_party VARCHAR, brief_10j_type VARCHAR, brief_10j_date DATE, brief_10j_rcvd_region DATE, motion_filed DATE, motion_filing_party VARCHAR, motion_type VARCHAR, motion_determination BIGINT, motion_deter_date DATE, discovery_request_date DATE, discovery_request_party VARCHAR, discovery_type VARCHAR, discovery_co_date DATE, hearing_ordered DATE, hearing_scheduled DATE, hearing_opened DATE, hearing_closed DATE, hearing_days BIGINT, hearing_evidence_type VARCHAR, co_judgement_type VARCHAR, co_order_type VARCHAR, co_judgement_date DATE, co_court BIGINT, final_disposition_10j VARCHAR, final_dispostion_filed DATE, tro_granted DATE, date_charged_party_notified DATE);
CREATE TABLE c_injunction_10l(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, brief_10l_type BIGINT, brief_10l_party VARCHAR, brief_10l_date DATE, brief_10l_rcvd_region VARCHAR, motion_type BIGINT, motion_filed VARCHAR, motion_filing_party VARCHAR, motion_determination BIGINT, motion_deter_date VARCHAR, discovery_request_date BIGINT, discovery_request_party BIGINT, discovery_type BIGINT, discovery_co_date BIGINT, pet_10l_filed_date VARCHAR, pet_10l_court BIGINT, pet_court_case_name VARCHAR, pet_10l_withdrawn VARCHAR, answer_10l_rcvd_region VARCHAR, hearing_10l_ordered VARCHAR, hearing_10l_scheduled VARCHAR, hearing_10l_opened VARCHAR, hearing_10l_closed VARCHAR, hearing_days BIGINT, hearing_evidence_type VARCHAR, co_determination_type VARCHAR, co_order_type VARCHAR, co_deter_date VARCHAR, co_court_issuing BIGINT, appeal_date VARCHAR, appeal_party VARCHAR, appeal_court BIGINT, appellate_date VARCHAR, appellate_decision VARCHAR, appellate_citation VARCHAR, final_disposition_10l VARCHAR, final_disposition_filed VARCHAR, cease_action_date VARCHAR, reason_cease VARCHAR, tro_granted VARCHAR);
CREATE TABLE c_motion_summ_judge(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, rcvd_board_date DATE, motion_party VARCHAR, motion_basis VARCHAR, notice_show_cause_date DATE, notice_reply_due_date DATE, notice_eot_request_rcvd VARCHAR, notice_eot_party VARCHAR, notice_eot_date_deter VARCHAR, notice_eot_determination VARCHAR, notice_reply_recv_board DATE, notice_reply_party VARCHAR);
CREATE TABLE c_motions_affect_cmp(c_case_number VARCHAR, action_sequence BIGINT, motion_date DATE, motion_forum VARCHAR, motion_type BIGINT, title VARCHAR, motion_party VARCHAR, determination_date DATE, motion_determination VARCHAR);
CREATE TABLE c_participant(c_case_number VARCHAR, participant_id BIGINT, participant_group VARCHAR, participant_role VARCHAR, name_for_correspondence VARCHAR, name_prefix VARCHAR, first_name VARCHAR, mid_name VARCHAR, last_name VARCHAR, name_suffix VARCHAR, street_address_1 VARCHAR, street_address_2 VARCHAR, city VARCHAR, state VARCHAR, zip VARCHAR, phone_num VARCHAR, phone_ext VARCHAR, cell_phone VARCHAR, fax_num VARCHAR, e_mail_address VARCHAR, formal_name VARCHAR, parent_name VARCHAR, exclusive_service VARCHAR, afl_cio VARCHAR, incumbent_union VARCHAR, labor_org_code BIGINT, local_dist_id VARCHAR, party_scope VARCHAR, parti_type VARCHAR);
CREATE TABLE c_r_block(c_case_number VARCHAR, "sequence" BIGINT, r_case_number VARCHAR);
CREATE TABLE c_regional_compliance(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, date_assigned DATE);
CREATE TABLE c_regional_deter(action_sequence VARCHAR, recurrence BIGINT, organizational_campaign VARCHAR, strike_in_same_unit VARCHAR);
CREATE TABLE c_reopening(c_case_number VARCHAR, action_sequence BIGINT, reopen_date DATE, reopen_reason VARCHAR);
CREATE TABLE c_settlement(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, proposal_letter_sent_date DATE, proposed_approval__date DATE, inf_settle_approved DATE, inf_settle_participation VARCHAR, inf_settle_scope VARCHAR, inf_settle_revoked DATE, fs_settlement_sent_ops DATE, fs_submitted_to BIGINT, formal_scope VARCHAR, fs_board_determination VARCHAR, fs_determination_date DATE, determination_rcvd_reg DATE, formal_participation VARCHAR);
CREATE TABLE c_sup_aljd_cmp(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, brief_due_date DATE, eot_request_rcvd_alj DATE, eot_brief_party VARCHAR, eot_brief_deter_date DATE, eot_brief_determination VARCHAR, alj_brief_rcvd_region DATE, alj_brief_party VARCHAR, eot_brief_type BIGINT, alj_brief_rcvd_alj DATE, alj_date_filed DATE, aljd_comp_date DATE, aljd_comp_determination BIGINT);
CREATE TABLE c_sup_board_dec_cmp(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, transfer_order_date DATE, exception_due DATE, exceptions_eot_date_filed DATE, exceptions_eot_party_filing VARCHAR, exceptions_eot_deter_date DATE, exceptions_eot_determination VARCHAR, oral_arg_req VARCHAR, oral_argument_req_party VARCHAR, oral_arg_order_date VARCHAR, oral_arg_sch_date VARCHAR, oral_arg_date VARCHAR, exception_filed DATE, exception_party VARCHAR, bd_issued DATE, determination VARCHAR, date_received_region DATE, bd_citation VARCHAR, bd_reinstated_num BIGINT, bd_pref_hire_num BIGINT, bd_made_whole_num BIGINT, bd_total_backpay DOUBLE, bd_fees_awarded DOUBLE, bd_fines_awarded DOUBLE, bd_contributions_awarded DOUBLE, bd_other_awarded DOUBLE, request_date VARCHAR, request_party VARCHAR, request_deter_date VARCHAR, request_determination VARCHAR, motion_eot_date_filed BIGINT, motion_eot_party_filing BIGINT, motion_eot_deter_date BIGINT, motion_eot_determination BIGINT);
CREATE TABLE c_supreme_court(c_case_number VARCHAR, action_sequence BIGINT, supct_reinstated_num BIGINT, supct_prf_hire_num BIGINT, supct_made_whole_num BIGINT, supct_total_backpay DOUBLE, supct_fees_awarded DOUBLE, supct_fines_awarded BIGINT, supct_cont_awarded BIGINT, supct_other_awarded BIGINT, gc_cert_rec_date DATE, petition_cert_date DATE, petition_cert_party VARCHAR, oral_argument_scheduled VARCHAR, oral_argument_held VARCHAR, decision_date DATE, decision VARCHAR, citation VARCHAR, certiorari_board_date_deter DATE, date_received_region DATE, date_pet_determination VARCHAR, pet_determination VARCHAR);
CREATE TABLE c_transfer_history(c_case_number VARCHAR, history_date TIMESTAMP, "sequence" BIGINT, date_data_received TIMESTAMP, request_date TIMESTAMP, reason_transfer VARCHAR, transfer_type VARCHAR, transfer_order_date DATE, new_case_number VARCHAR, former_case_number VARCHAR, sent_date DATE, received_date DATE);
CREATE TABLE cl_c_closed_case_report(c_case_number VARCHAR, action_sequence BIGINT, washington_approval VARCHAR, compliance_type VARCHAR, closing_type VARCHAR, complaint VARCHAR, enforcement_recommend VARCHAR, contempt_recommended_type VARCHAR, emprein_num_discrim BIGINT, emprein_num_accept BIGINT, emprein_num_waiving BIGINT, emprein_num_decline BIGINT, emprein_num_pref_list BIGINT, unionres_num_hall_rights BIGINT, unionres_obj_with BIGINT, unionres_hired BIGINT, back_number_made_whole BIGINT, back_total_num_rcv BIGINT, back_total_amount_due DOUBLE, back_total_employer DOUBLE, back_total_union DOUBLE, fees_num_individuals BIGINT, fees_total_due DOUBLE, fees_total_employers DOUBLE, fees_total_union DOUBLE, other_post_notice VARCHAR, other_company_post DATE, other_union_post DATE, other_withdraw_assistance VARCHAR, other_withdraw_notice VARCHAR, other_disestablish VARCHAR, other_disestablish_notice VARCHAR, other_end_picketing VARCHAR, other_end_picketing_date DATE, other_end_picketing_return BIGINT, other_end_stoppage VARCHAR, other_end_stoppage_date DATE, other_end_stoppage_return BIGINT, other_bargain VARCHAR, other_bargain_status VARCHAR, backpay_control_code VARCHAR, back_installment_flag VARCHAR, court_costs VARCHAR, court_costs_amount DOUBLE, court_costs_collected DOUBLE, check_forwarded_finance DATE, other_remedies VARCHAR, cmp_cp_position VARCHAR, agent VARCHAR, regional_attorney VARCHAR, regional_director VARCHAR);
CREATE TABLE cl_c_closed_case_report_alleg(c_case_number VARCHAR, action_sequence BIGINT, nlra_section VARCHAR);
CREATE TABLE cl_c_withdrawal(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, disposition_date DATE, disposition VARCHAR, "scope" VARCHAR, conditional VARCHAR, solicited VARCHAR, adjusted VARCHAR, revoked_date DATE, revoked_reason VARCHAR);
CREATE TABLE l_allegation_type(nlra_section VARCHAR, allegation_keyname VARCHAR, case_type VARCHAR, description VARCHAR);
CREATE TABLE l_blue_book_chapter(bb_chapter BIGINT, bb_division BIGINT, description VARCHAR, PRIMARY KEY(bb_chapter), FOREIGN KEY (bb_division) REFERENCES l_blue_book_division(bb_division));
CREATE TABLE l_blue_book_codes(blue_book_code VARCHAR, bb_section BIGINT, bb_heading BIGINT, bb_chapter BIGINT, bb_division BIGINT, description VARCHAR, PRIMARY KEY(blue_book_code), FOREIGN KEY (bb_chapter) REFERENCES l_blue_book_chapter(bb_chapter), FOREIGN KEY (bb_division) REFERENCES l_blue_book_division(bb_division));
CREATE TABLE l_blue_book_division(bb_division BIGINT, description VARCHAR, PRIMARY KEY(bb_division));
CREATE TABLE l_blue_book_heading(bb_heading BIGINT, bb_chapter BIGINT, bb_division BIGINT, description VARCHAR, PRIMARY KEY(bb_heading, bb_chapter, bb_division), FOREIGN KEY (bb_chapter) REFERENCES l_blue_book_chapter(bb_chapter), FOREIGN KEY (bb_division) REFERENCES l_blue_book_division(bb_division));
CREATE TABLE l_blue_book_section(bb_section BIGINT, bb_heading BIGINT, bb_chapter BIGINT, bb_division BIGINT, description VARCHAR, PRIMARY KEY(bb_section, bb_heading, bb_chapter, bb_division), FOREIGN KEY (bb_chapter) REFERENCES l_blue_book_chapter(bb_chapter), FOREIGN KEY (bb_division) REFERENCES l_blue_book_division(bb_division));
CREATE TABLE l_brief_type(brief_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_10j_advice_deter(determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_10j_board_deter(determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_10j_brief_type(i_10j_brief_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_10j_discovery_type(discovery_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_10j_final(final_disposition_10j VARCHAR, description VARCHAR);
CREATE TABLE l_c_10j_judgement(judgement_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_10j_motion_determ(determination_motion BIGINT, description VARCHAR);
CREATE TABLE l_c_10j_motion_type(motion_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_10j_reason_cease(reason_cease VARCHAR, description VARCHAR);
CREATE TABLE l_c_10j_reg_determ_code(regional_determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_10l_co_determ(determination_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_10l_discovery_type(discovery_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_10l_final(final_disposition_10l VARCHAR, description VARCHAR);
CREATE TABLE l_c_10l_motion_determ(determination_motion BIGINT, description VARCHAR);
CREATE TABLE l_c_10l_reason_cease(reason_cease VARCHAR, description VARCHAR);
CREATE TABLE l_c_10l_reg_determ(regional_determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_abeyance_code(abeyance_reason VARCHAR, description VARCHAR);
CREATE TABLE l_c_accordance_with(accordance BIGINT, description VARCHAR);
CREATE TABLE l_c_action_fields(action_table_code VARCHAR, action_field_code VARCHAR, tbl_name VARCHAR, field_name VARCHAR, description VARCHAR, chronology_flag VARCHAR);
CREATE TABLE l_c_advice_determination(advice_determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_advice_type(advice_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_alj_cmp_deter(determination BIGINT, description VARCHAR);
CREATE TABLE l_c_alj_determination(determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_alj_mot_typ(motion_type BIGINT, description VARCHAR);
CREATE TABLE l_c_alleg_act_type(action_type VARCHAR, action_result VARCHAR, description VARCHAR);
CREATE TABLE l_c_amendment_reason(amendment_reason VARCHAR, description VARCHAR);
CREATE TABLE l_c_amendment_type(amendment_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_app_brief_pleading(brief_pleading VARCHAR, description VARCHAR);
CREATE TABLE l_c_app_court_act_type(court_action_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_app_court_action(court_action_action VARCHAR, description VARCHAR);
CREATE TABLE l_c_appeal_action(appeal_action VARCHAR, description VARCHAR);
CREATE TABLE l_c_appeal_deter(appeal_determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_appellate_court(determination BIGINT, description VARCHAR, certiorari_board_date_deter BIGINT);
CREATE TABLE l_c_appellate_enf_deter(enforcement_determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_bank_pet_type(bank_pet_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_bd_contempt(determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_bd_deter_certiorari(certiorari_board_deter VARCHAR, description VARCHAR);
CREATE TABLE l_c_board_determination(determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_board_motion_deter(board_motion_deter VARCHAR, description VARCHAR);
CREATE TABLE l_c_board_motion_type(board_motion_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_board_recon_deter(request_determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_case_group_type(case_group_type VARCHAR, prohibit_manual_maint BIGINT, description VARCHAR, case_group_sort_order VARCHAR);
CREATE TABLE l_c_case_note_topic(note_topic BIGINT, description VARCHAR, region BIGINT);
CREATE TABLE l_c_case_scope("scope" VARCHAR, description VARCHAR);
CREATE TABLE l_c_case_type(case_type VARCHAR, description VARCHAR, next_docket_number BIGINT);
CREATE TABLE l_c_close_determination(determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_close_method(close_method VARCHAR, description VARCHAR);
CREATE TABLE l_c_close_timing(close_timing VARCHAR, description VARCHAR);
CREATE TABLE l_c_cmp_letter_type(letter_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_cmp_spec_sw_action(sw_action VARCHAR, description VARCHAR);
CREATE TABLE l_c_cmp_spec_sw_participation(sw_participation VARCHAR, description VARCHAR);
CREATE TABLE l_c_comp_motion_deter(determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_comp_motion_forum(motion_forum VARCHAR, description VARCHAR);
CREATE TABLE l_c_comp_motion_type(motion_type BIGINT, description VARCHAR);
CREATE TABLE l_c_complaint_reason(reason_for_withdrawal BIGINT, description VARCHAR);
CREATE TABLE l_c_compliance_reason(compliance_reason VARCHAR, description VARCHAR);
CREATE TABLE l_c_contempt_deter(determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_contempt_settlement(settlement_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_deferral_type(deferral_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_discharge_bank_act(dis_bank_action VARCHAR, description VARCHAR);
CREATE TABLE l_c_discovery_ct_deter(court_determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_dismissal_revoke(revoked_reason VARCHAR, description VARCHAR);
CREATE TABLE l_c_enf_court_act_type(court_action_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_enf_court_action(court_action_action BIGINT, description VARCHAR);
CREATE TABLE l_c_enforcement_settlement(settlement_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_escrow_acc_loc(escrow_location VARCHAR, description VARCHAR);
CREATE TABLE l_c_formal_settle_type(formal_settlement_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_fs_submitted(fs_submitted_to VARCHAR, description VARCHAR);
CREATE TABLE l_c_gc_recommendation(gc_cert_recommendation VARCHAR, description VARCHAR);
CREATE TABLE l_c_goal_description(goal VARCHAR, description VARCHAR);
CREATE TABLE l_c_goals(goal VARCHAR, first_effective VARCHAR, category BIGINT, number_of_days BIGINT, last_effective VARCHAR, active BIGINT);
CREATE TABLE l_c_heac_det_p_p(determination_request_p_p VARCHAR, description VARCHAR);
CREATE TABLE l_c_hearing_type(hearing_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_inj_appellate_dec(decision VARCHAR, description VARCHAR);
CREATE TABLE l_c_inj_court_order_typ(court_order_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_inj_evidence_type(evidence_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_inj_rel_type(injuctive_relief_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_inj_relief_deter(injunctive_relief_dec VARCHAR, description VARCHAR);
CREATE TABLE l_c_inj_relief_recipient(injunctive_relief_rec VARCHAR, description VARCHAR);
CREATE TABLE l_c_method_of_disp(method_of_disposition VARCHAR, description VARCHAR);
CREATE TABLE l_c_motion_summ_judge(motion_basis VARCHAR, description VARCHAR);
CREATE TABLE l_c_overage_decision(overage_decision VARCHAR, description VARCHAR);
CREATE TABLE l_c_overage_reason(overage_reason VARCHAR, description VARCHAR);
CREATE TABLE l_c_p_p_deter_source(p_p_deter_source VARCHAR, description VARCHAR);
CREATE TABLE l_c_part_role_type(role_code VARCHAR, description VARCHAR);
CREATE TABLE l_c_posting_type(posting_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_proof_claim_cat(poc_category VARCHAR, description VARCHAR);
CREATE TABLE l_c_reason_transfer(reason_transfer VARCHAR, description VARCHAR);
CREATE TABLE l_c_reg_det_agenda_typ(agenda_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_reg_det_dec_level(decision_level VARCHAR, description VARCHAR);
CREATE TABLE l_c_reg_det_type(regional_determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_reopen_reason(reopen_reason VARCHAR, description VARCHAR);
CREATE TABLE l_c_settle_part(participation VARCHAR, description VARCHAR);
CREATE TABLE l_c_settlement_bd(determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_som_determination(som_determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_spielberg_determ(spielberg_determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_status(status VARCHAR, description VARCHAR);
CREATE TABLE l_c_supreme_ct_deter(determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_supreme_ct_pet_deter(pet_determination VARCHAR, description VARCHAR);
CREATE TABLE l_c_timing_of_disp(timing_of_disposition VARCHAR, description VARCHAR);
CREATE TABLE l_c_transfer_type(transfer_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_willingness_type(willingness_type VARCHAR, description VARCHAR);
CREATE TABLE l_c_with_disposition(disposition VARCHAR, description VARCHAR);
CREATE TABLE l_c_with_revocation(revoked_reason VARCHAR, description VARCHAR);
CREATE TABLE l_c_with_scope(withdrawal_scope VARCHAR, description VARCHAR);
CREATE TABLE l_case_party(party VARCHAR, description VARCHAR, party_type VARCHAR, PRIMARY KEY(party), FOREIGN KEY (party_type) REFERENCES l_party_type(party_type));
CREATE TABLE l_ccr_backpay_control(backpay_control_code VARCHAR, description VARCHAR);
CREATE TABLE l_ccr_bargain_status(other_bargain_status VARCHAR, description VARCHAR);
CREATE TABLE l_ccr_charge_party_pos(cp_position VARCHAR, description VARCHAR);
CREATE TABLE l_ccr_closing_stage(closing_stage VARCHAR, description VARCHAR);
CREATE TABLE l_ccr_closing_type(closing_type VARCHAR, description VARCHAR);
CREATE TABLE l_ccr_complaint(complaint VARCHAR, description VARCHAR);
CREATE TABLE l_ccr_contempt_rec_type(contempt_recommended_type VARCHAR, description VARCHAR);
CREATE TABLE l_compliance_type("type" VARCHAR, description VARCHAR);
CREATE TABLE l_county(county_code BIGINT, state VARCHAR, county_name VARCHAR, PRIMARY KEY(county_code, state), FOREIGN KEY (state) REFERENCES l_state(state));
CREATE TABLE l_court(court BIGINT, court_type VARCHAR, description VARCHAR);
CREATE TABLE l_court_type(court_type VARCHAR, description VARCHAR);
CREATE TABLE l_eot_determination(eot_determination VARCHAR, description VARCHAR);
CREATE TABLE l_geographic_division(geographic_division VARCHAR, description VARCHAR, PRIMARY KEY(geographic_division));
CREATE TABLE l_geographic_region(geographic_region VARCHAR, description VARCHAR, PRIMARY KEY(geographic_region));
CREATE TABLE l_hearing_record_form(record_form VARCHAR, description VARCHAR);
CREATE TABLE l_impact_analysis_cat(impact_category BIGINT, description BIGINT, number_of_days BIGINT);
CREATE TABLE l_injunction_brief_type(i_10l_brief_type BIGINT, description VARCHAR);
CREATE TABLE l_injunction_motion_type(motion_type BIGINT, description VARCHAR);
CREATE TABLE l_labor_org_code(labor_org_code BIGINT, labor_org_reference VARCHAR, labor_org_name VARCHAR, afl_cio VARCHAR, PRIMARY KEY(labor_org_code));
CREATE TABLE l_member_type(member_type VARCHAR, description VARCHAR);
CREATE TABLE l_method_filed_type(method_filed VARCHAR, description VARCHAR);
CREATE TABLE l_motion_deter(motion_determination VARCHAR, description VARCHAR);
CREATE TABLE l_naics_code(naics_code BIGINT, naics_us_industry_code BIGINT, naics_industry_code BIGINT, naics_industry_group BIGINT, naics_subsector BIGINT, naics_sector BIGINT, description VARCHAR, PRIMARY KEY(naics_code), FOREIGN KEY (naics_sector) REFERENCES l_naics_sector(naics_sector));
CREATE TABLE l_naics_industry(naics_industry_code BIGINT, naics_industry_group BIGINT, naics_subsector BIGINT, naics_sector BIGINT, description VARCHAR, PRIMARY KEY(naics_industry_code, naics_industry_group, naics_subsector, naics_sector));
CREATE TABLE l_naics_industry_group(naics_industry_group BIGINT, naics_subsector BIGINT, naics_sector BIGINT, description VARCHAR, PRIMARY KEY(naics_industry_group, naics_subsector, naics_sector));
CREATE TABLE l_naics_qualifier(naics_code BIGINT, naics_qualifier VARCHAR, description VARCHAR);
CREATE TABLE l_naics_sector(naics_sector BIGINT, description VARCHAR, PRIMARY KEY(naics_sector));
CREATE TABLE l_naics_subsector(naics_subsector BIGINT, naics_sector BIGINT, description VARCHAR, PRIMARY KEY(naics_subsector, naics_sector), FOREIGN KEY (naics_sector) REFERENCES l_naics_sector(naics_sector));
CREATE TABLE l_naics_us_industry(naics_us_industry_code BIGINT, naics_industry_code BIGINT, naics_industry_group BIGINT, naics_subsector BIGINT, naics_sector BIGINT, description VARCHAR, PRIMARY KEY(naics_us_industry_code, naics_industry_code, naics_industry_group, naics_subsector, naics_sector));
CREATE TABLE l_name_prefix(name_prefix VARCHAR, description VARCHAR);
CREATE TABLE l_name_suffix(name_suffix VARCHAR, description VARCHAR);
CREATE TABLE l_nlrb_branch(branch VARCHAR, description VARCHAR, PRIMARY KEY(branch));
CREATE TABLE l_nlrb_district(district VARCHAR, description VARCHAR, PRIMARY KEY(district));
CREATE TABLE l_nlrb_division(division VARCHAR, description VARCHAR, PRIMARY KEY(division));
CREATE TABLE l_nlrb_office(nlrb_office_id VARCHAR, region VARCHAR, branch VARCHAR, division VARCHAR, district VARCHAR, office_name VARCHAR, description VARCHAR, supervising_office VARCHAR, office_mgr_name VARCHAR, office_type VARCHAR, street_address_1 VARCHAR, street_address_2 VARCHAR, city VARCHAR, state VARCHAR, zip VARCHAR, main_phone_num VARCHAR, main_phone_ext BIGINT, main_fax_num VARCHAR, e_mail_address VARCHAR, system_time_out BIGINT, io_daily_hours DOUBLE, trigger_flag VARCHAR, standard_correspond_path VARCHAR, standard_reports_path VARCHAR, office_correspond_path VARCHAR, office_reports_path VARCHAR, office_forms_path VARCHAR, path_legal_research VARCHAR, path_forms BIGINT, path_summation VARCHAR, path_crystal BIGINT, message_of_the_day VARCHAR, date_in_service VARCHAR, cats_version BIGINT, PRIMARY KEY(nlrb_office_id), FOREIGN KEY (office_type) REFERENCES l_nlrb_office_type(office_type), FOREIGN KEY (district) REFERENCES l_nlrb_district(district), FOREIGN KEY (division) REFERENCES l_nlrb_division(division), FOREIGN KEY (branch) REFERENCES l_nlrb_branch(branch), FOREIGN KEY (region) REFERENCES l_nlrb_region(region), FOREIGN KEY (state) REFERENCES l_state(state));
CREATE TABLE l_nlrb_office_type(office_type VARCHAR, description VARCHAR, PRIMARY KEY(office_type));
CREATE TABLE l_nlrb_region(region VARCHAR, description VARCHAR, force_xfer_log VARCHAR, PRIMARY KEY(region));
CREATE TABLE l_note_type(note_type VARCHAR, description VARCHAR, object_tag BIGINT);
CREATE TABLE l_notifications(notification_id BIGINT, participant_group BIGINT, nlrb_office_id BIGINT, contact_id BIGINT, keyword VARCHAR, subject VARCHAR, coverage VARCHAR);
CREATE TABLE l_organization(organization_id BIGINT, formal_name VARCHAR, parent_name VARCHAR, PRIMARY KEY(organization_id));
CREATE TABLE l_organization_name(organization_id BIGINT, cnt BIGINT, variant_name VARCHAR);
CREATE TABLE l_parti_type(parti_type VARCHAR, description VARCHAR, PRIMARY KEY(parti_type));
CREATE TABLE l_participant_group(participant_group VARCHAR, identifier VARCHAR, description VARCHAR, PRIMARY KEY(participant_group));
CREATE TABLE l_party_scope(party_scope VARCHAR, description VARCHAR, PRIMARY KEY(party_scope));
CREATE TABLE l_party_type(party_type VARCHAR, description VARCHAR, PRIMARY KEY(party_type));
CREATE TABLE l_r_action_fields(action_table_code VARCHAR, action_field_code VARCHAR, tbl_name VARCHAR, field_name VARCHAR, description VARCHAR, chronology_flag VARCHAR, PRIMARY KEY(action_table_code, action_field_code));
CREATE TABLE l_r_amendment_reason(amendment_reason VARCHAR, description VARCHAR);
CREATE TABLE l_r_amendment_type(amendment_type VARCHAR, description VARCHAR);
CREATE TABLE l_r_bargain_unit_code(bargaining_unit_code VARCHAR, description VARCHAR, PRIMARY KEY(bargaining_unit_code));
CREATE TABLE l_r_bargain_unit_scope(bargaining_unit_scope VARCHAR, description VARCHAR, PRIMARY KEY(bargaining_unit_scope));
CREATE TABLE l_r_block_determination(block_determination VARCHAR, description VARCHAR, PRIMARY KEY(block_determination));
CREATE TABLE l_r_board_action_code(action_code BIGINT, action_source VARCHAR, description VARCHAR, PRIMARY KEY(action_code));
CREATE TABLE l_r_board_action_src_reason(action_source VARCHAR, received_reason VARCHAR, PRIMARY KEY(action_source, received_reason), FOREIGN KEY (received_reason) REFERENCES l_r_board_received_reason(received_reason));
CREATE TABLE l_r_board_received_reason(received_reason VARCHAR, description VARCHAR, PRIMARY KEY(received_reason));
CREATE TABLE l_r_case_elect_type(election_type VARCHAR, description VARCHAR, PRIMARY KEY(election_type));
CREATE TABLE l_r_case_group_type(case_group_type VARCHAR, prohibit_manual_maint BIGINT, description VARCHAR, case_group_sort_order VARCHAR, PRIMARY KEY(case_group_type));
CREATE TABLE l_r_case_note_topic(note_topic BIGINT, description VARCHAR, region BIGINT);
CREATE TABLE l_r_case_type(case_type VARCHAR, description VARCHAR, next_docket_number BIGINT, PRIMARY KEY(case_type));
CREATE TABLE l_r_challenge_act_result(challenge_action BIGINT, challenge_result BIGINT, description VARCHAR, PRIMARY KEY(challenge_result), FOREIGN KEY (challenge_action) REFERENCES l_r_challenge_act_type(challenge_action));
CREATE TABLE l_r_challenge_act_type(challenge_action BIGINT, description VARCHAR, sort_index BIGINT, pre_investigation VARCHAR, PRIMARY KEY(challenge_action));
CREATE TABLE l_r_challenge_issue(challenge_issue BIGINT, description VARCHAR, PRIMARY KEY(challenge_issue));
CREATE TABLE l_r_closing_method(closing_method VARCHAR, description VARCHAR, PRIMARY KEY(closing_method));
CREATE TABLE l_r_closing_stage(closing_stage VARCHAR, description VARCHAR, PRIMARY KEY(closing_stage));
CREATE TABLE l_r_elect_agree_type(election_agreement_type VARCHAR, description VARCHAR, PRIMARY KEY(election_agreement_type));
CREATE TABLE l_r_elect_mode(election_mode VARCHAR, description VARCHAR, PRIMARY KEY(election_mode));
CREATE TABLE l_r_obj_act_result(objection_action BIGINT, objection_result BIGINT, description VARCHAR, PRIMARY KEY(objection_result), FOREIGN KEY (objection_action) REFERENCES l_r_obj_act_type(objection_action));
CREATE TABLE l_r_obj_act_type(objection_action BIGINT, description VARCHAR, PRIMARY KEY(objection_action));
CREATE TABLE l_r_objection_issue(objection_issue VARCHAR, description VARCHAR, PRIMARY KEY(objection_issue));
CREATE TABLE l_r_part_role_type(participant_role VARCHAR, role_name VARCHAR, PRIMARY KEY(participant_role));
CREATE TABLE l_r_postelec_det_eot(post_elect_determ_eot VARCHAR, description VARCHAR, PRIMARY KEY(post_elect_determ_eot));
CREATE TABLE l_r_postelec_det_p_p(post_elect_determ_p_p VARCHAR, description VARCHAR, PRIMARY KEY(post_elect_determ_p_p));
CREATE TABLE l_r_postelec_ho_directed(ho_report_directed VARCHAR, description VARCHAR, PRIMARY KEY(ho_report_directed));
CREATE TABLE l_r_preelec_det_eot(determination_eot VARCHAR, description VARCHAR, PRIMARY KEY(determination_eot));
CREATE TABLE l_r_preelec_hear_det_p_p(determination_request_p_p VARCHAR, description VARCHAR, PRIMARY KEY(determination_request_p_p));
CREATE TABLE l_r_preelec_rd_dec_type(rd_decision_type VARCHAR, description VARCHAR, PRIMARY KEY(rd_decision_type));
CREATE TABLE l_r_preelec_rd_issue_dec(issue_code VARCHAR, description VARCHAR, PRIMARY KEY(issue_code));
CREATE TABLE l_r_preelec_rd_recon(rd_reconsider_deter VARCHAR, description VARCHAR, PRIMARY KEY(rd_reconsider_deter));
CREATE TABLE l_r_rd_action_det(rd_action_determination BIGINT, rd_action_type BIGINT, description VARCHAR, PRIMARY KEY(rd_action_determination), FOREIGN KEY (rd_action_type) REFERENCES l_r_rd_action_type(rd_action_type));
CREATE TABLE l_r_rd_action_type(rd_action_type BIGINT, description VARCHAR, PRIMARY KEY(rd_action_type));
CREATE TABLE l_r_reason_transfer(reason_transfer VARCHAR, description VARCHAR, PRIMARY KEY(reason_transfer));
CREATE TABLE l_r_reopen_reason(reopen_reason VARCHAR, description VARCHAR, PRIMARY KEY(reopen_reason));
CREATE TABLE l_r_status(status VARCHAR, description VARCHAR, PRIMARY KEY(status));
CREATE TABLE l_r_tally_type(tally_type VARCHAR, description VARCHAR, PRIMARY KEY(tally_type));
CREATE TABLE l_r_target_description("target" VARCHAR, description VARCHAR, FOREIGN KEY ("target") REFERENCES l_r_targets("target"));
CREATE TABLE l_r_targets("target" VARCHAR, first_effective VARCHAR, number_of_days BIGINT, last_effective BIGINT, active BIGINT, category BIGINT, PRIMARY KEY("target"));
CREATE TABLE l_r_transfer_type(transfer_type VARCHAR, description VARCHAR, PRIMARY KEY(transfer_type));
CREATE TABLE l_r_with_det(withdrawal_req_deter VARCHAR, description VARCHAR);
CREATE TABLE l_scope("scope" VARCHAR, description VARCHAR);
CREATE TABLE l_state(state VARCHAR, geographic_division VARCHAR, geographic_region VARCHAR, state_name VARCHAR, PRIMARY KEY(state), FOREIGN KEY (geographic_region) REFERENCES l_geographic_region(geographic_region), FOREIGN KEY (geographic_division) REFERENCES l_geographic_division(geographic_division));
CREATE TABLE l_supervisor_type(supervisor_type VARCHAR, description VARCHAR);
CREATE TABLE r_action(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, recurrence BIGINT, action_table_code VARCHAR, action_field_code VARCHAR, action_date TIMESTAMP, date_entered TIMESTAMP, action_control BIGINT);
CREATE TABLE r_bargaining_unit(r_case_number VARCHAR, unit_id VARCHAR, bargaining_unit_code VARCHAR, bargaining_unit_scope VARCHAR, num_employees_determined BIGINT, unit_city VARCHAR, unit_state VARCHAR, unit_county BIGINT, description_determined VARCHAR, PRIMARY KEY(r_case_number, unit_id));
CREATE TABLE r_block(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, recurrence BIGINT, blocked DATE, unblocked DATE, reqproc_board_filed_date VARCHAR, reqproc_board_party VARCHAR, reqproc_board_deter_date VARCHAR, reqproc_board_deter VARCHAR);
CREATE TABLE r_block_cases(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, "sequence" BIGINT, recurrence BIGINT, c_case_number VARCHAR, req_proceed_filed DATE, req_proceed_party VARCHAR, req_proceed_withdrawn DATE);
CREATE TABLE r_case(r_case_number VARCHAR, case_type VARCHAR, status VARCHAR, nlrb_office_id VARCHAR, docket_num BIGINT, inquiry_id VARCHAR, case_name VARCHAR, date_filed DATE, hearing_target_date DATE, election_target_date DATE, employer_on_petition VARCHAR, union_involved_on_petition VARCHAR, intervenor_on_petition VARCHAR, self_certification VARCHAR, post_elect_self_cert VARCHAR, naics_code BIGINT, num_employees_requested BIGINT, description_requested VARCHAR, PRIMARY KEY(r_case_number), FOREIGN KEY (status) REFERENCES l_r_status(status), FOREIGN KEY (case_type) REFERENCES l_r_case_type(case_type), FOREIGN KEY (nlrb_office_id) REFERENCES l_nlrb_office(nlrb_office_id), FOREIGN KEY (naics_code) REFERENCES l_naics_code(naics_code));
CREATE TABLE r_case_case_group(r_case_group_id VARCHAR, r_case_number VARCHAR, "sequence" BIGINT, date_case_added DATE, lead VARCHAR, date_case_removed DATE, FOREIGN KEY (r_case_group_id) REFERENCES r_case_group(r_case_group_id));
CREATE TABLE r_case_group(r_case_group_id VARCHAR, case_group_type VARCHAR, date_created DATE, date_dissolved DATE, PRIMARY KEY(r_case_group_id), FOREIGN KEY (case_group_type) REFERENCES l_r_case_group_type(case_group_type));
CREATE TABLE r_challenge_issue(election_id VARCHAR, "sequence" BIGINT, challenge_party VARCHAR, challenge_issue BIGINT, number BIGINT, challenge_action BIGINT, challenge_result BIGINT, FOREIGN KEY (challenge_result) REFERENCES l_r_challenge_act_result(challenge_result), FOREIGN KEY (challenge_action) REFERENCES l_r_challenge_act_type(challenge_action), FOREIGN KEY (challenge_issue) REFERENCES l_r_challenge_issue(challenge_issue), FOREIGN KEY (challenge_party) REFERENCES l_case_party(party), FOREIGN KEY (election_id) REFERENCES r_election(election_id));
CREATE TABLE r_challenge_tabulation(election_id VARCHAR, challenge_action BIGINT, "sequence" BIGINT, number_eligible BIGINT, number_ineligible BIGINT, number_withdrawn BIGINT, number_unresolved BIGINT, FOREIGN KEY (election_id) REFERENCES r_election(election_id));
CREATE TABLE r_closed_case(r_case_number VARCHAR, action_sequence BIGINT, closing_date DATE, closing_stage VARCHAR, closing_method VARCHAR, date_file_archives DATE, date_file_to_records DATE, date_file_destroyed DATE, FOREIGN KEY (closing_method) REFERENCES l_r_closing_method(closing_method), FOREIGN KEY (closing_stage) REFERENCES l_r_closing_stage(closing_stage), FOREIGN KEY (r_case_number) REFERENCES r_case(r_case_number));
CREATE TABLE r_dismissal(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, date_letter_issued DATE);
CREATE TABLE r_elect_agreement(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, date_approved DATE, election_agreement_type VARCHAR);
CREATE TABLE r_elect_certification(election_id VARCHAR, cert_of_representative DATE, cert_of_results DATE, certified_bargaining_agent VARCHAR, FOREIGN KEY (election_id) REFERENCES r_election(election_id));
CREATE TABLE r_elect_scheduled(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, election_mode VARCHAR, election_type VARCHAR, election_state VARCHAR, election_time VARCHAR, election_city VARCHAR, schedule_date DATE, self_deter_election VARCHAR, expedited_under_8b7 VARCHAR, scheduled_tally_date DATE, election_cancelled VARCHAR, date_excelsior_list_due DATE, date_excelsior_list_received DATE, date_excelsior_list_sent DATE, date_eligible DATE, election_place VARCHAR, additional_languages VARCHAR);
CREATE TABLE r_elect_votes_for(r_case_number VARCHAR, unit_id VARCHAR, election_id VARCHAR, tally_id BIGINT, sort_order BIGINT, labor_organization VARCHAR, votes_for BIGINT);
CREATE TABLE r_election(election_id VARCHAR, date_election DATE, election_type VARCHAR, election_mode VARCHAR, election_time VARCHAR, election_city VARCHAR, election_state VARCHAR, expedited_under_8b7 VARCHAR, globe_sonotone_election VARCHAR, ballots_impounded VARCHAR, PRIMARY KEY(election_id), FOREIGN KEY (election_mode) REFERENCES l_r_elect_mode(election_mode), FOREIGN KEY (election_type) REFERENCES l_r_case_elect_type(election_type), FOREIGN KEY (election_state) REFERENCES l_state(state));
CREATE TABLE r_election_tally(r_case_number VARCHAR, unit_id VARCHAR, election_id VARCHAR, tally_id BIGINT, tally_date DATE, tally_type VARCHAR, self_determination_tally VARCHAR, num_employees_eligible BIGINT, num_void_ballots BIGINT, num_votes_against BIGINT, num_valid_votes BIGINT, num_challenges BIGINT, challenges_determinative VARCHAR, runoff_required VARCHAR, majority_for VARCHAR, num_for_inclusion BIGINT, num_against_inclusion BIGINT, num_sustained_challenges BIGINT);
CREATE TABLE r_impact_category(r_case_number VARCHAR, history_sequence BIGINT, preelection BIGINT, postelection BIGINT, FOREIGN KEY (r_case_number) REFERENCES r_case(r_case_number));
CREATE TABLE r_objection_issue(election_id VARCHAR, "sequence" BIGINT, objection_issue_date DATE, objection_party VARCHAR, objection_issue VARCHAR, objection_action BIGINT, objection_result BIGINT, FOREIGN KEY (objection_result) REFERENCES l_r_obj_act_result(objection_result), FOREIGN KEY (objection_action) REFERENCES l_r_obj_act_type(objection_action), FOREIGN KEY (objection_issue) REFERENCES l_r_objection_issue(objection_issue), FOREIGN KEY (objection_party) REFERENCES l_case_party(party), FOREIGN KEY (election_id) REFERENCES r_election(election_id));
CREATE TABLE r_part_variant(r_case_number VARCHAR, participant_id BIGINT, variant_name VARCHAR, FOREIGN KEY (r_case_number) REFERENCES r_case(r_case_number));
CREATE TABLE r_participant(r_case_number VARCHAR, participant_id BIGINT, participant_role VARCHAR, participant_group VARCHAR, name_for_correspondence VARCHAR, name_prefix VARCHAR, first_name VARCHAR, mid_name VARCHAR, last_name VARCHAR, name_suffix VARCHAR, street_address_1 VARCHAR, street_address_2 VARCHAR, city VARCHAR, state VARCHAR, zip VARCHAR, phone_num VARCHAR, phone_ext VARCHAR, cell_phone VARCHAR, fax_num VARCHAR, e_mail_address VARCHAR, formal_name VARCHAR, parent_name VARCHAR, exclusive_service VARCHAR, incumbent_union VARCHAR, labor_org_code BIGINT, local_dist_id VARCHAR, afl_cio VARCHAR, party_scope VARCHAR, parti_type VARCHAR);
CREATE TABLE r_post_elect_board_act(r_case_number VARCHAR, received_date DATE, received_reason VARCHAR, ruling_action_code BIGINT, exception_withdrawn_date VARCHAR, board_decision_date DATE, board_action_code BIGINT, FOREIGN KEY (received_reason) REFERENCES l_r_board_received_reason(received_reason), FOREIGN KEY (ruling_action_code) REFERENCES l_r_board_action_code(action_code), FOREIGN KEY (board_action_code) REFERENCES l_r_board_action_code(action_code), FOREIGN KEY (r_case_number) REFERENCES r_case(r_case_number));
CREATE TABLE r_post_elect_hearing(r_case_number VARCHAR, unit_id VARCHAR, election_id VARCHAR, action_sequence BIGINT, recurrence BIGINT, noh_issued DATE, hearing_scheduled DATE, p_p_request_date DATE, p_p_party VARCHAR, p_p_determination VARCHAR, p_p_order_issued DATE, hearing_opened DATE, hearing_closed DATE, hearing_days BIGINT, date_reschedule_issued DATE, staff_id VARCHAR, length_of_transcript BIGINT, hearing_time VARCHAR, hearing_city VARCHAR, hearing_state VARCHAR, hearing_address VARCHAR);
CREATE TABLE r_post_elect_rd_act(r_case_number VARCHAR, unit_id VARCHAR, election_id VARCHAR, action_sequence BIGINT, recurrence BIGINT, brief_due DATE, brief_filed DATE, brief_party VARCHAR, eot_request_date DATE, eot_party VARCHAR, eot_determination_date DATE, eot_determination VARCHAR, action_date DATE, rd_action_type BIGINT, rd_action_determination BIGINT, review_due_date DATE, date_ho_report DATE, ho_report_directed VARCHAR, exceptions_due_date DATE);
CREATE TABLE r_pre_elect_board_act(r_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, received_date DATE, received_reason VARCHAR, ruling_decision_date DATE, ruling_action_code BIGINT, exception_withdrawn_date BIGINT, board_decision_date DATE, board_action_code BIGINT, FOREIGN KEY (received_reason) REFERENCES l_r_board_received_reason(received_reason), FOREIGN KEY (ruling_action_code) REFERENCES l_r_board_action_code(action_code), FOREIGN KEY (board_action_code) REFERENCES l_r_board_action_code(action_code), FOREIGN KEY (r_case_number) REFERENCES r_case(r_case_number));
CREATE TABLE r_pre_elect_hearing(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, recurrence BIGINT, date_notice_issued DATE, date_hearing_scheduled DATE, date_rescheduled_issued DATE, length_of_transcript BIGINT, p_p_party VARCHAR, p_p_determination VARCHAR, p_p_rcvd_region DATE, p_p_response_date DATE, hearing_opened DATE, hearing_closed DATE, hearing_days_on_record BIGINT, hearing_off_rep_date DATE, hearing_time VARCHAR, hearing_city VARCHAR, hearing_state VARCHAR, hearing_address VARCHAR);
CREATE TABLE r_pre_elect_rd_bb(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, blue_book_code VARCHAR, recurrence BIGINT);
CREATE TABLE r_pre_elect_rd_decision(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, recurrence BIGINT, determination_eot VARCHAR, eot_party VARCHAR, eot_filed_date DATE, eot_deter_brief_date DATE, brief_rcvd_party VARCHAR, pre_election_brief_rcvd DATE, rd_decision_issued_date DATE, rd_decision_type VARCHAR, recon_request_filed DATE, recon_request_party VARCHAR, rd_recon_deter VARCHAR, rd_recon_deter_date DATE, brief_due_date DATE, review_due_date DATE);
CREATE TABLE r_pre_elect_rd_issues(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, recurrence BIGINT, issue_code VARCHAR);
CREATE TABLE r_reopened_case(r_case_number VARCHAR, action_sequence BIGINT, date_reopened DATE, reopen_reason VARCHAR, FOREIGN KEY (reopen_reason) REFERENCES l_r_reopen_reason(reopen_reason), FOREIGN KEY (r_case_number) REFERENCES r_case(r_case_number));
CREATE TABLE r_transfer_history(r_case_number VARCHAR, history_date TIMESTAMP, "sequence" BIGINT, date_data_received TIMESTAMP, request_date DATE, reason_transfer VARCHAR, transfer_type VARCHAR, transfer_order_date DATE, new_case_number VARCHAR, former_case_number VARCHAR, sent_date DATE, received_date VARCHAR);
CREATE TABLE r_withdrawal(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, withdrawal_approved_date DATE, with_prejudice_flag VARCHAR);