vl_user_sign

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 uuid_generate_v1()
sign.fk_user_sign fkey_vl_user_sign R
active bool 1 √ 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
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)
user_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