Table: customer_org

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	customer_org_key	decimal(15)
2.		customer_key	decimal(15)		customer	fk_customer_org1
3.		legal_entity_key	decimal(15)		customer	fk_customer_org2
4.		payment_term_key	decimal(15)		payment_term	fk_customer_org3
5.		active	char(1)	('Y')
6.		user01	varchar(128)
7.		user02	varchar(128)
8.		user03	varchar(128)
9.		user04	varchar(128)
10.		user05	varchar(128)
11.		user06	varchar(128)
12.		user07	varchar(128)
13.		user08	varchar(128)
14.		user09	varchar(128)
15.		user10	varchar(128)

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
customer_key	customer	customer_key	fk_customer_org1
legal_entity_key	customer	customer_key	fk_customer_org2
payment_term_key	payment_term	payment_term_key	fk_customer_org3

Check Constraints
Name	Definition
cc_customer_org_active	([active]='N' OR [active]='Y')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_customer_org	true	customer_org_key	Asc
idx_customer_org1	false	customer_key	Asc
idx_customer_org2	false	legal_entity_key	Asc
idx_customer_org3	false	payment_term_key	Asc