Table: bank_account

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	bank_account_key	decimal(15)
2.		name	varchar(25)
3.		type	char(1)
4.		bank_name	varchar(50)
5.		bank_account_number	varchar(30)
6.		bank_routing_number	varchar(9)
7.		account_key	decimal(15)		account	fk_bank_account1
8.		customer_key	decimal(15)		customer	fk_bank_account2
9.		checking_account	char(1)
10.		last_check_number_used	int
11.		attachment_key	decimal(15)		attachment	fk_bank_account3
12.		active	char(1)

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
account_key	account	account_key	fk_bank_account1
attachment_key	attachment	attachment_key	fk_bank_account3
customer_key	customer	customer_key	fk_bank_account2

Referenced from
Table	Column	Foreign Key Name
bank_reconciliation	bank_account_key	fk_bank_rec2
check_print_history	bank_account_key	fk_check_print_history2
customer_payment	bank_account_key	fk_customer_payment4
deposit	bank_account_key	fk_deposit2
vendor_payment	bank_account_key	fk_vendor_payment3

Check Constraints
Name	Definition
cc_ba_checking_account	([checking_account]='N' OR [checking_account]='Y')
cc_bank_account_active	([active]='N' OR [active]='Y')
cc_bank_account_type	([type]='O' OR [type]='U' OR [type]='B')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_bank_account	true	bank_account_key	Asc
idx_bank_account1	true	name	Asc
idx_bank_account2	false	account_key	Asc
idx_bank_account3	false	customer_key	Asc