Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pr_id | VARCHAR | 11 | '' |
|
|
|||
| pr_selector | VARCHAR | 255 | '' |
|
|
template selector for drugs, empty for codes |
||
| pr_level | VARCHAR | 31 | '' |
|
|
|||
| pr_price | DECIMAL | 12,2 | 0.00 |
|
|
price in local currency |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc/Asc | pr_id + pr_selector + pr_level |