Table: Client_Status_Event | |||
Columns | |||
Name | Type | Constraints | Description |
client_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 | |
client_KEY | int | NOT NULL | Key to the Client record that this status event was recorded for. |
status_event_KEY | int | NOT NULL | Key to the Status_Event that was recorded. |
event_date_utc | datetime | NOT NULL | The date and time the status event was recorded in UTC. |
user_name | nvarchar (30) | NOT NULL | The name of the user that recorded the event. |
comments | nvarchar (-1) | NOT NULL | User defined comments. |
processed_for_project_extension | bit | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Client_Status_Event$client_status_event_KEY | client_status_event_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Client_Status_Event$client_KEY$status_event_KEY$event_date_utc | client_KEY, status_event_KEY, event_date_utc | ||
Indexes | |||
Name | Columns | Description | |
IX_Client_Status_Event$processed_for_project_extension$event_date_utc@status_event_KEY | processed_for_project_extension, event_date_utc, status_event_KEY | This 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_KEY | status_event_KEY | Index supports foreign key FK_Client_Status_Event__Status_Event__status_event_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Client_Status_Event__Client__client_KEY | client_KEY | Client | on delete cascade; |
FK_Client_Status_Event__Status_Event__status_event_KEY | status_event_KEY | Status_Event |