Table: dbo.Priority
This table contains levels of priority.
Columns
NameTypeConstraintsDescription
priority_KEYint (4)NOT NULLPrimary key. This points to the Priority table.
descriptionnvarchar (20)NOT NULLThe description for the priority of the note.
Primary key
NameColumnsDescription
PK_Prioritypriority_KEY
Unique constraints
NameColumnsDescription
UK_Priority$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Engagement_Item_Note__Priority__priority_KEYpriority_KEYEngagement_Item_Note

Schema diagram