Table: Status_Event
Columns
Name | Type | Constraints | Description
status_event_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table
row_version | timestamp | NOT NULL |
update__staff_KEY | int | NOT NULL |
update_date_utc | datetime | NOT NULL |
create_date_utc | datetime | NOT NULL |
description | nvarchar (50) | NOT NULL | User defined description (unique).
status_event_type_KEY | int | NOT NULL | Key to one of the records in the Status_Event_Type table.
integration_application_KEY | int | NOT NULL | Key to one of the records in the Integration_Application table.
status_event_code | nvarchar (11) | NOT NULL |

Primary key
Name | Columns | Description
PK_Status_Event$status_event_KEY | status_event_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Status_Event$integration_application_KEY$status_event_type_KEY$description | integration_application_KEY, status_event_type_KEY, description |
Indexes
Name | Columns | Description
IX_Status_Event$status_event_type_KEY | status_event_type_KEY | Index supports foreign key FK_Status_Event__Status_Event_Type__status_event_type_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Status_Event__Integration_Application__integration_application_KEY | integration_application_KEY | Integration_Application |
FK_Status_Event__Status_Event_Type__status_event_type_KEY | status_event_type_KEY | Status_Event_Type |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Client_Status_Event__Status_Event__status_event_KEY | status_event_KEY | Client_Status_Event |