Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
ID | varchar | 50 | null |
|
|
|||
LABELKEYSHORT | varchar | 255 | √ | null |
|
|
||
LABELKEYLONG | varchar | 255 | √ | null |
|
|
||
URL | varchar | 255 | √ | null |
|
|
||
IMAGEPATH | varchar | 255 | √ | null |
|
|
||
FEATURED | varchar | 255 | √ | null |
|
|
||
OPERATORSONID | bit | 1 | √ | ((0)) |
|
|
||
CHECKPERMISSION | bit | 1 | √ | ((0)) |
|
|
||
ONLYLARGESCREEN | bit | 1 | √ | ((0)) |
|
|
||
ONLYSMALLSCREEN | bit | 1 | √ | ((0)) |
|
|
||
HIDEONIOSIONIC3 | bit | 1 | √ | ((0)) |
|
|
||
ONLYMOBILE | bit | 1 | √ | ((0)) |
|
|
||
GROUPER | bit | 1 | √ | ((0)) |
|
|
||
REMOVEMENUITEM | bit | 1 | √ | ((0)) |
|
|
||
CHILDOF | varchar | 50 | √ | null |
|
|
||
INSERTATINDEX | smallint | 2 | √ | null |
|
|
||
RECCREATEDBY | varchar | 50 | √ | null |
|
|
||
RECCREATEDON | datetime | 16,3 | √ | null |
|
|
||
RECMODIFIEDBY | varchar | 50 | √ | null |
|
|
||
RECMODIFIEDON | datetime | 16,3 | √ | null |
|
|
||
MODULE | varchar | 1 | √ | ((0)) |
|
|
||
SECURITYID | varchar | 100 | √ | ((0)) |
|
|
||
EXECUTIONID | varchar | 100 | √ | ((0)) |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PKPCUSTOMMENUS | Primary key | Asc | ID |
Diagram producer might be missing
No diagrams were produced please see application output for any errors