~~~ MasterDesign ~~~

DESIGNLAYOUT
- LAYOUT_ID           PK (BIGINT)      ID of the masterDesign
- LAYOUT_SOURCE       (TEXT)                   

~~~ MasterDesign Name and Descriptions ~~~

DESIGNLAYOUT_NAMES
- LAYOUT_ID           PK (BIGINT)      ID of the masterDesign
- LANGUAGE_ID         (INTEGER)        0, 1  Language ID
- LAYOUT_ID2          (BIGINT)         1, 2, 3 ... Identify for Images
- LAYOUT_NAME         (VARCHAR 50)     Name
- LAYOUT_DESC         (VARCHAR 1000)   Short Description

~~~ LayoutModule ~~~

DESIGNLAYOUT_FT
- FUNCTION_ID         PK (BIGINT)      ID of the Function
- PLACEHOLDER         (VARCHAR 50)     loginArea, ... name of the placeholder
- F_TYPE              (INTEGER)        1 Menus 2 Portlets 3 others 4 content 5 nav
- POSITION_ID         (INTEGER)        1, 2, 4 ... Identify for Location (dm_1_9)

~~~ LayoutModuleParameter ~~~

DESIGNLAYOUT_FTP
- PARAMETER_ID        PK (BIGINT)      ID of the Parameter
- FUNCTION_ID         (BIGINT)         ID of the Function
- P_POSITION          (INTEGER)        1, 2, 3 the Parameter Position
- P_TYPE              (INTEGER)        1 selectBox 2 checkBox 
                                       3 radioButton 4 inputTxt 5 textArea 
                                       6 textArea + Wysiwyg 7 languages 8 fonts
- P_SOURCE            (TEXT)           The code of the Parameter
- P_VALUES            (VARCHAR 1000)   The possible Values of the Parameter

~~~ LayoutModule, LayoutModuleParameter, StyleSheets ~~~

DESIGN_NAMES
- DESIGN_ID           PK (BIGINT)      ID of the Function, Parameter or StyleSheet
- LANGUAGE_ID         PK (INTEGER)     0, 1  Language ID
- TYP                 PK (INTEGER)     1 FTS 2 FTP 3 CSS
- DESIGN_NAME         (VARCHAR 50)     Name of the Function, Parameter or StyleSheet
- DESIGN_DESC         (VARCHAR 1000)   Description of the Function, Parameter or StyleSheet
- KEYWORDS            (VARCHAR 1000)   Keywords of the Function, Parameter or StyleSheet

~~~ StyleSheets ~~~

DESIGN_CSS
- STYLE_ID            PK (INTEGER)     ID of the StyleSheet
- STYLE_NAME          (VARCHAR 50)     fontFace, ... Name of the StyleSheet
- STYLE_TYPE          (INTEGER)        0 BODY 1 BackGrounds 2 Fonts 3 TXT 4 Links 5 Forms

~~~ StyleSheetsValues ~~~

DESIGN_CSS_VALUES
- VALUE_ID            PK (BIGINT)      ID of the StyleSheetParemeter
- STYLE_ID            (INTEGER)        ID of the StyleSheet
- VALUE_TYPE          (VARCHAR 200)    background-color, ... ValueType of StyleSheetParam.
- VT_VALUE            (VARCHAR 255)    003366, ... Value of the StyleSheetParameter