| Table of Contents |
|---|
Entities (tables)
Innms
This entity defines INNMs (International Nonpatended Name for Medications) information structure.
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| name | varchar | M | |
| name_original | varchar | M | unique |
| SCTID | varchar, unique | O | Reference: SCTID - SNOMED IDs |
| is_active | boolean | M | |
| inserted_at | timestamp | M | |
| inserted_by | uuid | M | |
| updated_at | timestamp | M | |
| updated_by | uuid | M |
Medications
...
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| name | varchar | M | |
| is_active | boolean | M | |
| type | varchar (Dictionary: MEDICATION_TYPE) | M | INNM_DOSAGE or BRAND |
| form | varchar (Dictionary: MEDICATION_FORM) | M | |
| container | Dosage: jsonb | O | |
| package_qty | number | O | |
| package_min_qty | number | O | |
| code_atc | varchar | O | |
| manufacturer | Manufacturer: jsonb | O | |
| certificate | varchar | O | |
| certificate_expired_at | date | O | |
| inserted_at | timestamp | M | |
| inserted_by | uuid | M | |
| updated_at | timestamp | M | |
| updated_by | uuid | M |
Ingredients
This entity defines ingredients for brand medications information structure.
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | substances.id OR innms.id |
| dosage | Dosage: jsonb | M | |
| is_primary | boolean | M | |
| inserted_at | timestamp | M | |
| inserted_by | uuid | M | |
| updated_at | timestamp | M | |
| updated_by | uuid | M | |
Medical_programs
This entity defines medical programs information structure.
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| is_active | boolean | M | |
| name | varchar | M | |
| inserted_at | timestamp | M | |
| inserted_by | uuid | M | |
| updated_at | timestamp | M | |
| updated_by | uuid | M |
Program_medications
...
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| medication_id | uuid | M | |
| medical_program_id | uuid | M | |
| is_active | boolean | M | |
medication_request_allowed | boolean | M | |
| reimbursement | jsonb | M | Data structure belowReimbursement : jsonb |
| inserted_at | timestamp | M | |
| inserted_by | uuid | M | |
| updated_at | timestamp | M | |
| updated_by | uuid | M |
Examples
See several examples of the description medications+ingredients+innms on page "DB model" in file: examples medication model
Data structures
Ingredients
This entity defines ingredients for brand medications information structure.
...
...
...
...
...
Dosage
This entity defines dosage (strength of action) INNM in medication (ingredients).
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| numerator_unit | varchar (Dictionary: MEDICATION_UNIT) | M | |
| numerator_value | number | M | |
| denumerator_unit | varchar (Dictionary: MEDICATION_UNIT) | M | |
| denumerator_value | number | M |
Examples : 5mg/1tab, 25mg/1ml, 100UE/1ml, 0.1mg/1dose
Manufacturer
This entity defines information about manufacturer of medications.
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| manufacturer | varchar | M | |
| country | varchar (Dictionary: COUNTRY) | M |
Reimbursement
This entity defines reimbursement structure.
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| type | string | M | [fixed, external] |
| reimbursement_amount | number | O | the reimbursement amount for the medication package |
...