Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| GroupID | INT | 10 | √ | null |
|
|
||
| ParentID | INT | 10 | null |
|
|
|||
| Parents | VARCHAR | 200 | null |
|
|
|||
| Children | VARCHAR | 200 | null |
|
|
|||
| Depth | INT | 10 | null |
|
|
|||
| Name | VARCHAR | 50 | null |
|
|
|||
| FullName | VARCHAR | 254 | null |
|
|
|||
| PermID | INT | 10 | null |
|
|
|||
| TemplateID | INT | 10 | null |
|
|
|||
| TemplatePriority | INT | 10 | null |
|
|
|||
| AutoJoinSearch | INT | 10 | null |
|
|
|||
| MasterStatus | INT | 10 | null |
|
|
|||
| Notes | TEXT | 65535 | null |
|
|
|||
| GroupType | INT | 10 | null |
|
|
|||
| LimitSearch | INT | 10 | null |
|
|
|||
| SearchType | INT | 10 | null |
|
|
|||
| ConfigClasses | TEXT | 65535 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | GroupID |
Diagram producer might be missing
No diagrams were produced please see application output for any errors