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
Name | Type | Constraints | Description
document_management_system_print_category_KEY | int (4) | NOT NULL | The ACS Category that Folder Levels and Folder Values will be assigned to.
folder_level | int (4) | NOT NULL | What nested level in Onvio Documents this row corresponds to. This, in combination with the Print Category, is our tables Primary Key.
folder_value | nvarchar (300) | NOT NULL | The actual value of the folder name for this row.
document_management_system_value_type_KEY | int (4) | NOT NULL | What value type this folder_value corresponds to.
onvio_documents_mapping_date_format_type | nvarchar (40) |  | The date format type for Onvio Documents Folders.

Primary key
Name | Columns | Description
PK_Onvio_Documents_Mapping$document_management_system_print_category_KEY$folder_level | document_management_system_print_category_KEY, folder_level |

Foreign keys
Name | Columns | Referenced table | Description
FK_Onvio_Documents_Mapping__Document_Management_System_Print_Category__document_management_system_print_category_KEY | document_management_system_print_category_KEY | Document_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_KEY | document_management_system_value_type_KEY | Document_Management_System_Value_Type (document_management_system_value_type_KEY) | Must reference appropriate foreign Value Type table.