Table: Status_Event
Columns
NameTypeConstraintsDescription
status_event_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
row_versiontimestampNOT NULL
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
descriptionnvarchar (50)NOT NULLUser defined description (unique).
status_event_type_KEYintNOT NULLKey to one of the records in the Status_Event_Type table.
integration_application_KEYintNOT NULLKey to one of the records in the Integration_Application table.
status_event_codenvarchar (11)NOT NULL
Primary key
NameColumnsDescription
PK_Status_Event$status_event_KEYstatus_event_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Status_Event$integration_application_KEY$status_event_type_KEY$descriptionintegration_application_KEY, status_event_type_KEY, description
Indexes
NameColumnsDescription
IX_Status_Event$status_event_type_KEYstatus_event_type_KEYIndex supports foreign key FK_Status_Event__Status_Event_Type__status_event_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Status_Event__Integration_Application__integration_application_KEYintegration_application_KEYIntegration_Application
FK_Status_Event__Status_Event_Type__status_event_type_KEYstatus_event_type_KEYStatus_Event_Type
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Status_Event__Status_Event__status_event_KEYstatus_event_KEYClient_Status_Event

Schema diagram