View erp.COMPIERE.AD_WINDOW_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_WINDOW_ID number 10
AD_WINDOW AD_WINDOW_ID Implied Constraint
NAME nvarchar2 120
DESCRIPTION nvarchar2 510  √  null
HELP nvarchar2 4000  √  null
WINDOWTYPE char 1  √  null
AD_COLOR_ID number 10  √  null
AD_COLOR AD_COLOR_ID Implied Constraint
AD_IMAGE_ID number 10  √  null
AD_IMAGE AD_IMAGE_ID Implied Constraint
ISACTIVE char 1
WINWIDTH number 10  √  null
WINHEIGHT number 10  √  null
ISSOTRX char 1
View SQL:
SELECT trl.AD_Language, 
bt.AD_Window_ID, trl.Name, trl.Description, trl.Help, bt.WindowType, 
bt.AD_Color_ID, bt.AD_Image_ID, bt.IsActive, bt.WinWidth, bt.WinHeight,
    bt.IsSOTrx
FROM AD_Window bt
INNER JOIN AD_Window_Trl trl ON (bt.AD_Window_ID=trl.AD_Window_ID)
WHERE bt.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.