Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| MessageDate | datetime | 16,3 | √ | null |
|
|
||
| SynergyUser | varchar | 50 | √ | null |
|
|
||
| Workstation | varchar | 50 | √ | null |
|
|
||
| ProgramCode | varchar | 55 | √ | null |
|
|
||
| Message | varchar | 1000 | null |
|
|
|||
| Response | varchar | 20 | √ | null |
|
|
||
| TraceType | varchar | 15 | ('') |
|
|
|||
| SynWebFlag | bit | 1 | ((0)) |
|
|
|||
| AppName | varchar | 128 | ('') |
|
|
|||
| MessageLogSeq | int identity | 4 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| AK_MessageLog_MessageDate | Performance | Asc | MessageDate |
| AK_MessageLog_MessageDateUser | Performance | Asc/Asc | MessageDate + SynergyUser |
| AK_MessageLog_SynergyUser | Performance | Asc | SynergyUser |
| AK_MessageLog_TraceType | Performance | Asc | TraceType |