Table: acct_fin_tree

Previous: acct_cost_pool_tree

Unanet Data Model

Next: acct_org_access

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	node_key	decimal(15)		account	fk_acct_fin_tree1
2.		parent_key	decimal(15)		acct_fin_tree	fk_acct_fin_tree2, fk_acct_fin_tree3
3.		tree_level	int
4.		left_visit	int
5.		right_visit	int

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
node_key	account	account_key	fk_acct_fin_tree1
parent_key	account	account_key	fk_acct_fin_tree2
parent_key	acct_fin_tree	node_key	fk_acct_fin_tree3

Referenced from

Table	Column	Foreign Key Name
acct_fin_tree	parent_key	fk_acct_fin_tree3

Check Constraints

Name	Definition
cc_acct_fin_tree_left	([left_visit]>(0))
cc_acct_fin_tree_level	([tree_level]>=(0))
cc_acct_fin_tree_right	([right_visit]>(0))

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_acct_fin_tree	true	node_key	Asc
idx_acct_fin_tree1	false	left_visit	Asc
idx_acct_fin_tree2	false	parent_key	Asc