Tables [dbo].[DocumentLabel]
Label for documents
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_DocumentLabel_OriginatingDocumentID: OriginatingDocumentIDOriginatingDocumentID[dbo].[uniqueid]9NOT NULLOriginatingDocumentId of Document. Link to Document.DocumentID.
Foreign Keys FK_DocumentLabel_DocumentID: [dbo].[Document].DocumentIDDocumentID[dbo].[uniqueid]9NOT NULLVersion specific DocumentId of Document. Link to Document.DocumentID.
Foreign Keys FK_DocumentLabel_DocumentLabelDE: [dbo].[Document_Label_DE].DocumentLabelDEDocumentLabelDE[dbo].[dict_id]5NOT NULLLabel. Link to Document_Label_DE.ID.
Descripvarchar(255)255NOT NULLLabel description entered
LabelledByID[dbo].[uniqueid]9NOT NULLLabeled by user/provider Id
Foreign Keys FK_DocumentLabel_CreatedByID: [dbo].[IDX_User].CreatedByIDCreatedByID[dbo].[uniqueid]9NOT NULLLogged-in UsedID. Link to IDX_User.ID
CreatedDTTMdatetime8NOT NULLLabel created date & time
Foreign Keys FK_DocumentLabel_ModifiedByID: [dbo].[IDX_User].ModifiedByIDModifiedByID[dbo].[uniqueid]9NOT NULLLogged-in UsedID. Link to IDX_User.ID
ModifiedDTTMdatetime8NOT NULLLabel modified date & time