Table: acct_cost_pool_tree

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK node_key decimal(15)   account fk_acct_cost_pool_tree1
2.   parent_key decimal(15)   acct_cost_pool_tree fk_acct_cost_pool_tree2, fk_acct_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 account account_key fk_acct_cost_pool_tree1
parent_key account account_key fk_acct_cost_pool_tree2
parent_key acct_cost_pool_tree node_key fk_acct_cost_pool_tree3
Referenced from
Table Column Foreign Key Name
acct_cost_pool_tree parent_key fk_acct_cost_pool_tree3
Check Constraints
Name Definition
cc_acct_cost_pool_tree_left ([left_visit]>(0))
cc_acct_cost_pool_tree_level ([tree_level]>=(0))
cc_acct_cost_pool_tree_right ([right_visit]>(0))
Indices
Index Name Unique Column Name Asc Or Desc
pk_acct_cost_pool_tree true node_key Asc
idx_acct_cost_pool_tree1 false left_visit Asc
idx_acct_cost_pool_tree2 false parent_key Asc