rc_elect
where case_number = "01-RC-018020"
0 records
CREATE TABLE "rc_elect" ( [case_number] TEXT REFERENCES [r_master]([case_number]), [suffix] TEXT, [election_date] TEXT, [unit] TEXT REFERENCES [l_unit_codes]([code]), [description_election] TEXT, [expedited] INTEGER, [date_election_held] TEXT, [type_election] TEXT REFERENCES [l_type_elections]([code]), [no_elig] INTEGER, [join_union_won] INTEGER, [union_won_votes] INTEGER, [union_won_intl_type] TEXT, [union_won_intl] INTEGER, [joint_union_lost_1] INTEGER, [union_lost_votes_1] INTEGER, [union_lost_intl_1_type] TEXT, [union_lost_intl_1] INTEGER, [joint_union_lost_2] INTEGER, [union_lost_votes_2] INTEGER, [union_lost_intl_2_type] TEXT, [union_lost_intl_2] INTEGER, [joint_union_lost_3] INTEGER, [union_lost_votes_3] INTEGER, [union_lost_intl_3_type] TEXT, [union_lost_intl_3] INTEGER, [joint_union_lost_4] INTEGER, [union_lost_votes_4] INTEGER, [union_lost_intl_4_type] TEXT, [union_lost_intl_4] INTEGER, [votes_against_union] INTEGER, [challenges] INTEGER, [void_votes] INTEGER, [elect_vote_control] INTEGER, [control] INTEGER, [conclusive] INTEGER, [challenges_determinative] INTEGER, [patric_union] TEXT, [incumb_union] TEXT, [mail_ballot] INTEGER, [union_control] TEXT, [cross_petition] TEXT, [runoff_necessary] INTEGER, [cross_pet_case_number] TEXT, [rerun_runoff_number] TEXT, [impounded] INTEGER, [date_elect_certified] TEXT, [stage] TEXT, [method] TEXT, FOREIGN KEY([union_won_intl_type]) REFERENCES [l_elect_union_type]([code]), FOREIGN KEY([union_won_intl]) REFERENCES [l_union_codes_and_names]([code]), FOREIGN KEY([union_lost_intl_1_type]) REFERENCES [l_elect_union_type]([code]), FOREIGN KEY([union_lost_intl_1]) REFERENCES [l_union_codes_and_names]([code]), FOREIGN KEY([union_lost_intl_2_type]) REFERENCES [l_elect_union_type]([code]), FOREIGN KEY([union_lost_intl_2]) REFERENCES [l_union_codes_and_names]([code]), FOREIGN KEY([union_lost_intl_3_type]) REFERENCES [l_elect_union_type]([code]), FOREIGN KEY([union_lost_intl_3]) REFERENCES [l_union_codes_and_names]([code]), FOREIGN KEY([union_lost_intl_4_type]) REFERENCES [l_elect_union_type]([code]), FOREIGN KEY([union_lost_intl_4]) REFERENCES [l_union_codes_and_names]([code]), FOREIGN KEY([conclusive]) REFERENCES [l_elect_conclusive]([code]), FOREIGN KEY([incumb_union]) REFERENCES [l_elect_incumbent_union]([code]), FOREIGN KEY([method]) REFERENCES [l_elect_method_of_disposition]([code]), FOREIGN KEY([stage]) REFERENCES [l_elect_stage_of_closing]([code]), FOREIGN KEY([patric_union]) REFERENCES [l_elect_participating_union]([code]) );