18F/openFEC

SET search_path = staging, pg_catalog;

--
-- Name: operations_log; Type: TABLE; Schema: staging; Owner: fec
--

CREATE TABLE operations_log (
    sub_id numeric(19,0) NOT NULL,
    status_num numeric(3,0),
    cand_cmte_id character varying(9),
    filer_tp character varying(1),
    beg_image_num character varying(18),
    end_image_num character varying(18),
    form_tp character varying(8),
    rpt_yr numeric(4,0),
    amndt_ind character varying(1),
    rpt_tp character varying(3),
    scan_dt timestamp without time zone,
    pass_1_entry_dt timestamp without time zone,
    pass_1_entry_id numeric(3,0),
    pass_1_coding_id numeric(3,0),
    pass_1_verified_dt timestamp without time zone,
    pass_1_verified_id numeric(3,0),
    pass_3_coding_dt date,
    pass_3_coding_id numeric(3,0),
    pass_3_num_additions numeric(7,0),
    pass_3_num_changes numeric(7,0),
    pass_3_num_deletes numeric(7,0),
    pass_3_entry_began_dt date,
    pass_3_entry_done_dt date,
    pass_3_entry_id numeric(3,0),
    error_processing_dt timestamp without time zone,
    rad_sent_dt timestamp without time zone,
    error_listing_review_dt timestamp without time zone,
    error_listing_analyst_id character varying(3),
    error_listing_time numeric(7,0),
    basic_review_dt timestamp without time zone,
    basic_review_analyst_id character varying(3),
    basic_review_time numeric(7,0),
    batch_error_listing_dt timestamp without time zone,
    receipt_dt timestamp without time zone,
    beginning_coverage_dt timestamp without time zone,
    ending_coverage_dt timestamp without time zone,
    create_dt timestamp without time zone,
    last_change_dt timestamp without time zone,
    batch_num numeric(5,0),
    num_tran numeric(7,0),
    batch_close_dt timestamp without time zone,
    return_dt timestamp without time zone,
    file_num numeric(7,0),
    prev_file_num numeric(7,0),
    pg_date timestamp without time zone DEFAULT now()
);


ALTER TABLE operations_log OWNER TO fec;

--
-- Name: ref_cand_ici; Type: TABLE; Schema: staging; Owner: fec
--

CREATE TABLE ref_cand_ici (
    cand_ici_cd character varying(1),
    cand_ici_desc character varying(15),
    pg_date timestamp without time zone DEFAULT now()
);


ALTER TABLE ref_cand_ici OWNER TO fec;

--
-- Name: ref_cand_office; Type: TABLE; Schema: staging; Owner: fec
--

CREATE TABLE ref_cand_office (
    cand_office_cd character varying(1),
    cand_office_desc character varying(20),
    pg_date timestamp without time zone DEFAULT now()
);


ALTER TABLE ref_cand_office OWNER TO fec;

--
-- Name: ref_contribution_limits; Type: TABLE; Schema: staging; Owner: fec
--

CREATE TABLE ref_contribution_limits (
    contrib_limit_id numeric(7,0) NOT NULL,
    donor character varying(40),
    donor_id numeric(2,0),
    cycle numeric(4,0),
    cand_cmte_per_election numeric(8,2),
    ssf_nonconnect_per_yr numeric(8,2),
    nat_pty_per_yr character varying(20),
    st_district_local_pty_per_yr character varying(20),
    overall_bi_limit_cand_pac_pty numeric(8,2),
    overall_bi_limit_cand numeric(8,2),
    overall_bi_limit_pac_pty numeric(8,2),
    sublimit_pacs_st_local_pty numeric(8,2),
    pty_senate_cand_per_election numeric(8,2),
    overall_an_limit_cand_pac_pty numeric(8,2),
    additional_nat_pty_accounts numeric(8,2),
    pg_date timestamp without time zone DEFAULT now()
);


ALTER TABLE ref_contribution_limits OWNER TO fec;

--
-- Name: ref_filed_cmte_dsgn; Type: TABLE; Schema: staging; Owner: fec
--

CREATE TABLE ref_filed_cmte_dsgn (
    filed_cmte_dsgn_cd character varying(1),
    filed_cmte_dsgn_desc character varying(90),
    pg_date timestamp without time zone DEFAULT now()
);


ALTER TABLE ref_filed_cmte_dsgn OWNER TO fec;

--
-- Name: ref_filed_cmte_tp; Type: TABLE; Schema: staging; Owner: fec
--

CREATE TABLE ref_filed_cmte_tp (
    filed_cmte_tp_cd character varying(1),
    filed_cmte_tp_desc character varying(58),
    pg_date timestamp without time zone DEFAULT now()
);


ALTER TABLE ref_filed_cmte_tp OWNER TO fec;

--
-- Name: ref_st; Type: TABLE; Schema: staging; Owner: fec
--

CREATE TABLE ref_st (
    st_desc character varying(40),
    st character varying(2),
    pg_date timestamp without time zone DEFAULT now()
);


ALTER TABLE ref_st OWNER TO fec;