Vaistinių preparatų informacinė sistema VAPRIS (valdytojas Valstybinė vaistų kontrolės tarnyba prie Lietuvos Respublikos sveikatos apsaugos ministerijos)

Valstybinės vaistų kontrolės tarnybos prie Lietuvos Respublikos sveikatos apsaugos ministerijos vaistinių preparatų informacinės sistemos VAPRIS duomenų struktūros
Vaistinio preparato pakuotės duomenys: PAKID, NPAKID
table	field	is_primary	is_unique	type
vpreg_package	compensation_cost			numeric
	concentration			character varying
	created_on			timestamp without time zone
	description			character varying
	dose_count			integer
	fhir_id			character varying
	fhir_status			character varying
	fhir_update_time			timestamp without time zone
	last_update			timestamp without time zone
	migration_date			character varying
	notes			character varying
	npakid			bigint
	old_id			integer
	package_purpose_id			bigint
	pakid	1	1	bigint
	prescription_mark_id			bigint
	primary_quantity			character varying
	quantity_measurement_unit_id			bigint
	registration_number			character varying
	retail_price			numeric
	secondary_quantity			character varying
	state_id			bigint
	type_id			bigint
	valid			boolean
	vid			bigint

Vaistinio preparato duomenys
table	field	is_primary	is_unique	type
vpreg_medication	active_substances_text			character varying
	application_type_id			bigint
	controlled_type_id			bigint
	created_on			timestamp without time zone
	current_state_id			bigint
	distribution_base_id			bigint
	fhir_id			character varying
	fhir_status			character varying
	fhir_update_time			timestamp without time zone
	full_name			character varying
	gmo			boolean
	indications			character varying
	indications_details			character varying
	is_public			boolean
	last_update			timestamp without time zone
	medication_group_id			bigint
	medication_subgroup_id			bigint
	migration_date			character varying
	name			character varying
	notes			character varying
	observed			boolean
	old_id			integer
	pharmaceutical_form_text			character varying
	pip			boolean
	prescription_mark_id			bigint
	procedure_number			character varying
	puma			boolean
	rtt_company_id			bigint
	rtt_number			character varying
	rtt_representative_id			bigint
	rtt_short_number			character varying
	rtt_valid_to_date			date
	strength_text			character varying
	up_to_date			boolean
	valid			boolean
	vid	1	1	bigint

Vaistinio preparato anatominė-terapinė-cheminė klasifikacija – ATC
table	field	is_primary	is_unique	type
vpreg_medication_atc_classification	atc_code_id			bigint
	id	1	1	bigint
	migration_date			character varying
	vid			bigint

Vaistinio preparato statusas sistemoje
table	field	is_primary	is_unique	type
vpreg_medication_state	created_on			timestamp without time zone
	hide_state_date			boolean
	id	1	1	bigint
	last_process_id			character varying
	last_update			timestamp without time zone
	state_comment			character varying
	state_date			date
	state_id			bigint
	state_reason_id			bigint
	vid			bigint

1. n/a
table	field	is_primary	is_unique	type
vpreg_classifier	approved			boolean
	code			character varying
	group			character varying
	id	1	1	bigint
	is_public			boolean
	migration_date			character varying
	old_id			integer
	position			integer
	related_group			character varying
	valid_from			date
	valid_to			date

2. n/a
table	field	is_primary	is_unique	type
vpreg_translation	classifier_id			bigint
	id	1	1	bigint
	lang			character varying
	migration_date			character varying
	text			character varying
	text_short			character varying

Vaistinį preparatą sudarantys komponentai
table	field	is_primary	is_unique	type
vpreg_component	created_on			timestamp without time zone
	fhir_id			character varying
	fhir_status			character varying
	fhir_update_time			timestamp without time zone
	id	1	1	bigint
	last_update			timestamp without time zone
	measurement_unit_id			bigint
	migration_date			character varying
	name			character varying
	notes			character varying
	old_id			integer
	pharmaceutical_form_id			bigint
	quantity			numeric
	sequence_number			smallint
	vid			bigint
	volume_description			character varying

Vaistinio preparato medžiaga
table	field	is_primary	is_unique	type
vpreg_substance	active			boolean
	auxiliary			boolean
	controlled_substance_type_id			bigint
	created_on			timestamp without time zone
	fhir_id			character varying
	fhir_status			character varying
	fhir_update_time			timestamp without time zone
	id	1	1	bigint
	is_public			boolean
	last_update			timestamp without time zone
	migration_date			character varying
	name_en			character varying
	name_la			character varying
	name_lt			character varying
	old_id			integer
	old_pure_id			integer
	pure_controlled_substance_id			bigint
	purity			numeric
	reagent			boolean
	substance_source_id			bigint
	valid_from			date
	valid_to			date

Vaistinio preparato nustatyta paros dozė (DDD)
table	field	is_primary	is_unique	type
vpreg_ddd	administration_route_id			bigint
	atc_code_id			bigint
	id	1	1	bigint
	measurement_unit_id			bigint
	notes			character varying
	quantity			numeric
	valid			boolean

Vaistinio preparato registruotojo duomenys
table	field	is_primary	is_unique	type
vpreg_company	id	1	1	bigint
	country_id			bigint
	name			character varying

Lentelė	Lentelės aprašymas	Stulpelis	Stulpelio aprašymas
vpreg_ingredient	Vaistinio preparato sudėtinės medžiagos ir kiekiai	id	Unikalus lentelės eilutės identifikacinis numeris
		component_id	Vaistinio preparato komponento identifikacinis numeris skirtas sudaryti ryšiui su vpreg_component lentele
		sequence_number
		substance_id	Vaistinio preparato medžiagos identifikacinis numeris skirtas sudaryti ryšiui su vpreg_substance lentele
		strength	Vaistinio preparato medžiagos stiprumas tekstiniu formatu
		strength_numeric	Vaistinio preparato medžiagos stiprumas skaitiniu formatu
		measurement_unit_id	Vaistinio preparato medžiagos stiprumo matavimo vieneto identifikacinis numeris skirtas sudaryti ryšiui su vpreg_translation lentele
		strength_operator_id	Vaistinio preparato medžiagos stiprumo operatorius, nurodantis medžiagos kiekį (daugiau, mažiau ar lygu), identifikacinis numeris skirtas sudaryti ryšiui su vpreg_translation lentele
		substance_type_id	Vaistinio preparato medžiagos tipo (veiklioji, pagalbinė, reagentas) identifikacinis numeris skirtas sudaryti ryšiui su vpreg_translation lentele
		old_id	Senas lentelės eilutės identifikacinis numeris
		strength_numeric_till
		measurement_unit_till_id
		migration_date	Eilutės redagavimo data
		alt_substance_id
		alt_strength_operator_id
		alt_strength_numeric
		alt_measurement_unit_id
		alt_strength_numeric_till
		alt_measurement_unit_till_id
		tmp_seq_no

Lentelės pavadinimas	Lentelės aprašymas	Stulpelio pavadinimas	is_primary	is_unique	type
vpreg_classifier	Visi sistemos klasifikatoriai	approved			boolean
		code			character varying
		group			character varying
		id	1	1	bigint
		is_public			boolean
		migration_date			character varying
		old_id			integer
		position			integer
		related_group			character varying
		valid_from			date
		valid_to			date
vpreg_company	Vaistinio preparato registruotojo duomenys	address			character varying
		country_id			bigint
		email			character varying
		fax			character varying
		id	1	1	bigint
		migration_date			character varying
		name			character varying
		old_id			bigint
		phone			character varying
		valid			boolean
vpreg_medication	Vaistinio preparato duomenys	active_substances_text			character varying
		application_type_id			bigint
		controlled_type_id			bigint
		created_on			timestamp without time zone
		current_state_id			bigint
		distribution_base_id			bigint
		fhir_id			character varying
		fhir_status			character varying
		fhir_update_time			timestamp without time zone
		full_name			character varying
		gmo			boolean
		indications			character varying
		indications_details			character varying
		is_public			boolean
		last_update			timestamp without time zone
		medication_group_id			bigint
		medication_subgroup_id			bigint
		migration_date			character varying
		name			character varying
		notes			character varying
		observed			boolean
		old_id			integer
		pharmaceutical_form_text			character varying
		pip			boolean
		prescription_mark_id			bigint
		procedure_number			character varying
		puma			boolean
		rtt_company_id			bigint
		rtt_number			character varying
		rtt_representative_id			bigint
		rtt_short_number			character varying
		rtt_valid_to_date			date
		strength_text			character varying
		up_to_date			boolean
		valid			boolean
		vid	1	1	bigint
vpreg_medication_atc_classification	Vaistinio preparato anatominė-terapinė-cheminė klasifikacija – ATC	atc_code_id			bigint
		id	1	1	bigint
		migration_date			character varying
		vid			bigint
vpreg_medication_state	Vaistinio preparato statusas sistemoje	created_on			timestamp without time zone
		hide_state_date			boolean
		id	1	1	bigint
		last_process_id			character varying
		last_update			timestamp without time zone
		state_comment			character varying
		state_date			date
		state_id			bigint
		state_reason_id			bigint
		vid			bigint
vpreg_package	Vaistinio preparato pakuotės duomenys: PAKID, NPAKID, aprašymas, dydis, kompensuojama kaina	compensation_cost			numeric
		concentration			character varying
		created_on			timestamp without time zone
		description			character varying
		dose_count			integer
		fhir_id			character varying
		fhir_status			character varying
		fhir_update_time			timestamp without time zone
		last_update			timestamp without time zone
		migration_date			character varying
		notes			character varying
		npakid			bigint
		old_id			integer
		package_purpose_id			bigint
		pakid	1	1	bigint
		prescription_mark_id			bigint
		primary_quantity			character varying
		quantity_measurement_unit_id			bigint
		registration_number			character varying
		retail_price			numeric
		secondary_quantity			character varying
		state_id			bigint
		type_id			bigint
		valid			boolean
		vid			bigint
vpreg_translation	Klasifikatorių reikšmių vertimai kita kalba	classifier_id			bigint
		id	1	1	bigint
		lang			character varying
		migration_date			character varying
		text			character varying
		text_short			character varying
vpreg_medication_adminstration_route	Vaistinio preparato duomenys: vartojimo būdas	administration_route_id	1	1	bigint
		migration_date			character varying
		vid	1	1	bigint
vpreg_component	Vaistinį preparatą sudarantys komponentai	created_on			timestamp without time zone
		fhir_id			character varying
		fhir_status			character varying
		fhir_update_time			timestamp without time zone
		id	1	1	bigint
		last_update			timestamp without time zone
		measurement_unit_id			bigint
		migration_date			character varying
		name			character varying
		notes			character varying
		old_id			integer
		pharmaceutical_form_id			bigint
		quantity			numeric
		sequence_number			smallint
		vid			bigint
		volume_description			character varying
vpreg_substance	Vaistinio preparato medžiaga	active			boolean
		auxiliary			boolean
		controlled_substance_type_id			bigint
		created_on			timestamp without time zone
		fhir_id			character varying
		fhir_status			character varying
		fhir_update_time			timestamp without time zone
		id	1	1	bigint
		is_public			boolean
		last_update			timestamp without time zone
		migration_date			character varying
		name_en			character varying
		name_la			character varying
		name_lt			character varying
		old_id			integer
		old_pure_id			integer
		pure_controlled_substance_id			bigint
		purity			numeric
		reagent			boolean
		substance_source_id			bigint
		valid_from			date
		valid_to			date
vpreg_ddd	Vaistinio preparato nustatyta paros dozė (DDD)	administration_route_id			bigint
		atc_code_id			bigint
		id	1	1	bigint
		measurement_unit_id			bigint
		notes			character varying
		quantity			numeric
		valid			boolean