Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | null |
|
|
|||||||||
| facility_id | int8 | 19 | null |
|
|
|||||||||
| name | text | 2147483647 | null |
|
|
|||||||||
| device_type | text | 2147483647 | null |
|
|
|||||||||
| make | text | 2147483647 | null |
|
|
|||||||||
| model | text | 2147483647 | null |
|
|
|||||||||
| protocol | text | 2147483647 | √ | null |
|
|
||||||||
| address | text | 2147483647 | √ | null |
|
|
||||||||
| port | int4 | 10 | √ | null |
|
|
||||||||
| enabled | bool | 1 | true |
|
|
|||||||||
| settings | jsonb | 2147483647 | √ | null |
|
|
||||||||
| parent_id | int8 | 19 | √ | null |
|
|
||||||||
| created_by | int8 | 19 | null |
|
|
|||||||||
| modified_by | int8 | 19 | null |
|
|
|||||||||
| verbosity | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| device_pkey | Primary key | Asc | id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| devices_address_check | ((address !~ similar_to_escape(' *'::text))) |
| devices_protocol_check | ((protocol !~ similar_to_escape(' *'::text))) |