...
Name | Type | M/O | Description and constraints |
|---|---|---|---|
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: |
error_reason | varchar(255) | O | Reason for the marked in error equipment status Dictionary: |
availability_status | varchar(255) | M | The availability of the equipment Dictionary: |
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: |
properties | [jsonb] | O | Array of equipment properties |
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 and time of expiry of this equipment (if applicable) |
|
|
|
|
...