Schema

Example

See several examples of the description medications+ingredients+innms on page "DB model (new)" in file: Medications model

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

This entity defines Medications & 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)	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

This entity defines ingredients for brand medications information structure.

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

This entity defines medical programs information structure.

Name	Type	M/O
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

This entity defines cross medications & programs information structure.
Unique constraint `medication_id+medical_program_id`.

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	Reimbursement : jsonb
inserted_at	timestamp	M
inserted_by	uuid	M
updated_at	timestamp	M
updated_by	uuid	M

This entity defines dosage (strength of action) INNM in medication (ingredients).

Name	Type	M/O
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

This entity defines information about manufacturer of medications.

Name	Type	M/O	Description and constraints
manufacturer	varchar	M
country	varchar (Dictionary: COUNTRY)	M

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