Table idempiere11.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
c_element.ad_tree_id adtree_celement N
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 Tenant for this installation.
ad_org_id numeric 10 Organizational entity within tenant
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 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 The link column on the parent tab.

Table contained 23 rows at 2024-01-03 13:48 +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

Close relationships: