Table of Contents
Schema

Entities (tables)

This entity defines substancesinformation structure.

Name	Type	M/O	Description and constraints
id	uuid	M
name	varchar	M
name_original	varchar	M
SCTID	varchar, unique	M	unique Reference: SCTID - SNOMED IDs
is_active	boolean	M
inserted_at	timestamp	M
inserted_by	uuid	M
updated_at	timestamp	M
updated_by	uuid	M

...

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

...

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

...

Name	Type	M/O	Description and constraints
id	uuid	M
medication_id	uuid	M
medical_program_id	uuid	M
is_active	boolean	M
reimbursement	jsonb	O	Data structure TBD !!!
inserted_at	timestamp	M
inserted_by	uuid	M
updated_at	timestamp	M
updated_by	uuid	M

See several examples of the description medications+ingredients+innms on page "DB model" in file: examples medication model

...

M

Name	Type	M/O	Description and constraints
type	varchar (Dictionary: MEDICATION_TYPE)

id	uuid	M	medications.id OR innms.id
dosage	Dosage: jsonb	M
is_active_substance	boolean	M

...

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