Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each prescription custom data record |
|
| fkPrescriptionID | int | 4 | null |
|
|
Prescription reference - Links to Prescription table for the associated prescription or treatment order |
||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - Date and time when this custom prescription record was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator reference - Links to AccessUser table for the user who created this custom prescription record |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update timestamp - Date and time when this custom prescription record was last modified |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updater reference - Links to AccessUser table for the user who last updated this custom prescription record |
Relationships
Close relationships within degrees of separation
