Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | text | 2147483647 | null |
|
|
||||||
| active | bool | 1 | √ | true |
|
|
Set to false if sign should not appear in the selection anymore. Default is true |
||||
| value_de | text | 2147483647 | √ | null |
|
|
|||||
| value_fr | text | 2147483647 | √ | null |
|
|
|||||
| value_it | text | 2147483647 | √ | null |
|
|
|||||
| value_ro | text | 2147483647 | √ | null |
|
|
|||||
| description_de | text | 2147483647 | √ | null |
|
|
|||||
| description_fr | text | 2147483647 | √ | null |
|
|
|||||
| description_it | text | 2147483647 | √ | null |
|
|
|||||
| description_ro | text | 2147483647 | √ | null |
|
|
|||||
| img_de | text | 2147483647 | √ | null |
|
|
Path to svg (if directional, this is the left direction). Idem for img_fr, img_it, img_ro |
||||
| img_fr | text | 2147483647 | √ | null |
|
|
|||||
| img_it | text | 2147483647 | √ | null |
|
|
|||||
| img_ro | text | 2147483647 | √ | null |
|
|
|||||
| img_height | int4 | 10 | √ | 100 |
|
|
Height of the svg. If 0, it will not appear on the map. Ratio width-height has to be respected |
||||
| img_width | int4 | 10 | √ | 100 |
|
|
Width of the svg. If 0, it will not appear on the map. Ratio width-height has to be respected |
||||
| no_dynamic_inscription | int4 | 10 | √ | 0 |
|
|
Number of dynamic inscriptions. Default is 0 |
||||
| default_inscription1 | text | 2147483647 | √ | null |
|
|
|||||
| default_inscription2 | text | 2147483647 | √ | null |
|
|
|||||
| default_inscription3 | text | 2147483647 | √ | null |
|
|
|||||
| default_inscription4 | text | 2147483647 | √ | null |
|
|
|||||
| directional_sign | bool | 1 | false |
|
|
Boolean if sign is directional. Default is false |
|||||
| img_de_right | text | 2147483647 | √ | null |
|
|
Path to svg (if directional, this is the right direction). Idem for img_fr_right, img_it_right, img_ro_right |
||||
| img_fr_right | text | 2147483647 | √ | null |
|
|
|||||
| img_it_right | text | 2147483647 | √ | null |
|
|
|||||
| img_ro_right | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| official_sign_pkey | Primary key | Asc | id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| directional | (((directional_sign IS FALSE) OR ((img_de_right IS NOT NULL) AND (img_fr_right IS NOT NULL) AND (img_it_right IS NOT NULL) AND (img_ro_right IS NOT NULL)))) |
Relationships
Close relationships within degrees of separation
