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_archive.ad_table_id adtable_adarchive R
ad_attachment.ad_table_id adtable_adattachment R
ad_impformat.ad_table_id adtable_adimpformat R
ad_note.ad_table_id adtable_adnote R
ad_pinstance.ad_table_id adtable_adpinstance R
ad_pinstance_log.ad_table_id adtable_adpinstancelog R
ad_recentitem.ad_table_id adtable_adrecentitem C
ad_sequence_audit.ad_table_id adtable_adsequenceaudit C
ad_wf_process.ad_table_id adtable_adwfprocess R
ad_workflow.ad_table_id adtable_adworkflow R
test.ad_table_id adtable_test 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:56 +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: