View erp.COMPIERE.AD_TAB_VT

 Generated by
SchemaSpy
Implied relationships Related columns Constraint names Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents
AD_LANGUAGE varchar2 6
AD_LANGUAGE AD_LANGUAGE Implied Constraint
AD_TAB_ID number 10
AD_TAB AD_TAB_ID Implied Constraint
AD_WINDOW_ID number 10
AD_WINDOW AD_WINDOW_ID Implied Constraint
AD_TABLE_ID number 10
AD_TABLE AD_TABLE_ID Implied Constraint
NAME nvarchar2 120
DESCRIPTION nvarchar2 510  √  null
HELP nvarchar2 4000  √  null
SEQNO number 10
ISSINGLEROW char 1
HASTREE char 1
ISINFOTAB char 1  √  null
REPLICATIONTYPE char 1
TABLENAME varchar2 40
ACCESSLEVEL char 1
ISSECURITYENABLED char 1
ISDELETEABLE char 1
ISHIGHVOLUME char 1
ISVIEW char 1
HASASSOCIATION char 1  √  null
ISTRANSLATIONTAB char 1
ISREADONLY char 1
AD_IMAGE_ID number 10  √  null
AD_IMAGE AD_IMAGE_ID Implied Constraint
TABLEVEL number 10
WHERECLAUSE nvarchar2 4000  √  null
ORDERBYCLAUSE nvarchar2 4000  √  null
COMMITWARNING nvarchar2 4000  √  null
READONLYLOGIC nvarchar2 4000  √  null
DISPLAYLOGIC nvarchar2 4000  √  null
AD_COLUMN_ID number 10  √  null
AD_COLUMN AD_COLUMN_ID Implied Constraint
AD_PROCESS_ID number 10  √  null
AD_PROCESS AD_PROCESS_ID Implied Constraint
ISSORTTAB char 1
ISINSERTRECORD char 1
ISADVANCEDTAB char 1
AD_COLUMNSORTORDER_ID number 10  √  null
AD_COLUMNSORTYESNO_ID number 10  √  null
INCLUDED_TAB_ID number 10  √  null
View SQL:
SELECT trl.AD_Language, t.AD_Tab_ID, t.AD_Window_ID, t.AD_Table_ID, trl.Name, trl.Description, 
    trl.Help, t.SeqNo, t.IsSingleRow, t.HasTree, t.IsInfoTab, tbl.ReplicationType,
    tbl.TableName, tbl.AccessLevel, tbl.IsSecurityEnabled, tbl.IsDeleteable, 
    tbl.IsHighVolume, tbl.IsView, 'N' AS HasAssociation, -- compatibility
    t.IsTranslationTab, t.IsReadOnly, t.AD_Image_ID, t.TabLevel, 
    t.WhereClause, t.OrderByClause, trl.CommitWarning, t.ReadOnlyLogic, t.DisplayLogic,
    t.AD_Column_ID, t.AD_Process_ID, t.IsSortTab, t.IsInsertRecord, t.IsAdvancedTab,
    t.AD_ColumnSortOrder_ID, t.AD_ColumnSortYesNo_ID, t.Included_Tab_ID
FROM AD_Tab t 
INNER JOIN AD_Table tbl ON (t.AD_Table_ID = tbl.AD_Table_ID)
INNER JOIN AD_Tab_Trl trl ON (t.AD_Tab_ID = trl.AD_Tab_ID)
WHERE t.IsActive='Y'
  AND tbl.IsActive='Y'


SchemaSpy was unable to generate a graphical representation of table relationships.
An appropriate version of dot must be in your path when generating these pages.
Requires dot version 2.2.1 or versions greater than 2.4 from www.graphviz.org.