prices

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

Relationships

Close relationships within degrees of separation