Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| prescripStatusID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| prescripStatusName | varchar | 40 | √ | null |
|
|
Name field - Descriptive name or identifier for prescriptionStatus records |
|
| BillingTypeID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| StatusCode | Unknown | 0 | null |
|
|
Status code - Short code for the prescription status |
||
| StatusDescription | Unknown | 0 | null |
|
|
Status description - Description of the prescription status |
||
| StatusId | Unknown | 0 | null |
|
|
Primary key - prescriptionStatus unique identifier for each status |