Table idempiere9.adempiere.ad_tab
Tab within a Window

 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_tab_id numeric 10
ad_field.ad_tab_id ad_tab_field C
ad_field.included_tab_id includedtab_adfield R
ad_importtemplate.ad_tab_id adtab_adimporttemplate R
ad_recentitem.ad_tab_id adtab_adrecentitem C
ad_statuslineusedin.ad_tab_id adtab_adstatuslineusedin R
ad_tab.included_tab_id adtab_included R
ad_tab_customization.ad_tab_id adtab_adtabcustomization R
ad_tab_trl.ad_tab_id ad_tabtrl C
ad_toolbarbutton.ad_tab_id adtab_adtoolbarbutton R
ad_toolbarbuttonrestrict.ad_tab_id adtab_adtoolbarbuttonrestrict R
ad_userdef_tab.ad_tab_id adtab_aduserdeftab R
ad_userquery.ad_tab_id adtab_aduserquery R
asp_clientexception.ad_tab_id adtab_aspclientexception R
asp_tab.ad_tab_id adtab_asptab R
Tab within a Window
ad_client_id numeric 10
ad_client.ad_client_id tabclient R
Client/Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id taborg R
Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
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
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
help varchar 2000  √  null Comment or Hint
ad_table_id numeric 10
ad_table.ad_table_id ad_table_tab R
Database Table information
ad_window_id numeric 10
ad_window.ad_window_id ad_window_tab C
Data entry or display window
seqno numeric 10 Method of ordering records; lowest number comes first
tablevel numeric 10 Hierarchical Tab Level (0 = top)
issinglerow bpchar 1 'Y'::bpchar Default for toggle between Single- and Multi-Row (Grid) Layout
isinfotab bpchar 1  √  'N'::bpchar This Tab contains accounting information
istranslationtab bpchar 1 'N'::bpchar This Tab contains translation information
isreadonly bpchar 1 'N'::bpchar Field is read only
ad_column_id numeric 10  √  null
ad_column.ad_column_id ad_column_ad_tab R
Column in the table
hastree bpchar 1 'N'::bpchar Window has Tree Graph
whereclause varchar 2000  √  null Fully qualified SQL WHERE clause
orderbyclause varchar 2000  √  null Fully qualified ORDER BY clause
commitwarning varchar 2000  √  null Warning displayed when saving
ad_process_id numeric 10  √  null
ad_process.ad_process_id adprocess_adtab R
Process or Report
processing bpchar 1  √  null Process Now
ad_image_id numeric 10  √  null
ad_image.ad_image_id adimage_adtab R
Image or Icon
importfields bpchar 1  √  null Create Fields from Table Columns
ad_columnsortorder_id numeric 10  √  null
ad_column.ad_column_id adcolumn_adtabsortorder R
Column determining the order
ad_columnsortyesno_id numeric 10  √  null
ad_column.ad_column_id adcolumn_adtabsortyesno R
Column determining if a Table Column is included in Ordering
issorttab bpchar 1 'N'::bpchar The Tab determines the Order
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_adtab R
Dictionary Entity Type; Determines ownership and synchronization
included_tab_id numeric 10  √  null
ad_tab.ad_tab_id adtab_included R
Included Tab in this Tab (Master Detail)
readonlylogic varchar 2000  √  null Logic to determine if field is read only (applies only when field is read-write)
displaylogic varchar 2000  √  null If the Field is displayed, the result determines if the field is actually displayed
isinsertrecord bpchar 1 'Y'::bpchar The user can insert a new Record
isadvancedtab bpchar 1 'N'::bpchar This Tab contains advanced Functionality
parent_column_id numeric 10  √  NULL::numeric
ad_column.ad_column_id parentcolumn_adtab R
The link column on the parent tab.
ad_tab_uu varchar 36  √  NULL::character varying AD_Tab_UU
ad_ctxhelp_id numeric 10  √  NULL::numeric
ad_ctxhelp.ad_ctxhelp_id adctxhelp_adtab R
Context Help
treedisplayedon bpchar 1 'B'::bpchar The tree can be displayed on master tab, detail tab or both
maxqueryrecords numeric 10  √  '0'::numeric If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
islookuponlyselection bpchar 1  √  'N'::bpchar When defined to true Lookup panel will display only selection columns. Default to false.
isallowadvancedlookup bpchar 1  √  'Y'::bpchar Allow Advanced Lookup
ad_tabtype varchar 40  √  NULL::character varying Defines Tab Type

Table contained 1,103 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_tab_id Primary key Asc ad_tab_pkey
ad_table_id Performance Asc ad_tab_table
ad_tab_uu Must be unique Asc ad_tab_uu_idx
ad_window_id Performance Asc ad_tab_window


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.