| Table of Contents |
|---|
...
See several examples of the description medications+ingredients+innms on page "DB model (new)" in file: Medications model
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 | array | 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
...
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| dosage | Dosage: jsonb | M | |
| is_primary | boolean | M | |
| parent_id | uuid | M | Which ingredients described |
| innm_child_id | uuid | O | Child innm id (for parent with type = INNM_DOSAGE) |
| medication_child_id | uuid | O | Child medication id (for parent with type = BRAND) |
| 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 | |
| type | varchar | M | |
same_mnn_in_treatment_period | boolean | M | default = true |
Program_medications
This entity defines cross medications & programs information structure.
Unique constraint `medication_id+medical_program_id`.
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| program_medication_id | uuid | M | Ідентифікатор ціни ТН в конкретному «Реєстрі лікарських засобів, які підлягають реімбурсації» |
| medication_id | uuid | M | ID торгової назви (ТН) |
| medical_program_id | uuid | M | ID програми |
| is_active | boolean | M | статус Активності |
medication_request_allowed | boolean | M | Допуск рецепту |
| reimbursement | jsonb | M | Reimbursement : jsonb |
| inserted_at | timestamp | M | Ким додано Medical Program (MП) |
| inserted_by | uuid | M | Ким додан |
| updated_at | timestamp | M | Коли оновлено Medications (ТН) |
| updated_by | uuid | M | Ким оновлено Medications (ТН) |
| wholesale_price | number | O | Оптово-відпускна ціна за упаковку |
| consumer_price | number | O | Роздрібна ціна за упаковку |
| reimbursement_daily_dosage | number | O | Розмір відшкодування добової дози лікарського засобу |
| estimated_payment_amount | number | O | Сума доплати за упаковку |
| start_date | date | O | Дата початку дії реєстру |
| end_date | date | O | Дата завершення дії реєстру |
| reqistry_number | varchar | O | Номер реєстру |
Data structures
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 |
...