| 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. |