Table idempiere9.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_accesslog.ad_table_id adtable_adacceslog R
ad_alertrule.ad_table_id adtable_adaltertrule R
ad_archive.ad_table_id adtable_adarchive R
ad_attachment.ad_table_id adtable_adattachment R
ad_attribute.ad_table_id adtable_adattribute C
ad_changelog.ad_table_id adtable_adchangelog C
ad_chartdatasource.ad_table_id adtable_adchartdatasource R
ad_clientshare.ad_table_id adtable_adclientshare R
ad_column.ad_table_id ad_table_column C
ad_column_access.ad_table_id adtable_adcolumnaccess R
ad_housekeeping.ad_table_id adtable_adhousekeeping R
ad_impformat.ad_table_id adtable_adimpformat R
ad_infowindow.ad_table_id adtable_adinfowindow R
ad_note.ad_table_id adtable_adnote R
ad_package_exp_common.ad_table_id adtable_adpackageexpcommon R
ad_package_exp_detail.ad_table_id adtable_adpackageexpdetail R
ad_package_imp_detail.ad_table_id adtable_adpackageimpdetail R
ad_package_uuid_map.ad_table_id adtable_adpackageuuidmap R
ad_pinstance_log.ad_table_id adtable_adpinstancelog R
ad_postit.ad_table_id adtable_adpostit R
ad_printformat.ad_table_id adtable_adprintformat R
ad_printlabel.ad_table_id adtable_adprintlabel R
ad_private_access.ad_table_id adtable_adprivateaccess R
ad_recentitem.ad_table_id adtable_adrecentitem C
ad_record_access.ad_table_id adtable_adrecordaccess R
ad_ref_table.ad_table_id add_table_reftable R
ad_replicationdocument.ad_table_id adtable_adreplicationdocument R
ad_replicationtable.ad_table_id adtable_adreplicationtable C
ad_reportview.ad_table_id adtable_adreportview C
ad_scheduler.ad_table_id adtable_adscheduler R
ad_searchdefinition.ad_table_id adtable_adsearchdefinition R
ad_sequence_audit.ad_table_id adtable_adsequenceaudit C
ad_statuslineusedin.ad_table_id adtable_adstatuslineusedin R
ad_tab.ad_table_id ad_table_tab R
ad_table_access.ad_table_id adtable_adtableaccess C
ad_table_scriptvalidator.ad_table_id adtable_adtablescriptvalidator R
ad_table_trl.ad_table_id adtable_adtabletrl C
ad_tableindex.ad_table_id adtable_adtableindex R
ad_tree.ad_table_id adtable_adtree R
ad_userquery.ad_table_id adtable_aduserquery C
ad_viewcomponent.ad_table_id adtable_adviewcomponent R
ad_viewcomponent.referenced_table_id referencedtable_adviewcomponen R
ad_wf_activity.ad_table_id adtable_adwfactivity R
ad_wf_eventaudit.ad_table_id adtable_adwfeventaudit R
ad_wf_process.ad_table_id adtable_adwfprocess R
ad_workflow.ad_table_id adtable_adworkflow R
ad_zoomcondition.ad_table_id adtable_adzoomcondition R
c_acctprocessor.ad_table_id adtable_cacctprocessor R
c_onlinetrxhistory.ad_table_id adtable_conlinetrxhistory R
cm_chat.ad_table_id adtable_cmchat C
cm_chattype.ad_table_id adtable_cmchattype C
cm_templatetable.ad_table_id adtable_cmtemplatetable R
cm_wikitoken.ad_table_id adtable_cmwikitoken R
exp_format.ad_table_id adtable_expformat R
fact_acct.ad_table_id adtable_factacct R
k_index.ad_table_id adtable_kindex C
m_attributesetexclude.ad_table_id adtable_mattributesetexclude R
m_lotctlexclude.ad_table_id adtable_mlotctlexclude R
m_sernoctlexclude.ad_table_id adtable_msernoctlexclude R
m_storagereservationlog.ad_table_id adtable_mstoragereservationlog R
pa_documentstatus.ad_table_id adtable_padocumentstatus R
pa_measurecalc.ad_table_id adtable_pameasurecalc R
pa_sla_measure.ad_table_id adtable_paslameasure R
pp_order_workflow.ad_table_id adtable_pporderworkflow R
r_request.ad_table_id adtable_rrequest R
ws_webservicetype.ad_table_id adtable_wswebservicetype R
Database Table information
ad_client_id numeric 10
ad_client.ad_client_id tableclient R
Client/Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id tableorg 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
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
ad_entitytype.entitytype entityt_adtable R
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

Table contained 1,029 rows at 2021-12-25 14:43 +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


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.