rc_elect

where case_number = "01-RC-018020"

✎ View and edit SQL

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])
);