Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| idport | int8 | 19 | √ | 0 |
|
|
|||||
| eventincidence | int4 | 10 | √ | null |
|
|
|||||
| transmission | int4 | 10 | √ | null |
|
|
|||||
| parity | int4 | 10 | √ | null |
|
|
|||||
| stopbits | int4 | 10 | √ | null |
|
|
|||||
| numberbits | int4 | 10 | √ | null |
|
|
|||||
| serialport_devicetype | int4 | 10 | null |
|
|
||||||
| updateinterval | int4 | 10 | √ | null |
|
|
|||||
| bus | int4 | 10 | √ | null |
|
|
|||||
| alias_port | int4 | 10 | √ | null |
|
|
|||||
| stream | int4 | 10 | √ | null |
|
|
|||||
| enabled | bool | 1 | √ | null |
|
|
|||||
| lastmodifiedbyuser | int4 | 10 | √ | null |
|
|
|||||
| icon | int4 | 10 | √ | null |
|
|
|||||
| termination_user_0 | int4 | 10 | √ | null |
|
|
|||||
| termination_user_1 | int4 | 10 | √ | null |
|
|
|||||
| idperipheral_template | int4 | 10 | null |
|
|
||||||
| idserial_index | int4 | 10 | √ | null |
|
|
|||||
| idphysical_port | int2 | 5 | √ | null |
|
|
|||||
| idbaud | int2 | 5 | √ | null |
|
|
|||||
| idword_size | int2 | 5 | √ | null |
|
|
|||||
| idparity_type | int2 | 5 | √ | null |
|
|
|||||
| idstop_bits | int2 | 5 | √ | null |
|
|
|||||
| idparity | int2 | 5 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| serialcfg_peripheral_template_pkey | Primary key | Asc | idperipheral_template |

