Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each custom prescription record, auto-incrementing integer |
|
| fkPrescriptionID | int | 4 | null |
|
|
Prescription reference - Foreign key linking to Prescription.PrescriptionID (required field) |
||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When this custom prescription record was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this custom record |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - When this custom record was most recently updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update |