Table: chain

Previous: cell_phone_detail

Unanet Data Model

Next: change_reason

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	chain_key	decimal(15)
2.		chain_name	varchar(50)
3.		description	varchar(2000)
4.		approval_group_type	tinyint

Referenced from

Table	Column	Foreign Key Name
approval_chain	chain_key	fk_approval_chain1
approval_group_submitter	chain_key	fk_approval_group_submitter1
purchase_order	chain_key	fk_purchase_order10
purchase_requisition	chain_key	fk_purchase_request3
vendor_invoice	chain_key	fk_vendor_invoice10

Check Constraints

Name	Definition
cc_approval_group_type	([approval_group_type]=(3) OR [approval_group_type]=(2) OR [approval_group_type]=(1))

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_chain	true	chain_key	Asc
idx_chain1	true	chain_name	Asc
		approval_group_type