Table: Status_Event_Type
Columns
NameTypeConstraintsDescription
status_event_type_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
row_versiontimestampNOT NULL
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
create_datedatetimeNOT NULL
descriptionnvarchar (30)NOT NULLUser defined description (unique).
Primary key
NameColumnsDescription
PK_Status_Event_Type$status_event_type_KEYstatus_event_type_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Status_Event_Type__descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Status_Event__Status_Event_Type__status_event_type_KEYstatus_event_type_KEYStatus_Event

Schema diagram