| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
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 | varchar(255) | M | A classification or risk class of the device model Dictionary: |
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: |
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: https://e-health-ua.atlassian.net/wiki/spaces/EH/pages/17782014038#Deviceedit-v2/17575543006#Device-definition-property |
parent_id | uuid | O | Reference to parent device definition |
Device definition names
Table name: device_definition_names
...
Name | Type | M/O | Description and constraints |
|---|---|---|---|
id | uuid | M | Unique identifier in the system |
reimbursement_type | varchar(255) | M | Dictionary: |
reimbursement_percentage_discount | float | O | Applicable only if type |
reimbursement_amount | float | O | Applicable only if type |
is_active | boolean | M | Is record active in the system |
device_definition_id | uuid | M | Device definition identifier |
medical_program_id | uuid | M | Medical program identifier |
wholesale_price | float | O | Wholesale selling price per package |
consumer_price | float | O | Retail price per package |
reimbursement_daily_count | integer | O | The daily count of the device definition to be compensated |
estimated_payment_amount | float | O | The amount of surcharge for packaging |
max_daily_count | integer | O | The maximum allowable daily quantity of the device |
device_request_allowed | boolean | M | Is it allowed to prescribe this device definition |
registry_number | varchar(255) | O | Number (version) of reimbursement configuration |
start_date | date | M | Date of configuration start |
end_date | date | O | Date of configuration end |
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 |
Device definition property
Attribute | Type | Comment |
|---|---|---|
type | string | Dictionary |
value[X]:
| Depending on the value:
| Only one value[x] could be provided |
Add label