create table owner(
record_type	char(1)		null,
frn_filer	char(10)	null,
file_num	char(14)	null,
filer_fname	varchar(20)	null,
filer_mi	char(1)		null,
filer_lname	varchar(20)	null,
filer_suffix	char(3)		null,
filer_name	varchar(200)	null,
date_entered	char(10)	null,
date_receipt	char(10)	null,
certifier_fname	varchar(20)	null,
certifier_mi	char(1)		null,
certifier_lname	varchar(20)	null,
certifier_suffix char(3)	null,
certifier_title	char(40)	null,
contact_company	varchar(70)	null,
contact_fname	varchar(20)	null,
contact_mi	char(1)		null,
contact_lname	varchar(20)	null,
contact_suffix	char(3)		null,
contact_phone	char(10)	null,
contact_fax	char(10)	null,
contact_address	varchar(60)	null,
contact_city	varchar(20)	null,
contact_state	char(2)		null,
contact_zip_code char(9)	null,
contact_po_box	varchar(20)	null,
contact_email	varchar(50)	null,
form_num	char(3)		null,
filing_type	char(1)		null,
filing_status	char(1)		null,
unique_system_identifier	numeric(9,0)	null);


create table frb(
record_type	char(1)		null,
file_num	char(14)	null,
business_name	varchar(200)	null,
principal_business varchar(60)	null,
frn	numeric(10)		null,
pct_interest	numeric(5,2)	null,
form_num	char(3)		null,
filing_type	char(1)		null,
filing_status	char(1)		null,
unique_system_identifier	numeric(9,0)	null);

create table frbofdih(
record_type	char(1)		null,
file_num	char(14)	null,
business_name	varchar(200)	null,
principle_business varchar(60)	null,
frn	numeric(10)		null,
dih_frn	numeric(10)		null,
pct_interest	numeric(5,2)	null,
form_num	char(3)		null,
filing_type	char(1)		null,
filing_status	char(1)		null,
unique_system_identifier	numeric(9,0)	null);

create table dih(
record_type	char(1)	null,
file_num	char(14)	null,
entity_name	varchar(200)	null,
type_entity	char(1)		null,
fname	varchar(20)		null,
mi	char(1)			null,
lname	varchar(20)		null,
suffix	char(3)			null,
frn	numeric(10)		null,
address	varchar(60)		null,
address2	varchar(60)	null,
city	varchar(20)		null,
state	char(2)			null,
zip_code	char(9)		null,
country	char(2)			null,
international_address_ind char(1)	null,
interest_direct	char(1)		null,
interest_indirect	char(1)	null,
interest_officer	char(1)	null,
interest_director	char(1)	null,
interest_key_mgmt	char(1)	null,
interest_mgmt_contract	char(1)	null,
interest_other	char(1)		null,
interest_other_desc	char(255)	null,
own_comm_stk	char(1)		null,
own_comm_stk_vote_ind	char(1)	null,
own_gen_part	char(1)		null,
own_gen_part_vote_ind	char(1)	null,
own_ltd_part	char(1)		null,
own_ltd_part_vote_ind	char(1)	null,
own_member	char(1)		null,
own_option	char(1)		null,
own_proprietor	char(1)		null,
own_pref_stk	char(1)		null,
own_pref_stk_vote_ind	char(1)	null,
own_pref_stk_convert_ind	char(1)	null,
own_warrant	char(1)		null,
own_other	char(1)		null,
own_other_desc	char(255)	null,
pct_interest	numeric(5,2)	null,
country_citizenship	char(2)	null,
jurisdiction	char(2)		null,
state_jurisdiction	char(2)	null,
non_affiliate_option	char(1)	null,
year1_in_existence	char(1)	null,
year1_end_date	char(10)	null,
year1_revenue	numeric(18)	null,
year2_in_existence	char(1)	null,
year2_end_date	char(10)	null,
year2_revenue	numeric(18)	null,
year3_in_existence	char(1)	null,
year3_end_date	char(10)	null,
year3_revenue	numeric(18)	null,
total_assets	money		null,
financial_statement_type 	char(1)	null,
form_num	char(3)		null,
filing_type	char(1)		null,
filing_status	char(1)		null,
unique_system_identifier	numeric(9,0)	null);

create table affliate(
record_type	char(1)		null,
file_num	char(14)	null,
type_entity	char(1)		null,
fname	varchar(20)		null,
mi	char(1)			null,
lname	varchar(20)		null,
suffix	char(3)			null,
entity_name	varchar(200)	null,
principal_business	varchar(60)	null,
frn	numeric(10)		null,
year1_in_existence	char(1)	null,
year1_end_date	char(10)	null,
year1_revenue	numeric(18)	null,
year2_in_existence	char(1)	null,
year2_end_date	char(10)	null,
year2_revenue	numeric(18)	null,
year3_in_existence	char(1)	null,
year3_end_date	char(10)	null,
year3_revenue	numeric(18)	null,
total_assets	money		null,
financial_statement_type 	char(1)	null,
form_num	char(3)		null,
filing_type	char(1)		null,
filing_status	char(1)		null,
unique_system_identifier	numeric(9,0)	null);

create table attachment(
record_type	char(2)		null,
file_num	char(14)	null,
attachment_code	char(1)		null,
attachment_desc	varchar(60)	null,
attachment_date	char(10)	null,
attachment_filename	varchar(60)	null,
form_num	char(3)		null,
filing_type	char(1)		null,
filing_status	char(1)		null,
unique_system_identifier	numeric(9,0)	null);