Table: dbo.Known_Application_Type
This table contains the known application types (i.e. excel, word, etc...).
Columns
NameTypeConstraintsDescription
known_application_type_KEYint (4)NOT NULLPrimary key. This points to the application type.
descriptionnvarchar (60)NOT NULLThe name of the application
Primary key
NameColumnsDescription
PK_Known_Application_Typeknown_application_type_KEY
Unique constraints
NameColumnsDescription
UK_Known_Application_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Known_Application_Extension__Known_Application_Type__known_application_type_KEYknown_application_type_KEYKnown_Application_Extension
FK_Workpaper__Known_Application_Type__known_application_type_KEYknown_application_type_KEYWorkpaper

Schema diagram