Entities (tables)
Medication requests
This entity defines Medication request (terms) information structure.
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| human_receipt_id | varchar, | M | Must have special proc |
| program_type | varchar (Dictionary: PROGRAM_TYPE) | M | |
| created_at | date | M | |
| started_at | date | M | |
| ended_at | date | M | |
| dispense_valid_from | date | M | |
| dispense_valid_to | date | M | |
| person_id | uuid | ||
| +dispense_valid_from | date| not null | ||
| +dispense_valid_to | date| not null | ||
| +person_id | uuid | not null | ||
| +employee_id | uuid | not null | ||
| +receipt_period_type | varchar | not null | ||
| +receipt_age_type | varchar | not null | ||
| +innm_id | uuid | not null | ||
| +innm_route | varchar | not null | ||
| +innm_dosage | jsonb | not null | ||
| +innm_container_dosage | jsonb | not null | ||
| +innm_qty | number | not null | ||
| +innm_dose_used_qty | number | not null | ||
| +note | jsonb | ||
| +dosage_instuction | jsonb | ||
| +status | varchar | not null | ||
| +is_active | boolean | not null | ||
| +recall_date | date | ||
| +recalled_by | uuid | ||
| +recall_reason | varchar | ||
| +inserted_at | timestamp | not null | ||
| +inserted_by | uuid | not null | ||
| +updated_at | timestamp | not null | ||
| +updated_by | uuid | not null |