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, unique | M | unique |
| innm_identifier | varchar, unique | M | unique |
| type | varchar (Dictionary: INNM_TYPE) | M | |
| status | varchar (Dictionary: INNM_STATUS) | M | |
| inserted_at | timestamp | M | |
| inserted_by | uuid | M | |
| updated_at | timestamp | M | |
| updated_by | uuid | M |
Ingridients
This entity defines ingridients for brand medications information structure.
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| medication_id | uuid | M | unique (medication_id && innm_id) |
| innm_id | uuid | M | unique (medication_id && innm_id) |
| dosage | Dosage: jsonb | M | |
| is_active_substance | boolean | M | |
| inserted_at | timestamp | M | |
| inserted_by | uuid | M | |
| updated_at | timestamp | M | |
| updated_by | uuid | M |
Medications
This entity defines ingridients for brand medications information structure.
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| name | varchar | M | |
| is_active | boolean | M | |
| start_date | date | M | |
| route | varchar (Dictionary: MEDICATIONS_ROUTE) | M | |
| container_dosage | Dosage: jsonb | M | |
| package_qty | number | M | |
| package_min_qty | number | M | |
| code_ATX | varchar | M | |
| manufacturer_name_country | Manufacturer info: jsonb | M | |
| certificate | varchar | M | |
| expired_certificate_date | date | M | |
| wholesale_price_package | number | M | |
| retail_price_package | number | M | |
| day_recommended_dose | number | M | |
| reimbursement_day_dose | number | M | |
| reimbursement_amount_pack | number | M | |
| surcharge_pack | number | M | |
| inserted_at | timestamp | M | |
| inserted_by | uuid | M | |
| updated_at | timestamp | M | |
| updated_by | uuid | M |
Medication_reimbursement_info
This entity defines additional info (reimbursement financial info) about Medication (brand) & program (программа "Доступні ліки" tm) information structure.
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| medication_id | uuid | M | |
| program_type | |||
| valid_from | |||
| valid_to | |||
| i |
Innm_form_uses
This entity defines cross combinations for innms from medications information structure. Its entity only for fully techical solutions (non business requrements).
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| innm_id | uuid | M | |
| route | varchar (Dictionary: MEDICATIONS_ROUTE) | ||
| dosage | Dosage: jsonb | ||
| container_dosage | Dosage: jsonb | ||
| package_qty | number | ||
| package_min_qty | number | ||
| inserted_at | timestamp | M | |
| inserted_by | uuid | M | |
| updated_at | timestamp | M | |
| updated_by | uuid | M |
Examples
See several examples of the descriptionin medications+ingridients+innms in file: examples medication model
Data structures
Dosage
This entity defines dosage (strength of action) INNM in medication (ingridients).
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_info
This entity defines information about manufacturer of medications.
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| name | varchar | M | |
country | varchar (Dictionary: COUNTRY) | M |