Table: dbo.Document_Management_System_Value_Type
This table defines all supported value types when outputting to various Document Management Systems.
Columns
NameTypeConstraintsDescription
document_management_system_value_type_KEYint (4)NOT NULLPrimary Key for this table.
descriptionnvarchar (60)NOT NULLThe description of the Document Management System Value Type.
Primary key
NameColumnsDescription
PK_Document_Management_System_Value_Typedocument_management_system_value_type_KEY
Unique constraints
NameColumnsDescription
UK_Document_Management_System_Value_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Onvio_Documents_Mapping__Document_Management_System_Value_Type__document_management_system_value_type_KEYdocument_management_system_value_type_KEYOnvio_Documents_MappingMust reference appropriate foreign Value Type table.

Schema diagram