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: RС_[UPD] Device definition data model_EN | Device definition propertyarchived

parent_id

uuid

O

Reference to parent device definition

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

type

string

Dictionary device_properties

value[X]:

• value_integer

• value_string

• value_boolean

• value_decimal

Depending on the value:

• integer

• string

• boolean

• number

Only one value[x] could be provided