Table: Client_Status_Event
Columns
NameTypeConstraintsDescription
client_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
client_KEYintNOT NULLKey to the Client record that this status event was recorded for.
status_event_KEYintNOT NULLKey to the Status_Event that was recorded.
event_date_utcdatetimeNOT NULLThe date and time the status event was recorded in UTC.
user_namenvarchar (30)NOT NULLThe name of the user that recorded the event.
commentsnvarchar (-1)NOT NULLUser defined comments.
processed_for_project_extensionbitNOT NULL
Primary key
NameColumnsDescription
PK_Client_Status_Event$client_status_event_KEYclient_status_event_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Client_Status_Event$client_KEY$status_event_KEY$event_date_utcclient_KEY, status_event_KEY, event_date_utc
Indexes
NameColumnsDescription
IX_Client_Status_Event$processed_for_project_extension$event_date_utc@status_event_KEYprocessed_for_project_extension, event_date_utc, status_event_KEYThis index is used to find client status events that need to be analysed to determine if any projects should be extended.
IX_Client_Status_Event$status_event_KEYstatus_event_KEYIndex supports foreign key FK_Client_Status_Event__Status_Event__status_event_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Status_Event__Client__client_KEYclient_KEYClienton delete cascade;
FK_Client_Status_Event__Status_Event__status_event_KEYstatus_event_KEYStatus_Event

Schema diagram