id

uuid

M

Unique record identifier

inventory_number

varchar(255)

O

The inventory number for the equipment

serial_number

varchar(255)

O

Serial number assigned by the manufacturer

device_definition_id

uuid

O

Reference to device definition

status

varchar(255)

M

Equipment status

Dictionary: equipment_statuses

error_reason

varchar(255)

O

Reason for the marked in error equipment status

Dictionary: equipment_status_reasons

availability_status

varchar(255)

M

The availability of the equipment

Dictionary: equipment_availability_statuses

manufacturer

varchar(255)

O

Name of equipment manufacturer

manufacture_date

date

O

Date when the equipment was made

model_number

varchar(255)

O

The model number for the equipment

type

varchar(255)

M

Equipment type

Dictionary: device_definition_classification_type

properties

[jsonb]

O

Array of equipment properties

Structure: [NEW] Equipment Data Model | Equipment property

legal_entity_id

uuid

M

Reference to legal entity as equipment owner

division_id

uuid

O

Reference to division

note

varchar(255)

O

Equipment notes and comments

parent_id

uuid

O

Reference to parent device

is_active

boolean

M

Is record active in the system

employee_id

uuid

M

Identifier of the employee who made the entry in the system

inserted_at

timestamp

M

When an entry was added to the system

inserted_by

uuid

M

Identifier of the user who made the entry in the system

updated_at

timestamp

M

When it was updated

updated_by

uuid

M

Identifier of the user who edited the entry in the system

lot_number

varchar(255)

O

Lot number of manufacture

expiration_date

date

O

Date of expiry of this equipment (if applicable)

udi

jsonb

O

Unique device identifier

id

uuid

M

Unique record identifier

equipment_id

uuid

M

Reference to equipment

type

varchar(255)

M

Equipment name type. Dictionary device_name_type

name

varchar(255)

M

Equipment 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