Entities (tables)
Medication Request requests
| Name | Type | M/O | Description and constraints |
|---|
| id | uuid | M |
|
| data | jsonb | M |
|
| request_number | varchar(255) | M |
|
| status | varchar(255) | M |
|
| inserted_by | uuid | M |
|
| updated_by | uuid | M |
|
| inserted_at | timestamp | M |
|
| updated_at | timestamp | M |
|
| verification_code | varchar(255) | O |
|
| medication_request_id | uuid | M |
|
Medication Requests
This entity defines Medication request (terms) information structure.
| 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 |
|