PAT_STICKY_INFO

Description: |
The PAT_STICKY_INFO table contains information of patient's sticky note, including user ID whom the sticky note belongs to and note ID which the sticky note is stored in.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | STICKY_USER_ID | VARCHAR | No |
User ID whom the sticky note belongs to.
4 | STICKY_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | STICKY_NOTE_ID | VARCHAR | No |
Note ID which the sticky note is stored in.