Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Description |
---|
 | RecID | int | 4 | NOT NULL | 1 - 1 | Key to the Patient_Notes table |
 | PatientID | int | 4 | NOT NULL | | Patient ID |
| TabRecID | int | 4 | NOT NULL | | Which tab contains the notes. 10 tabs numbered 0-9 |
| NoteData | text | max | NULL allowed | | Text User typed in |
| CreatedBy | int | 4 | NOT NULL | | Usercode of who added initial text |
| CreateDate | smalldatetime | 4 | NOT NULL | | Date created |
| ModifiedBy | int | 4 | NULL allowed | | Usercode of user who last edited text |
| ModifyDate | smalldatetime | 4 | NULL allowed | | Date last edited. |