Table: Won_Reason
Columns
NameTypeConstraintsDescription
won_reason_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
descriptionnvarchar (250)NOT NULLUser defined description (unique).
create_date_utcdatetimeNOT NULL
row_versiontimestampNOT NULL
Primary key
NameColumnsDescription
PK_Won_Reason$won_reason_KEYwon_reason_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Won_Reason$descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client__Won_Reason__won_reason_KEYwon_reason_KEYClient

Schema diagram