Table: dbo.Known_Application_Extension
This table contains the known application extensions (i.e. excel has xls and xlsx, word as doc and docx, etc...).
Columns
NameTypeConstraintsDescription
known_application_extension_KEYint (4)NOT NULLPrimary key. This points to the application extension.
known_application_type_KEYint (4)NOT NULLForeign key to the Known_Application_Type table. This points to the application for this extension.
descriptionnvarchar (512)NOT NULLThe lowercase extension (without the period) of the application
Primary key
NameColumnsDescription
PK_Known_Application_Extensionknown_application_extension_KEY
Unique constraints
NameColumnsDescription
UK_Known_Application_Extension$descriptiondescription
Foreign keys
NameColumnsReferenced tableDescription
FK_Known_Application_Extension__Known_Application_Type__known_application_type_KEYknown_application_type_KEYKnown_Application_Type (known_application_type_KEY)

Schema diagram