Entities (tables)

Medication Request requests

Name	Type	M/O
id	uuid	M
data	jsonb	M
request_number	varchar(255)	M
status	varchar(255)	M
inserted_by	uuid	M
updated_by	uuid	M
inserted_at	timestamp	M
updated_at	timestamp	M
verification_code	varchar(255)	O
medication_request_id	uuid	M

This entity defines Medication request (terms) information structure.

Name	Type	M/O
id	uuid	M
request_number	varchar(255)	M
created_at	date	M
started_at	date	M
ended_at	date	M
dispense_valid_from	date	M
dispense_valid_to	date	M
person_id	uuid	M
employee_id	uuid	M
medication_id	uuid	M
medication_qty	numeric	M
status	varchar(255)	M
is_active	boolean	M
rejected_at	date	O
rejected_by	uuid	O
reject_reason	varchar(255)	O
medication_request_requests_id	uuid	M
medical_program_id	uuid	O
inserted_by	uuid	M
updated_by	uuid	M
inserted_at	timestamp	M
updated_at	timestamp	M
verification_code	varchar(255)	O
division_id	uuid	M
legal_entity_id	uuid	M
intent	varchar(25)	M
category	varchar(25)	M
context	jsonb	O
dosage_instruction	jsonb	O