ad_tree

31 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_tree_id numeric 10 null
ad_clientinfo.ad_tree_activity_id adtreeactivity_adclientinfo R
ad_clientinfo.ad_tree_bpartner_id adtreebpartner_adclientinfo R
ad_clientinfo.ad_tree_campaign_id adtreecampaign_adclientinfo R
ad_clientinfo.ad_tree_menu_id adtreemenu_adclientinfo R
ad_clientinfo.ad_tree_org_id adtreeorg_adclientinfo R
ad_clientinfo.ad_tree_product_id adtreeproduct_adclientinfo R
ad_clientinfo.ad_tree_project_id adtreeproject_adclientinfo R
ad_clientinfo.ad_tree_salesregion_id adtreesalesreg_adclientinfo R
ad_role.ad_tree_menu_id adtree_adrole R
ad_role.ad_tree_org_id adtreeorg_adrole R
ad_treebar.ad_tree_id adtree_adtreebar C
ad_treenode.ad_tree_id adtree_adtreenode C
ad_treenodebp.ad_tree_id adtree_adtreenodebp C
ad_treenodecmc.ad_tree_id adtree_adtreenodecmc R
ad_treenodecmm.ad_tree_id adtree_adtreenodecmm C
ad_treenodecms.ad_tree_id adtree_adtreenodecms C
ad_treenodecmt.ad_tree_id adtree_adtreenodecmt C
ad_treenodemm.ad_tree_id adtree_adtreenodemm C
ad_treenodepr.ad_tree_id adtree_adtreenodepr C
ad_treenodeu1.ad_tree_id adtree_adtreenodeu1 C
ad_treenodeu2.ad_tree_id adtree_adtreenodeu2 C
ad_treenodeu3.ad_tree_id adtree_adtreenodeu3 C
ad_treenodeu4.ad_tree_id adtree_adtreenodeu4 C
c_element.ad_tree_id adtree_celement N
cm_webproject.ad_treecmc_id adtreecmc_cmwebproject R
cm_webproject.ad_treecmm_id adtreecmm_cmwebproject R
cm_webproject.ad_treecms_id adtreecms_cmwebproject R
cm_webproject.ad_treecmt_id adtreecmt_cmwebproject R
pa_hierarchy.ad_tree_account_id adtreeaccount_pahierarchy R
pa_hierarchy.ad_tree_activity_id adtreeactivity_pahierarchy R
pa_hierarchy.ad_tree_bpartner_id adtreebpartner_pahierarchy R
pa_hierarchy.ad_tree_campaign_id adtreecampaign_pahierarchy R
pa_hierarchy.ad_tree_org_id adtreeorg_pahierarchy R
pa_hierarchy.ad_tree_product_id adtreeproduct_pahierarchy R
pa_hierarchy.ad_tree_project_id adtreeproject_pahierarchy R
pa_hierarchy.ad_tree_salesregion_id adtreesr_pahierarchy R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
isactive bpchar 1 'Y'::bpchar
name varchar 60 null
description varchar 255 √ null
treetype bpchar 2 null
isallnodes bpchar 1 'Y'::bpchar
processing bpchar 1 √ null
isdefault bpchar 1 'N'::bpchar
ad_tree_uu varchar 36 √ NULL::character varying
istreedrivenbyvalue bpchar 1 'N'::bpchar
ad_table_id numeric 10 √ NULL::numeric
ad_table.ad_table_id adtable_adtree R
isloadallnodesimmediately bpchar 1 'Y'::bpchar
isvaluedisplayed bpchar 1 'N'::bpchar
parent_column_id numeric 10 √ NULL::numeric
ad_column.ad_column_id parentcolumn_adtree R

Indexes

Constraint Name Type Sort Column(s)
ad_tree_pkey Primary key Asc ad_tree_id
ad_tree_name Must be unique Asc/Asc ad_client_id + name
ad_tree_uu_idx Must be unique Asc ad_tree_uu

Check Constraints

Constraint Name Constraint
ad_tree_isloadallnodesimmediately_check ((isloadallnodesimmediately = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_tree_istreedrivenbyvalue_check ((istreedrivenbyvalue = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_tree_isvaluedisplayed_check ((isvaluedisplayed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_tree_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_tree_isallnodes_check ((isallnodes = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation