|
ColumnName |
DataType |
PrimaryKey |
NotNull |
Flags |
Default |
Comment |
AutoInc |
|---|---|---|---|---|---|---|---|
|
AlarmStateDesc |
VARCHAR(31) |
NN |
|||||
|
AreaOfInterest |
VARCHAR(254) |
NN |
|||||
|
Category |
VARCHAR(31) |
NN |
|||||
|
ClientAddress |
INTEGER |
NN |
|||||
|
ClientAddressDesc |
VARCHAR(15) |
NN |
|||||
|
ClientName |
VARCHAR(15) |
NN |
|||||
|
CommentNo |
INTEGER |
NN |
|||||
|
CustomNumericField1 |
TINYINT |
NN |
|||||
|
CustomNumericField2 |
SMALLINT |
NN |
|||||
|
CustomNumericField3 |
INTEGER |
NN |
|||||
|
CustomStringField |
VARCHAR(253) |
NN |
|||||
|
Deleted |
BIT |
NN |
|||||
|
EncodedMessage |
VARCHAR(253) |
NN |
|||||
|
FileId |
VARCHAR(16) |
NN |
|||||
|
FileOffset |
INTEGER |
NN |
|||||
|
Foreground |
INTEGER |
NN |
|||||
|
Id |
INTEGER |
NN |
|||||
|
InvariantRecordId |
VARCHAR(40) |
NN |
|||||
|
Location |
VARCHAR(32) |
NN |
|||||
|
Message |
VARCHAR(253) |
NN |
|||||
|
MessageLong |
INTEGER |
NN |
|||||
|
NamedRegion |
VARCHAR(31) |
NN |
|||||
|
ReceiptTime |
TIMESTAMP |
NN |
|||||
|
RecordId |
VARCHAR(33) |
NN |
|||||
|
RecordTime |
TIMESTAMP |
NN |
|||||
|
SeqNo |
INTEGER |
NN |
|||||
|
Severity |
VARCHAR(31) |
NN |
|||||
|
SeverityDesc |
VARCHAR(31) |
NN |
|||||
|
SeverityValue |
INTEGER |
NN |
|||||
|
Source |
VARCHAR(254) |
NN |
|||||
|
SuppressionType |
VARCHAR(253) |
NN |
|||||
|
Time |
TIMESTAMP |
NN |
|||||
|
User |
VARCHAR(63) |
NN |
|
IndexName |
IndexType |
Columns |
|---|---|---|
|
pkCDBEventJournal |
Index |
RecordId |
|
idxRecordId |
Index |
RecordId |
|
idxFileId |
Index |
FileId |
|
idxTime |
Index |
Time |
|
idxRecordTime |
Index |
RecordTime |
|
idxId |
Index |
Id |
|
idxSource |
Index |
Source |
|
idxDeleted |
Index |
Deleted |
|
idxInvariantRecordId |
Index |
InvariantRecordId |
See Also
Published June 2018