Table: dbo.Engagement_Item_Note_Status
This table contains information needed for describing the states a note can have.
Columns
NameTypeConstraintsDescription
engagement_item_note_status_KEYint (4)NOT NULLPrimary key. This points to the notes status.
descriptionnvarchar (20)NOT NULLThe description for the status of the note.
Primary key
NameColumnsDescription
PK_Engagement_Item_Note_Statusengagement_item_note_status_KEY
Unique constraints
NameColumnsDescription
UK_Engagement_Item_Note_Status$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Engagement_Item_Note__Engagement_Item_Note_Status__engagement_item_note_status_KEYengagement_item_note_status_KEYEngagement_Item_Note

Schema diagram