Medication Data Model

Schema

Table name: innms

Name	Type	Description and constraints

Name	Type	Description and constraints
id	uuid	Identifier in the system
sctid	varchar(255)	Identifier of the INN of the medicinal product according to SNOMED
name	varchar(255)	Name
name_original	varchar(255)	Original title
is_active	bool	Active in the system
inserted_by	uuid	Identifier of the person who made the entry in the system
updated_by	uuid	Identifier of the person who edited the entry in the system
inserted_at	timestamp	When an entry was made to the system
updated_at	timestamp	When it was updated

Table name: prm.ingredients

Name	Type	Description and constraints	Dosage of INNM in INNM_DOSAGE	Dosage of INNM_DOSAGE in BRAND

Name	Type	Description and constraints
id	uuid	Identifier in the system
dosage	jsonb	Dosage
is_primary	bool	The main ingredient
medication_child_id	uuid	INNM_DOSAGE is a part of BRAND
innm_child_id	uuid	INNM is a part of INNM_DOSAGE
parent_id	uuid	BRAND ID or INNM_DOSAGE ID, which located in medications table.
inserted_at	timestamp	When an entry was made to the system
updated_at	timestamp	When it was updated

Table name: prm.medications

Name	Type	Description and constraints	INNM_DOSAGE	BRAND

Name	Type	Description and constraints
id	uuid	Identifier in the system
name	varchar(255)	The name of the BRAND of INNM_DOSAGE
type	varchar(255)	Type of the record: BRAND or INNM_DOSAGE
manufacturer	jsonb	Manufacturer's data set: Name Country
code_atc	jsonb	ATX code
is_active	bool	Active in the system
form	varchar(255)	Release form
container	jsonb	Information about primary package of the Brand
package_qty	int4	Quantity in the package
package_min_qty	int4	Minimum quantity available for sale
certificate	varchar(255)	Certificate
certificate_expired_at	date	Expiration date of the certificate
inserted_by	uuid	Identifier of the person who made the entry in the system
updated_by	uuid	Identifier of the person who edited the entry in the system
inserted_at	timestamp	When an entry was made to the system
updated_at	timestamp	When it was updated
daily_dosage	float8	Daily dose of the drug
max_daily_dosage	float8	The maximum allowable daily dose of the drug
max_request_dosage	int2	The maximum dose of the drug within one prescription
mr_blank_type	varchar(64)	Type of prescription form. F-1 or F-3.
dosage_form_is_dosed	bool	Indication of dosage of the dosage form
form_pharm	varchar(255)	Pharmaceutical form
drlz_sku_id	varchar(255)	identifier of a product out of external DRLZ register

Table name: prm.medical_programs

Name	Type	Description and constraints

Name	Type	Description and constraints
id	uuid	Identifier in the system
name	varchar(255)	Name of the medical program
is_active	bool	Active in the system
inserted_by	uuid	Identifier of the person who made the entry in the system
updated_by	uuid	Identifier of the person who edited the entry in the system
inserted_at	timestamp	When an entry was made to the system
updated_at	timestamp	When it was edited
type	text	Type of medical program. Fetches from a dictionary MEDICAL_PROGRAM_TYPE
medication_request_allowed	bool	It is allowed to issue a Medication request
medication_dispense_allowed	bool	Dispense of Medication request is allowed
medication_request_allowed_text	text	Comment for Medication request option
medication_dispense_allowed_text	text	Comment for Medication dispense option
medical_program_settings	jsonb	List of medical program settings
medical_program_settings_text	text	Comment on the settings of the medical program
funding_source	varchar(255)	Source of funding. Fetches from a dictionary FUNDING_SOURCE
mr_blank_type	varchar(64)	The type of prescription blank (F-1 or F-3) which is mandatory for INNM_DOSAGE of a BRAND to be a participant in Medical Program. Fetches from a dictionary MR_BLANK_TYPES.

Table name: program_medications

Name	Type	Description and constraints

Name	Type	Description and constraints
id	uuid	Identifier in the system
reimbursement	jsonb	Setting up compensation for a program participant Type of reimbursement (Fetches from a dictionary REIMBURSEMENT_TYPE) Amount of compensation
is_active	bool	Active in the system
medication_request_allowed	bool	Available for prescription
inserted_by	uuid	Identifier of the person who made the entry in the system
updated_by	uuid	Identifier of the person who edited the entry in the system
medication_id	uuid	BRAND identifier
medical_program_id	uuid	Medical program identifier
inserted_at	timestamp	When an entry was made to the system
updated_at	timestamp	When it was updated
wholesale_price	float8	Wholesale selling price per package
consumer_price	float8	Retail price per package
reimbursement_daily_dosage	float8	The daily dose of the drug to be compensated
estimated_payment_amount	float8	The amount of surcharge for packaging
start_date	date	Date of entry into force of the register
end_date	date	Registry expiration date
registry_number	varchar(255)	Registration number
max_daily_dosage	float8	The maximum allowable daily dose of the medication