Table idempiere9.adempiere.ad_tree
Identifies a Tree

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_tree_id numeric 10
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
Identifies a Tree
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
isactive bpchar 1 'Y'::bpchar The record is active in the system
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
treetype bpchar 2 Element this tree is built on (i.e Product, Business Partner)
isallnodes bpchar 1 'Y'::bpchar All Nodes are included (Complete Tree)
processing bpchar 1  √  null Process Now
isdefault bpchar 1 'N'::bpchar Default value
ad_tree_uu varchar 36  √  NULL::character varying AD_Tree_UU
istreedrivenbyvalue bpchar 1 'N'::bpchar Driven by Search Key
ad_table_id numeric 10  √  NULL::numeric
ad_table.ad_table_id adtable_adtree R
Database Table information
isloadallnodesimmediately bpchar 1 'Y'::bpchar If checked, all nodes are loaded before tree is displayed
isvaluedisplayed bpchar 1 'N'::bpchar Displays Value column with the Display column
parent_column_id numeric 10  √  NULL::numeric
ad_column.ad_column_id parentcolumn_adtree R
The link column on the parent tab.

Table contained 23 rows at 2021-12-25 14:43 +0100

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.