Table: Rate_Type
Tags: read-only

Content:
1No Rate
2Staff Rate
3Fixed Rate
Columns
NameTypeConstraintsDescription
rate_type_KEYintNOT NULL
descriptionnvarchar (30)NOT NULL
Primary key
NameColumnsDescription
PK_Rate_Type$rate_type_KEYrate_type_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Rate_Type__descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Activity__Rate_Type__rate_type_KEYrate_type_KEYActivity
FK_Engagement__Rate_Type__rate_type_KEYrate_type_KEYEngagement

Schema diagram