Schema

Resources

Table name: device_definitions

Name	Type	M/O	Description and constraints

Name	Type	M/O	Description and constraints
id	uuid	M	Unique identifier in the system
external_id	varchar(255)	O	Device identifier in external system
classification_type	varchar(255)	M	A classification or risk class of the device model Dictionary: `device_definition_classification_type`
description	varchar(2000)	O	Description of the device
manufacturer_name	varchar(255)	M	Name of device manufacturer
manufacturer_country	varchar(255)	M	Country of manufacture. Dictionary: `COUNTRY`
model_number	varchar(255)	M	The catalog or model number for the device for example as defined by the manufacturer
part_number	varchar(255)	O	The part number or catalog number of the device
packaging_type	varchar(255)	M	A code that defines the specific type of packaging Dictionary: `device_definition_packaging_type`
packaging_count	int	M	The number of items contained in the package
packaging_unit	varchar(255)	M	Dictionary: `device_unit`
note	varchar(2000)	O	Device notes and comments
is_active	boolean	M	Is record active in the system
inserted_at	timestamp	M	When an entry was added to the system
updated_at	timestamp	M	When it was updated
inserted_by	uuid	M	Identifier of the user who made the entry in the system
updated_by	uuid	M	Identifier of the user who edited the entry in the system
properties	jsonb	O	Array of device properties Structure: Device Data Model \| Device definition property
parent_id	uuid	O	Reference to parent device definition

Table name: device_definition_names

Name	Type	M/O	Description and constraints

Name	Type	M/O	Description and constraints
id	uuid	M	Unique record identifier
device_definition_id	uuid	M	Reference to device definition
type	varchar(255)	M	Device name type. Dictionary `device_name_type`
name	varchar(255)	M	Device name
inserted_at	timestamp	M	When an entry was added to the system
updated_at	timestamp	M	When it was updated
inserted_by	uuid	M	Identifier of the user who created the entry in the system
updated_by	uuid	M	Identifier of the user who edited the entry in the system

Table name: program_devices

Name	Type	M/O	Description and constraints

Name	Type	M/O	Description and constraints
id	uuid	M	Unique identifier in the system
reimbursement_type	varchar(255)	M	Dictionary: `REIMBURSEMENT_TYPE`
reimbursement_percentage_discount	float	O	Applicable only if type `PERCENTAGE`
reimbursement_amount	float	O	Applicable only if type `FIXED`
is_active	boolean	M	Is record active in the system
device_definition_id	uuid	M	Device definition identifier
medical_program_id	uuid	M	Medical program identifier
wholesale_price	float	O	Wholesale selling price per package
consumer_price	float	O	Retail price per package
reimbursement_daily_count	integer	O	The daily count of the device definition to be compensated
estimated_payment_amount	float	O	The amount of surcharge for packaging
max_daily_count	integer	O	The maximum allowable daily quantity of the device
device_request_allowed	boolean	M	Is it allowed to prescribe this device definition
registry_number	varchar(255)	O	Number (version) of reimbursement configuration
start_date	date	M	Date of configuration start
end_date	date	O	Date of configuration end
inserted_at	timestamp	M	When an entry was added to the system
updated_at	timestamp	M	When it was updated
inserted_by	uuid	M	Identifier of the user who made the entry in the system
updated_by	uuid	M	Identifier of the user who edited the entry in the system

Attribute	Type	Comment

Attribute

Type

Comment

type

string

Dictionary device_properties

value[X]:

Depending on the value:

Only one value[x] could be provided

Add label