sign

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 uuid_generate_v1()
sign.fk_parent fkey_od_sign N
fk_frame uuid 2147483647 null
frame.id fkey_od_frame R

Foreign key of associated frame
rank int4 10 1

Ranking (automatically filled in in QGIS) depending on the order of signs for each frame
complex bool 1 false

Set true if the sign is too complex for being in the available svg selection. A placeholder sign (“?”) will appear on the map, the real sign can be seen on the photo in the form
fk_sign_type int4 10 null
vl_sign_type.id fkey_vl_sign_type R

Foreign key of sign type value list
fk_official_sign text 2147483647 √ null
vl_official_sign.id fkey_vl_official_sign R

Foreign key of official sign value list
fk_marker_type int2 5 √ null
vl_marker_type.id fkey_vl_marker_type R

Foreign key of marker type value list
fk_mirror_shape int4 10 √ null
vl_mirror_shape.id fkey_vl_mirror_shape R

Foreign key of mirror shape value list
fk_parent uuid 2147483647 √ null
sign.id fkey_od_sign N

Foreign key of associated parent sign
fk_owner uuid 2147483647 √ null
vl_owner.id fkey_od_owner R

Foreign key of owner value list
fk_provider uuid 2147483647 √ null
vl_provider.id fkey_od_provider R

Foreign key of provider value list
fk_durability int4 10 √ null
vl_durability.id fkey_vl_durability R

Foreign key of durability value list
fk_status int4 10 √ null
vl_status.id fkey_vl_status R

Foreign key of status value list
installation_date date 13 √ null
manufacturing_date date 13 √ null
case_id text 2147483647 √ null

Identifier of offical autorisation case
case_decision text 2147483647 √ null

Decision of offical autorisation case
inscription_1 text 2147483647 √ null

Line 1 for dynamic inscriptions
inscription_2 text 2147483647 √ null

Line 2 for dynamic inscriptions
inscription_3 text 2147483647 √ null

Line 3 for dynamic inscriptions
fk_coating int4 10 √ null
vl_coating.id fkey_vl_coating R

Foreign key of coating value list
fk_lighting int4 10 √ null
vl_lighting.id fkey_vl_lighting R

Foreign key of lighting value list
comment text 2147483647 √ null
picture text 2147483647 √ null
mirror_protruding bool 1 √ false

boolean (default is false)
mirror_red_frame bool 1 √ false

boolean (default is false)
dimension_1 numeric 8,3 √ null

If sign is rectangular, height/width; if sign is circular, radius; if sign is elliptic, major/minor radius
dimension_2 numeric 8,3 √ null

If sign is rectangular, height/width; if sign is circular, not needed; if sign is elliptic, major/minor radius
usr_sign_1 text 2147483647 √ null

Field for custom info; use can be specified with alias in QGIS
usr_sign_2 text 2147483647 √ null

Field for custom info; use can be specified with alias in QGIS
usr_sign_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
fk_user_sign uuid 2147483647 √ null
vl_user_sign.id fkey_vl_user_sign R

Foreign key of user sign value list
natural_direction_or_left bool 1 true

Determines the direction for directional signs, with reference to frame.anchor. Default is true
fk_hanging_mode text 2147483647 'recto'::text
vl_hanging_mode.id frame_fk_hanging_mode_key R

Defines whether a panel carries the same signal on both sides; influences the symbology on the map. Default is recto (only front side)
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.

Indexes

Constraint Name Type Sort Column(s)
sign_pkey Primary key Asc id
sign_fk_frame_idx Performance Asc fk_frame
sign_fk_frame_rank_verso_key Must be unique Asc/Asc/Asc fk_frame + rank + fk_hanging_mode

Relationships

Close relationships within degrees of separation