Schema for lm20

CREATE TABLE attachment(rptId BIGINT, attachment_id BIGINT, filename VARCHAR, file_description VARCHAR, file_urls VARCHAR, PRIMARY KEY(attachment_id), FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE contact(city VARCHAR, ein VARCHAR, "name" VARCHAR, organization VARCHAR, "po_box,_bldg,_room_no,_if_any" VARCHAR, state VARCHAR, street VARCHAR, title VARCHAR, zip_code VARCHAR, rptId BIGINT, contact_type VARCHAR, FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE employer(rptId BIGINT, empLabOrg VARCHAR, empTrdName VARCHAR, city VARCHAR, state VARCHAR, termDate VARCHAR, amount BIGINT, FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE filer(srNum BIGINT, companyName VARCHAR, companyCity VARCHAR, companyState VARCHAR, srFilerId VARCHAR, PRIMARY KEY(srNum));
CREATE TABLE filing(address1 VARCHAR, address2 VARCHAR, amended VARCHAR, amendment BIGINT, beginDate DATE, city VARCHAR, empLabOrg VARCHAR, endDate DATE, file_checksum UUID, file_path VARCHAR, file_status VARCHAR, filing_url VARCHAR, formFiled VARCHAR, originalRptId BIGINT, paperOrElect VARCHAR, receiveDate DATE, registerDate DATE, repOrgsCnt BIGINT, rptId BIGINT, srFilerId BIGINT, srNum BIGINT, state VARCHAR, yrCovered BIGINT, zip VARCHAR, PRIMARY KEY(rptId), FOREIGN KEY (srNum) REFERENCES filer(srNum));
CREATE TABLE individual_disbursements(expense VARCHAR, "name" VARCHAR, salary VARCHAR, total VARCHAR, rptId BIGINT, disbursement_order BIGINT, FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE lm20(rptId BIGINT, amended BIGINT, date_fiscal_year_ends VARCHAR, direct VARCHAR, indirect VARCHAR, city VARCHAR, date_entered_into DATE, ein VARCHAR, "name" VARCHAR, organization VARCHAR, "po_box,_bldg,_room_no,_if_any" VARCHAR, state VARCHAR, street VARCHAR, zip_code VARCHAR, notes VARCHAR, written_agreement VARCHAR, type_of_person VARCHAR, FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE lm21(rptId BIGINT, fees_for_professional_services VARCHAR, loans_made VARCHAR, officer_and_administrative_expenses VARCHAR, other_disbursements VARCHAR, publicity VARCHAR, "total_disbursements_(sum_of_items_8-13)" VARCHAR, total_disbursements_to_officers_and_employees VARCHAR, period_begin DATE, period_through DATE, " Employer Name" VARCHAR, " Trade Name, If any" BIGINT, Amount VARCHAR, Purpose VARCHAR, City VARCHAR, "Name" VARCHAR, Organization VARCHAR, "P.O. B, B, Room N, if any" VARCHAR, Street VARCHAR, Title VARCHAR, "ZIP code" VARCHAR, total_disbursements VARCHAR, FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE performer(rptId BIGINT, specific_activity_id BIGINT, performer_order BIGINT, city VARCHAR, ein VARCHAR, file_number BIGINT, "name" VARCHAR, organization VARCHAR, "po_box,_bldg,_room_no,_if_any" BIGINT, state VARCHAR, street VARCHAR, title BIGINT, zip VARCHAR, FOREIGN KEY (specific_activity_id) REFERENCES specific_activity(id), FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE receipts(rptId BIGINT, receipt_number BIGINT, amount VARCHAR, city VARCHAR, employer VARCHAR, mailing_address BIGINT, "name" VARCHAR, "non-cash_payment" VARCHAR, "po_box,_bldg,_room_no,_if_any" VARCHAR, state VARCHAR, street VARCHAR, termination_date VARCHAR, title VARCHAR, trade_name VARCHAR, type_of_payment VARCHAR, zip_code BIGINT, FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE signatures(rptId BIGINT, signature_number BIGINT, date VARCHAR, signed VARCHAR, telephone BIGINT, telephone_number VARCHAR, title VARCHAR, FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE specific_activity(id BIGINT, rptId BIGINT, activity_order BIGINT, specific_extent_of_performance VARCHAR, specific_nature_of_activity VARCHAR, specific_period_of_performance VARCHAR, specific_subject_employees VARCHAR, specific_subject_labor_orgs VARCHAR, PRIMARY KEY(id), FOREIGN KEY (rptId) REFERENCES filing(rptId));