Table: org_cost_pool_tree

Previous: org_access_person

Unanet Data Model

Next: org_fin_tree

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	node_key	decimal(15)		customer	fk_org_cost_pool_tree1
2.		parent_key	decimal(15)		org_cost_pool_tree	fk_org_cost_pool_tree2, fk_org_cost_pool_tree3
3.		tree_level	int
4.		left_visit	int
5.		right_visit	int

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
node_key	customer	customer_key	fk_org_cost_pool_tree1
parent_key	customer	customer_key	fk_org_cost_pool_tree2
parent_key	org_cost_pool_tree	node_key	fk_org_cost_pool_tree3

Referenced from

Table	Column	Foreign Key Name
org_cost_pool_tree	parent_key	fk_org_cost_pool_tree3

Check Constraints

Name	Definition
cc_org_cost_pool_tree_left	([left_visit]>(0))
cc_org_cost_pool_tree_level	([tree_level]>=(0))
cc_org_cost_pool_tree_right	([right_visit]>(0))

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_org_cost_pool_tree	true	node_key	Asc
idx_org_cost_pool_tree1	false	left_visit	Asc
idx_org_cost_pool_tree2	false	parent_key	Asc