Table: org_tree

Previous: org_fin_tree

Unanet Data Model

Next: password_reset_request

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	node_key	decimal(15)		customer	fk_org_tree1
2.		parent_key	decimal(15)		org_tree	fk_org_tree2, fk_org_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_tree1
parent_key	customer	customer_key	fk_org_tree2
parent_key	org_tree	node_key	fk_org_tree3

Referenced from

Table	Column	Foreign Key Name
org_tree	parent_key	fk_org_tree3

Check Constraints

Name	Definition
cc_org_tree_left	([left_visit]>(0))
cc_org_tree_level	([tree_level]>=(0))
cc_org_tree_right	([right_visit]>(0))

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_org_tree	true	node_key	Asc
idx_org_tree1	false	left_visit	Asc
idx_org_tree2	false	parent_key	Asc