Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
 | OriginatingDocumentID | [dbo].[uniqueid] | 9 | NOT NULL | OriginatingDocumentId of Document. Link to Document.DocumentID. |
![Foreign Keys FK_DocumentLabel_DocumentID: [dbo].[Document].DocumentID Foreign Keys FK_DocumentLabel_DocumentID: [dbo].[Document].DocumentID](../../../../Images/fk.png) | DocumentID | [dbo].[uniqueid] | 9 | NOT NULL | Version specific DocumentId of Document. Link to Document.DocumentID. |
![Foreign Keys FK_DocumentLabel_DocumentLabelDE: [dbo].[Document_Label_DE].DocumentLabelDE Foreign Keys FK_DocumentLabel_DocumentLabelDE: [dbo].[Document_Label_DE].DocumentLabelDE](../../../../Images/fk.png) | DocumentLabelDE | [dbo].[dict_id] | 5 | NOT NULL | Label. Link to Document_Label_DE.ID. |
| Descrip | varchar(255) | 255 | NOT NULL | Label description entered |
| LabelledByID | [dbo].[uniqueid] | 9 | NOT NULL | Labeled by user/provider Id |
![Foreign Keys FK_DocumentLabel_CreatedByID: [dbo].[IDX_User].CreatedByID Foreign Keys FK_DocumentLabel_CreatedByID: [dbo].[IDX_User].CreatedByID](../../../../Images/fk.png) | CreatedByID | [dbo].[uniqueid] | 9 | NOT NULL | Logged-in UsedID. Link to IDX_User.ID |
| CreatedDTTM | datetime | 8 | NOT NULL | Label created date & time |
![Foreign Keys FK_DocumentLabel_ModifiedByID: [dbo].[IDX_User].ModifiedByID Foreign Keys FK_DocumentLabel_ModifiedByID: [dbo].[IDX_User].ModifiedByID](../../../../Images/fk.png) | ModifiedByID | [dbo].[uniqueid] | 9 | NOT NULL | Logged-in UsedID. Link to IDX_User.ID |
| ModifiedDTTM | datetime | 8 | NOT NULL | Label modified date & time |