EVENT_MASTER
As the name indicates this is the master table which most tables are depended on. The primary purpose of EVENT_MASTER is to control the status of a job. The secondary role of the table is to provide user defined classification, grouping, labeling etc. This is made possible with a number of generic fields in different types. EVENT_MASTER delete is cascaded in all related tables.
Column | Required (not Null) | Type | Values | Comments |
gKey | Yes | Uniqueidentifier | ||
Created_By | Yes | Varchar (50) | ||
Created_On | Yes | Datetime | Auto generated | |
Status | Yes | Integer | -1 = In progress 0 = Ready for processing |
Default value for the field is -1 i.e. in progress. |
Source | Integer | User defined field. Recommended to be used to indicate the application source for the outgoing message | ||
Int1 | Integer | User Defined Field | ||
Int2 | Integer | User Defined Field | ||
Int3 | Integer | User Defined Field | ||
Int4 | Integer | User Defined Field | ||
Int5 | Integer | User Defined Field | ||
Int6 | Integer | User Defined Field | ||
Int7 | Integer | User Defined Field | ||
Int8 | Integer | User Defined Field | ||
Int9 | Integer | User Defined Field | ||
Str1 | Varchar (250) | User Defined Field | ||
Str2 | Varchar (250) | User Defined Field | ||
Str3 | Varchar (250) | User Defined Field | ||
Str4 | Varchar (250) | User Defined Field | ||
Str5 | Varchar (250) | User Defined Field | ||
Dte1 | Datetime | User Defined Field | ||
Dte2 | Datetime | User Defined Field | ||
Dte3 | Datetime | User Defined Field | ||
Dte4 | Datetime | User Defined Field | ||
Dte5 | Datetime | User Defined Field | ||
Flt1 | Float | User Defined Field | ||
Flt2 | Float | User Defined Field | ||
Flt3 | Float | User Defined Field | ||
Flt4 | Float | User Defined Field | ||
Flt5 | Float | User Defined Field | ||
Uid1 | Uniqueidentifier | User Defined Field | ||
Uid2 | Uniqueidentifier | User Defined Field | ||
Uid3 | Uniqueidentifier | User Defined Field | ||
Uid4 | Uniqueidentifier | User Defined Field | ||
Uid5 | Uniqueidentifier | User Defined Field |