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_role.ad_tree_menu_id adtree_adrole R
ad_role.ad_tree_org_id adtreeorg_adrole 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:44 +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  within of separation: