/
RC_[UPD] Device definition data model

ЕСОЗ - публічна документація

RC_[UPD] Device definition data model

Schema

 

Screenshot 2024-11-09 at 21.47.37.png

 

Resources

Device definition

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

(deprecated*)

varchar(255)

M

A classification or risk class of the device model

Dictionary: device_classification_type

* this field will no longer be available in Admin UI but till the transition to version 2 of Device Definitions will be filled and rendered for the end users

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-definition-property

parent_id

uuid

O

Reference to parent device definition

Device definition classification types

Table name: device_definition_classification_types

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

code

varchar(255)

M

Code from dictionary in system

system

varchar(255)

M

Dictionary 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

Device definition names

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

Data types

There are described data types used in the Resources above

Device definition property

JSON object stored in the properties array field of the device_definitions table

Attribute

Type

Comment

Attribute

Type

Comment

type

object

Represents dictionary and its value that describes a type of the property.

Structure: Property-type

value[X]:

  • value_integer

  • value_string

  • value_boolean

  • value_decimal

  • value_codeable_concept

Depending on the value:

  • integer

  • string

  • boolean

  • number

  • CodeableConcept

Only one value[x] could be provided

Property type

Object stored in the type attribute of the Device definition property

Attribute

Type

Comment

Attribute

Type

Comment

system

string

Dictionary name represent the type of the Device definition property

code

string

Value of the dictionary pointed at the system attribute

Related content

ЕСОЗ - публічна документація