Tables [dbo].[Note_Template_Version]
v2 Note template definitions
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Note_Template_Version_NoteTypeDE_TemplateVersion: NoteTypeDE\TemplateVersionIndexes STAT_Note_Template_Version_TemplateVersionForeign Keys FK_Note_Template_Version_NoteTypeDE_Note_Type_DE_ID: [dbo].[Note_Type_DE].NoteTypeDENoteTypeDE[dbo].[dict_id]5NOT NULLLink to Note_Type_DE.ID
Cluster Primary Key PK_Note_Template_Version_NoteTypeDE_TemplateVersion: NoteTypeDE\TemplateVersionIndexes STAT_Note_Template_Version_TemplateVersionTemplateVersionsmallint2NOT NULLThe version number of this template.
Descriptionvarchar(50)50NOT NULLTextual description of the template
Check Constraints CK_Note_Template_Version_VersionStatus_Note_Region_Statuses : ([VersionStatus]='Deleted' OR [VersionStatus]='Test' OR [VersionStatus]='Live')VersionStatuschar(8)8NOT NULLStatus of the version:  'Live', 'Deleted', or 'Test'
Foreign Keys FK_Note_Template_Version_WhoDidItID_IDX_User_ID: [dbo].[IDX_User].WhoDidItIDWhoDidItID[dbo].[uniqueid]9NOT NULLLink to IDX_User.ID
CreatedDTTMdatetime8NOT NULLWhen the row was inserted
LastUpdateDTTMdatetime8NOT NULLWhen the row was last modified