Table: dbo.Onvio_Documents_Mapping
This table pairs a Document_Management_System_Print_Category (as defined by the DMS_Print_Category table) and Folder Level to values for["BR"] value type, and actual folder value
Columns
NameTypeConstraintsDescription
document_management_system_print_category_KEYint (4)NOT NULLThe ACS Category that Folder Levels and Folder Values will be assigned to.
folder_levelint (4)NOT NULLWhat nested level in Onvio Documents this row corresponds to. This, in combination with the Print Category, is our tables Primary Key.
folder_valuenvarchar (300)NOT NULLThe actual value of the folder name for this row.
document_management_system_value_type_KEYint (4)NOT NULLWhat value type this folder_value corresponds to.
onvio_documents_mapping_date_format_typenvarchar (40)The date format type for Onvio Documents Folders.
Primary key
NameColumnsDescription
PK_Onvio_Documents_Mapping$document_management_system_print_category_KEY$folder_leveldocument_management_system_print_category_KEY, folder_level
Foreign keys
NameColumnsReferenced tableDescription
FK_Onvio_Documents_Mapping__Document_Management_System_Print_Category__document_management_system_print_category_KEYdocument_management_system_print_category_KEYDocument_Management_System_Print_Category (document_management_system_print_category_KEY)Must reference appropriate foreign Print Category table.
FK_Onvio_Documents_Mapping__Document_Management_System_Value_Type__document_management_system_value_type_KEYdocument_management_system_value_type_KEYDocument_Management_System_Value_Type (document_management_system_value_type_KEY)Must reference appropriate foreign Value Type table.

Schema diagram