...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
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 |
...
| employee_id | uuid | ||
| receipt_period_type |
...
| varchar (Dictionary: RECEIPT_PERIOD_TYPE) | |||
| receipt_age_type |
...
| varchar (Dictionary: RECEIPT_AGE_TYPE) | |||
| innm_id |
...
| uuid |
...
...
| innm_route |
...
| varchar (Dictionary: MEDICATIONS_ROUTE_TYPE) | |||
| innm_dosage |
...
| Dosage: jsonb | |||
| innm_container_dosage |
...
| Dosage: jsonb | |||
| innm_qty |
...
| number |
...
...
| innm_dose_used_qty |
...
| number |
...
...
| note |
...
| varchar ??? jsonb |
...
| dosage_instuction |
...
| varchar ??? jsonb |
...
| status | varchar (Dictionary: MEDICATION_REQUEST_STATUS) | ||
| is_active |
...
| boolean |
...
...
| recall_ |
...
| at | date |
...
| recalled_by |
...
| uuid |
...
| recall_reason |
...
| varchar |
...
| inserted_at |
...
| timestamp | M | ||
| inserted_by |
...
| uuid | M | ||
| updated_at |
...
| timestamp | M | ||
| updated_by |
...
| uuid | M |