Tables [dbo].[PATIENT_NOTES]
Notes about the patient.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_PATIENT_NOTES: RecIDRecIDint4NOT NULL1 - 1Key to the Patient_Notes table
Indexes IX_PATIENT_NOTES_PATIENTIDPatientIDint4NOT NULLPatient ID
TabRecIDint4NOT NULLWhich tab contains the notes. 10 tabs numbered 0-9
NoteDatatextmaxNULL allowedText User typed in
CreatedByint4NOT NULLUsercode of who added initial text
CreateDatesmalldatetime4NOT NULLDate created
ModifiedByint4NULL allowedUsercode of user who last edited text
ModifyDatesmalldatetime4NULL allowedDate last edited.