Table: org_cost_pool_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