Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
(4) | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Act_Annotation table |
 (3) | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | | | Activity Header Identifier. Link to ID in Activity Header table (Act_Hdr_Result, Act_Hdr_Allergy, etc.) |
| ActivityText | varchar(max) | max | NOT NULL | | | Annotation text |
 | AnnotatedForProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | | Provider annotated for. Link to Provider.ID |
 ![Foreign Keys FK_Act_Annotation_AnnotatedByUserID_IDX_User_ID: [dbo].[IDX_User].AnnotatedByUserID Foreign Keys FK_Act_Annotation_AnnotatedByUserID_IDX_User_ID: [dbo].[IDX_User].AnnotatedByUserID](../../../../Images/fk.png) | AnnotatedByUserID | [dbo].[uniqueid] | 9 | NOT NULL | | | User who entered. Link to IDX_User.ID |
 | PerformedDTTM | datetime | 8 | NOT NULL | | | Performed Date and Time |
(2) | RecordedDTTM | datetime | 8 | NOT NULL | | | Recorded Date and Time |
 (2) | ActivityType | varchar(10) | 10 | NOT NULL | | ('Unknown') | Activity Type (RS, AL, etc.) |