Schema for lm30

CREATE TABLE _datasette_foreign_keys(table_name VARCHAR, from_column VARCHAR, other_table VARCHAR, other_column VARCHAR);
CREATE TABLE amendment(rptId BIGINT, srFilerId BIGINT, yrCovered BIGINT, amendment BIGINT, amended VARCHAR, beginDate DATE, endDate DATE, receiveDate DATE, formFiled VARCHAR, unionName VARCHAR, unionCity VARCHAR, unionState VARCHAR, filing_url VARCHAR, PRIMARY KEY(rptId), FOREIGN KEY (srFilerId) REFERENCES filer(srFilerId));
CREATE TABLE business_interest(rptId BIGINT, entry_order BIGINT, business_name VARCHAR, contact_name VARCHAR, telephone VARCHAR, street VARCHAR, city VARCHAR, state VARCHAR, zip VARCHAR, deals_with VARCHAR, deals_with_name VARCHAR, deals_with_contact_name VARCHAR, deals_with_telephone VARCHAR, deals_with_street VARCHAR, deals_with_city VARCHAR, deals_with_state VARCHAR, deals_with_zip VARCHAR, nature_of_dealings VARCHAR, value_of_dealings VARCHAR, nature_of_interest VARCHAR, amount_of_interest VARCHAR, PRIMARY KEY(rptId, entry_order), FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE filer(srFilerId BIGINT, srNum BIGINT, "name" VARCHAR, suffix VARCHAR, city VARCHAR, state VARCHAR, affAbbr VARCHAR, unionName VARCHAR, unionCity VARCHAR, unionState VARCHAR, detailId BIGINT, PRIMARY KEY(srFilerId));
CREATE TABLE filing(rptId BIGINT, srFilerId BIGINT, amended VARCHAR, amendment BIGINT, beginDate DATE, endDate DATE, receiveDate DATE, registerDate DATE, formFiled VARCHAR, yrCovered BIGINT, unionName VARCHAR, unionCity VARCHAR, unionState VARCHAR, filing_url VARCHAR, file_path VARCHAR, file_checksum VARCHAR, file_status VARCHAR, PRIMARY KEY(rptId), FOREIGN KEY (srFilerId) REFERENCES filer(srFilerId));
CREATE TABLE other_employer_payment(rptId BIGINT, entry_order BIGINT, other_employer VARCHAR, contact_name VARCHAR, telephone VARCHAR, street VARCHAR, city VARCHAR, state VARCHAR, zip VARCHAR, entity_type VARCHAR, nature_of_payment VARCHAR, amount VARCHAR, PRIMARY KEY(rptId, entry_order), FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE report_identity(rptId BIGINT, filer_name VARCHAR, filer_street VARCHAR, filer_city VARCHAR, filer_state VARCHAR, filer_zip VARCHAR, filer_email VARCHAR, filer_role VARCHAR, filer_position_title VARCHAR, union_name VARCHAR, union_street VARCHAR, union_city VARCHAR, union_state VARCHAR, union_zip VARCHAR, union_file_number VARCHAR, PRIMARY KEY(rptId), FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE represented_employer_interest(rptId BIGINT, entry_order BIGINT, represented_employer VARCHAR, contact_name VARCHAR, telephone VARCHAR, street VARCHAR, city VARCHAR, state VARCHAR, zip VARCHAR, nature_of_interest VARCHAR, amount VARCHAR, PRIMARY KEY(rptId, entry_order), FOREIGN KEY (rptId) REFERENCES filing(rptId));