Table: dbo.Engagement_Folder_Type
This table stores information about the possible roles a folder can play in an engagement binder.
Columns
NameTypeConstraintsDescription
engagement_folder_type_KEYint (4)NOT NULLDetermines which type of folder this record represents. The Primary Key.
descriptionnvarchar (60)NOT NULLThe description for this record.
Primary key
NameColumnsDescription
PK_Engagement_Folder_Typeengagement_folder_type_KEY
Unique constraints
NameColumnsDescription
UK_Engagement_Folder_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Folder__Engagement_Folder_Type__engagement_folder_type_KEYengagement_folder_type_KEYFolder

Schema diagram