Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Seq | int identity | 4 | √ | null |
|
|
||
| GroupCode | varchar | 15 | √ | null |
|
|
||
| ResourceType | varchar | 5 | √ | null |
|
|
||
| Module | varchar | 30 | √ | null |
|
|
||
| Resource1 | varchar | 50 | √ | null |
|
|
||
| Resource2 | varchar | 50 | √ | null |
|
|
||
| Resource3 | varchar | 50 | √ | null |
|
|
||
| SelectFlag | bit | 1 | √ | null |
|
|
||
| UpdateFlag | bit | 1 | √ | null |
|
|
||
| InsertFlag | bit | 1 | √ | null |
|
|
||
| DeleteFlag | bit | 1 | √ | null |
|
|
||
| PriorSelectFlag | bit | 1 | √ | null |
|
|
||
| PriorUpdateFlag | bit | 1 | √ | null |
|
|
||
| PriorInsertFlag | bit | 1 | √ | null |
|
|
||
| PriorDeleteFlag | bit | 1 | √ | null |
|
|
||
| SynDatabaseCode | varchar | 5 | √ | null |
|
|
||
| ConfigGroupSecuritySeq | int | 4 | √ | null |
|
|
||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| ModifiedBy | varchar | 50 | √ | null |
|
|
||
| UserName | varchar | 200 | √ | null |
|
|
||
| WorkstationName | varchar | 100 | √ | null |
|
|
||
| AuditAction | varchar | 10 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ConfigGroupSecurityHistory_Seq | Primary key | Asc | Seq |