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