ЕСОЗ - публічна документація
RC_[UPD] Device definition data model
Schema
Resources
Device definition
Table name: device_definitions
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: |
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: |
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 |
---|---|---|---|
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 |
---|---|---|---|
id | uuid | M | Unique record identifier |
device_definition_id | uuid | M | Reference to device definition |
type | varchar(255) | M | Device name type. Dictionary |
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 |
---|---|---|
type | object | Represents dictionary and its value that describes a type of the property. Structure: Property-type |
value[X]:
| Depending on the value:
| Only one value[x] could be provided |
Property type
Object stored in the type
attribute of the Device definition property
Attribute | Type | Comment |
---|---|---|
system | string | Dictionary name represent the type of the Device definition property |
code | string | Value of the dictionary pointed at the |
Related content
ЕСОЗ - публічна документація