Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | uuid_generate_v1() |
|
|
||||||
| address | text | 2147483647 | √ | null |
|
|
|||||
| fk_support_type | int4 | 10 | √ | null |
|
|
Foreign key of support type value list |
||||
| fk_owner | uuid | 2147483647 | √ | null |
|
|
Foreign key of owner value list |
||||
| fk_provider | uuid | 2147483647 | √ | null |
|
|
Foreign key of provider value list |
||||
| fk_support_base_type | int4 | 10 | √ | null |
|
|
Foreign key of support base type value list |
||||
| road_segment | text | 2147483647 | √ | null |
|
|
Optional field to reference a road |
||||
| height | numeric | 8,3 | √ | null |
|
|
Support height |
||||
| height_free_under_signal | numeric | 8,3 | √ | null |
|
|
Free height under signals |
||||
| date_install | date | 13 | √ | null |
|
|
|||||
| date_last_stability_check | date | 13 | √ | null |
|
|
|||||
| fk_status | int4 | 10 | √ | null |
|
|
Foreign key of status value list |
||||
| comment | text | 2147483647 | √ | null |
|
|
|||||
| picture | text | 2147483647 | √ | null |
|
|
|||||
| geometry | geometry | 2147483647 | null |
|
|
||||||
| usr_support_1 | text | 2147483647 | √ | null |
|
|
Field for custom info; use can be specified with alias in QGIS |
||||
| usr_support_2 | text | 2147483647 | √ | null |
|
|
Field for custom info; use can be specified with alias in QGIS |
||||
| usr_support_3 | text | 2147483647 | √ | null |
|
|
Field for custom info; use can be specified with alias in QGIS |
||||
| _creation_date | timestamp | 29,6 | √ | now() |
|
|
Date of creation, automatically filled in within QGIS project |
||||
| _creation_user | text | 2147483647 | √ | null |
|
|
User of creation, automatically filled in within QGIS project |
||||
| _last_modification_date | timestamp | 29,6 | √ | now() |
|
|
Date of last modification, automatically filled in within QGIS project |
||||
| _last_modification_user | text | 2147483647 | √ | null |
|
|
User of last modification, automatically filled in within QGIS project |
||||
| group_by_mounting_point | bool | 1 | true |
|
|
Set true to visually order signals by their anchor point (within each azimut), set false if ranking order should be respected |
|||||
| picture_2 | text | 2147483647 | √ | null |
|
|
|||||
| needs_validation | bool | 1 | false |
|
|
Automatically set to true if the conditions for control are met |
|||||
| _last_modification_platform | text | 2147483647 | √ | null |
|
|
Platform (mobile, desktop) of last modification, automatically filled in within QGIS project. This field is used as a condition in the control view. |
||||
| fk_support_tube_type | int4 | 10 | √ | null |
|
|
Foreign key of tube type value list |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| support_pkey | Primary key | Asc | id |
Relationships
Close relationships within degrees of separation
