Name |
Definition |
Datatype |
Required |
Is PK |
Is FK |
Event Identifier |
An Event Identifier is a unique value assigned to represent a temporal incident that occured for a given Application Database. |
INTEGER |
Yes |
Yes |
No |
Application Database Identifier |
An Application Database Identifier is a unique value that denotes a particular application database. |
INTEGER |
Yes |
No |
Yes |
Technology Event Type Identifier |
A Technology Event Type Identifier is a unique value that represents kind of computer / software occurence that may be planned or unexpected. |
INTEGER |
Yes |
No |
Yes |
Summary Text |
A Summary Text is the free form text that describes something that has happened at a particular point in time |
VARCHAR(4000) |
Yes |
No |
No |
Start Timestamp |
A Start Timestamp is a particular point within the noted 24 hour period on the Gregorian calendar that something was first noticed or started to happen. |
TIMESTAMP |
Yes |
No |
No |
End Timestamp |
An End Timestamp is a particular point within the noted 24 hour period on the Gregorian calendar that something came to an end. |
TIMESTAMP |
No |
No |
No |