| Table of Contents |
|---|
...
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| name | varchar | M | |
| SCTID | varchar, unique | M | unique |
| 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 | |
| form | varchar (Dictionary: MEDICATION_FORM) | M | |
| ingredients | Ingredients[]: jsonb | O | Array |
| container | Dosage: jsonb | O | |
| package_qty | number | O | |
| package_min_qty | number | O | |
| code_ATX | varchar | O | |
| manufacturer | Manufacturer: jsonb | O | |
| certificate | varchar | O | |
| expired_certificate_date | 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 | valid_from | date | M | valid_to | date | M |
Medication_program_info (TBD !!!!)
...
Program_medications
This entity defines cross medications & programs information structure.
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| medication_id | uuid | M | |
| medical_program_type varchar (Dictionary: MEDICAL_PROGRAM)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 | |
| valid_from | date | M | |
| valid_to | date | M |
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 |
|---|---|---|---|
| type | varchar (Dictionary: MEDICATION_TYPE) | M | |
| id | uuid | M | medications.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 |