Table: Referral_Type
Tags: read-only

Content:
9961000<Client>Client
9972000<Contact>Contact
9994000Referral SourceReferral_Source
10005000<Staff>Staff
Columns
NameTypeConstraintsDescription
referral_type_KEYintNOT NULLPrimary key for this table.
sortintNOT NULLUser defined sort for this table.
descriptionnvarchar (30)NOT NULLUser defined description (unique).
table_namenvarchar (128)NOT NULLName of the table that corresponds to this type.
Primary key
NameColumnsDescription
PK_Referral_Type$referral_type_KEYreferral_type_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Referral_Type__descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client__Referral_Type__referral_type_KEYreferral_type_KEYClient

Schema diagram