Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| GroupCode | varchar | 15 | ('') |
|
|
|||||
| ResourceType | varchar | 5 | ('') |
|
|
|||||
| Module | varchar | 30 | ('') |
|
|
|||||
| Resource1 | varchar | 50 | ('') |
|
|
|||||
| Resource2 | varchar | 50 | ('') |
|
|
|||||
| Resource3 | varchar | 50 | ('') |
|
|
|||||
| SelectFlag | bit | 1 | ((0)) |
|
|
|||||
| UpdateFlag | bit | 1 | ((0)) |
|
|
|||||
| InsertFlag | bit | 1 | ((0)) |
|
|
|||||
| DeleteFlag | bit | 1 | ((0)) |
|
|
|||||
| SynDatabaseCode | varchar | 5 | ('') |
|
|
|||||
| ConfigGroupSecuritySeq | int identity | 4 | √ | null |
|
|
||||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
||||
| ModifiedUser | varchar | 100 | ('') |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ConfigGroupSecurity | Primary key | Asc/Asc/Asc/Asc/Asc/Asc/Asc | GroupCode + ResourceType + Module + Resource1 + Resource2 + Resource3 + SynDatabaseCode |
| AK_ConfigGroupSecurity_ConfigGroupSecuritySeq | Must be unique | Asc | ConfigGroupSecuritySeq |
| AK_ConfigGroupSecurity_ResourceType_Module_Resource1_includes | Performance | Asc/Asc/Asc | ResourceType + Module + Resource1 |
| AK_ConfigGroupSecurity_ResourceType_Module_Resource1_Resource2_Resource3 | Performance | Asc/Asc/Asc/Asc/Asc | ResourceType + Module + Resource1 + Resource2 + Resource3 |
Relationships
Close relationships within degrees of separation
