Table idempiere11.adempiere.ad_table
Table for the Fields

 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_table_id numeric 10
ad_attribute.ad_table_id adtable_adattribute C
ad_column.ad_table_id ad_table_column C
ad_infowindow.ad_table_id adtable_adinfowindow R
ad_process_drillrule.ad_table_id adtable_addrillrule R
ad_ref_table.ad_table_id add_table_reftable R
ad_searchdefinition.ad_table_id adtable_adsearchdefinition R
ad_statuslineusedin.ad_table_id adtable_adstatuslineusedin R
ad_tab.ad_table_id ad_table_tab R
ad_table_scriptvalidator.ad_table_id adtable_adtablescriptvalidator R
ad_tableindex.ad_table_id adtable_adtableindex R
ad_tablepartition.ad_table_id adtable_adtablepartition R
ad_verifymigration.ad_table_id adtable_adverifymigration R
ad_viewcomponent.ad_table_id adtable_adviewcomponent R
ad_viewcomponent.referenced_table_id referencedtable_adviewcomponen R
ad_zoomcondition.ad_table_id adtable_adzoomcondition R
Database Table information
ad_client_id numeric 10 Tenant for this installation.
ad_org_id numeric 10 Organizational entity within tenant
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
tablename varchar 40 Name of the table in the database
isview bpchar 1 'N'::bpchar This is a view
accesslevel bpchar 1 Access Level required
entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_window_id numeric 10  √  null
ad_window.ad_window_id ad_window_table N
Data entry or display window
ad_val_rule_id numeric 10  √  null
ad_val_rule.ad_val_rule_id ad_valrule_table R
Dynamic Validation Rule
loadseq numeric 10  √  null Sequence
issecurityenabled bpchar 1 'N'::bpchar If security is enabled, user access to data can be restricted via Roles
isdeleteable bpchar 1 'Y'::bpchar Indicates if records can be deleted from the database
ishighvolume bpchar 1 'N'::bpchar Use Search instead of Pick list
importtable bpchar 1  √  null Import Table Columns from Database
ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
replicationtype bpchar 1 'L'::bpchar Type of Data Replication
po_window_id numeric 10  √  null
ad_window.ad_window_id adwindowpo_adtable R
Purchase Order Window
copycolumnsfromtable varchar 1  √  null Copy Columns From Table
iscentrallymaintained bpchar 1  √  'Y'::bpchar Information maintained in System Element table
ad_table_uu varchar 36  √  NULL::character varying AD_Table_UU
processing bpchar 1  √  NULL::bpchar Process Now
databaseviewdrop bpchar 1  √  NULL::bpchar Drop view
copycomponentsfromview bpchar 1  √  NULL::bpchar Copy Components From View
createwindowfromtable bpchar 1  √  NULL::bpchar Create Window From Table
isshowindrilloptions bpchar 1  √  'Y'::bpchar This parameter enables the table to be displayed in Drill Assistant - Table tab
ispartition bpchar 1 'N'::bpchar This is a partitioned table
createpartition bpchar 1  √  NULL::bpchar Process which create or update table partitions based on the table and column records

Table contained 1.052 rows at 2024-01-03 13:46 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_table_id Primary key Asc ad_table_pkey
Must be unique ad_table_name
ad_table_uu Must be unique Asc ad_table_uu_idx

Close relationships  within of separation: