...
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| request_number | varchar(255) | 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 | |
| medication_id | uuid | M | |
| medication_qty | numeric | M | |
| status | varchar(255) | M | |
| is_active | boolean | M | |
| rejected_at | date | O | |
| rejected_by | uuid | O | |
| reject_reason | varchar(255) | O | |
| medication_request_requests_id | uuid | M | |
| medical_program_id | uuid | O | |
| inserted_by | uuid | M | |
| updated_by | uuid | M | |
| inserted_at | timestamp | M | |
| updated_at | timestamp | M | |
| verification_code | varchar(255) | O | |
| division_id | uuid | M | |
| legal_entity_id | uuid | M | |
| intent | varchar(25) | M | |
| category | varchar(25) | M | |
| context | jsonb | O | |
| dosage_instructions | jsonb | O |