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