Table: Referral_Source
Columns
NameTypeConstraintsDescription
referral_source_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
descriptionnvarchar (30)NOT NULLUser defined description (unique).
create_datedatetimeNOT NULL
row_versiontimestampNOT NULL
Primary key
NameColumnsDescription
PK_Referral_Source$referral_source_KEYreferral_source_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Referral_Source__descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client__Referral_Source__referred_by__referral_source_KEYreferred_by__referral_source_KEYClient

Schema diagram