| Table of Contents |
|---|
Entities (tables)
...
Innms
This entity defines substancesinformation 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 | M | uniqueO | 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
This entity defines Medications & INNMs(International Nonpatended Name for Medications) information INNM dosage information structure.
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) | Mingredients | ||||
| Ingredients[]: jsonb | O | Array | container | Dosage: jsonb | O | |
| package_qty | number | O | ||||
| package_min_qty | number | O | ||||
| code_ATXatc | varchar | O | ||||
| manufacturer | Manufacturer: jsonb | O | ||||
| certificate | varchar | O | ||||
| certificate_expired_certificate_dateat | date | O | ||||
| inserted_at | timestamp | M | ||||
| inserted_by | uuid | M | ||||
| updated_at | timestamp | M | ||||
| updated_by | uuid | M |
Medical_programs
...
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 below |
| inserted_at | timestamp | M | |
| inserted_by | uuid | M | |
| updated_at | timestamp | M | |
| updated_by | uuid | M |
Reimbursement
This entity defines reimbursement structure.
Name | Type | M/O | Description and constraints | |||||
|---|---|---|---|---|---|---|---|---|
| type | stringM | [fixed, external] | reimbursement_amount | number | Othe reimbursement amount for the medication package |
Examples
See several examples of the description medications+ingredients+innms on page "DB model" in file: examples medication model
...
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | substances.id OR innms.id |
| dosage | Dosage: jsonb | M | |
| is_active_substance | boolean | M |
...
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 |