Schema for lm10

CREATE TABLE _datasette_foreign_keys(table_name VARCHAR, from_column VARCHAR, other_table VARCHAR, other_column VARCHAR);
CREATE TABLE activity(id BIGINT, "12b_exists" BIGINT, activity_code VARCHAR, activity_type VARCHAR, agencies VARCHAR, counterparty_position VARCHAR, date_of_agreement DATE, explanation VARCHAR, federal_work VARCHAR, form_agreement VARCHAR, no_uei_checkbox VARCHAR, uei VARCHAR, unlisted_agencies VARCHAR, rptId BIGINT, PRIMARY KEY(id), FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE counterparty_contact(city VARCHAR, "name" VARCHAR, "po_box,_bldg,_room_no,_if_any" VARCHAR, state VARCHAR, street VARCHAR, "zip_code_+_4" VARCHAR, activity_id BIGINT, FOREIGN KEY (activity_id) REFERENCES activity(id));
CREATE TABLE counterparty_organization(city VARCHAR, organization VARCHAR, "po_box,_bldg,_room_no,_if_any" VARCHAR, state VARCHAR, street VARCHAR, "zip_code_+_4" VARCHAR, activity_id BIGINT, FOREIGN KEY (activity_id) REFERENCES activity(id));
CREATE TABLE expenditure(amount VARCHAR, date DATE, kind VARCHAR, activity_id BIGINT, FOREIGN KEY (activity_id) REFERENCES activity(id));
CREATE TABLE filer(filerType VARCHAR, srFilerId VARCHAR, srNum BIGINT, companyName VARCHAR, companyCity VARCHAR, companyState VARCHAR, PRIMARY KEY(srNum));
CREATE TABLE filing(address1 VARCHAR, address2 VARCHAR, amended VARCHAR, amendment BIGINT, beginDate DATE, city VARCHAR, empLabOrg VARCHAR, empTrdName VARCHAR, endDate DATE, file_checksum UUID, file_path VARCHAR, file_status VARCHAR, filing_url VARCHAR, formFiled VARCHAR, formLink VARCHAR, oID BIGINT, paperOrElect VARCHAR, promiseDate BIGINT, receiveDate DATE, registerDate DATE, repOrgsCnt BIGINT, rptId BIGINT, srFilerId BIGINT, srNum BIGINT, state VARCHAR, subLabOrg1 VARCHAR, subLabOrg2 VARCHAR, yrCovered BIGINT, zip BIGINT, PRIMARY KEY(rptId), FOREIGN KEY (srNum) REFERENCES filer(srNum));
CREATE TABLE lm10(rptId BIGINT, file_number BIGINT, formFiled VARCHAR, period_begin DATE, period_through DATE, type_of_organization VARCHAR, records_hosted_at_other_address VARCHAR, records_hosted_with_principal_officer VARCHAR, records_hosted_with_reporting_employer VARCHAR, FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE organization(promiseDate DATE, oID BIGINT, rptId BIGINT, empLabOrg VARCHAR, city VARCHAR, state VARCHAR, FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE other_address(rptId BIGINT, city VARCHAR, "name" VARCHAR, organization VARCHAR, "po_box,_bldg,_room_no,_if_any" VARCHAR, state VARCHAR, street VARCHAR, title VARCHAR, "zip_code_+_4" VARCHAR, FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE principal_officer(rptId BIGINT, city VARCHAR, "name" VARCHAR, "po_box,_bldg,_room_no,_if_any" VARCHAR, state VARCHAR, street VARCHAR, "zip_code_+_4" VARCHAR, FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE reportable_activity(rptId BIGINT, answer VARCHAR, code VARCHAR, n_responses BIGINT, question VARCHAR, FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE reporting_employer(rptId BIGINT, attention_to VARCHAR, city VARCHAR, employer VARCHAR, "po_box,_bldg,_room_no,_if_any" VARCHAR, state VARCHAR, street VARCHAR, title VARCHAR, trade_name VARCHAR, "zip_code_+_4" VARCHAR, FOREIGN KEY (rptId) REFERENCES filing(rptId));
CREATE TABLE signature(rptId BIGINT, on_date DATE, signed VARCHAR, telephone_number VARCHAR, title VARCHAR, FOREIGN KEY (rptId) REFERENCES filing(rptId));