Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
GroupID | INT | 10 | √ | null |
|
|
||
ParentID | INT | 10 | null |
|
|
|||
Parents | TEXT | 65535 | null |
|
|
|||
Children | TEXT | 65535 | null |
|
|
|||
depth | INT | 10 | null |
|
|
|||
Name | VARCHAR | 50 | null |
|
|
|||
FullName | VARCHAR | 2048 | null |
|
|
|||
Permissions | INT | 10 | null |
|
|
|||
Template | INT | 10 | null |
|
|
|||
AutoJoinScript | INT | 10 | null |
|
|
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | GroupID |
AutoJoinScript | Performance | Asc | AutoJoinScript |
Control | Performance | Asc | Control |
ControlID | Performance | Asc | ControlID |
depth | Performance | Asc | depth |
GroupType | Performance | Asc | GroupType |
GUID | Must be unique | Asc | GUID |
Master | Performance | Asc | Master |
Name | Performance | Asc | Name |
ParentID | Performance | Asc | ParentID |