vw_sign_export

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
_azimut_offset_x_rectified int4 10 √ null
_azimut_offset_y_rectified int4 10 √ null
_azimut_rectified int4 10 √ null
_final_rank int8 19 √ null
_group_height int8 19 √ null
_group_width int4 10 √ null
_img_de text 2147483647 √ null
_img_de_right text 2147483647 √ null
_img_direction text 2147483647 √ null
_img_fr text 2147483647 √ null
_img_fr_right text 2147483647 √ null
_img_it text 2147483647 √ null
_img_it_right text 2147483647 √ null
_img_ro text 2147483647 √ null
_img_ro_right text 2147483647 √ null
_inserted_date timestamp 29,6 √ null
_inserted_user text 2147483647 √ null
_last_modified_date timestamp 29,6 √ null
_last_modified_user text 2147483647 √ null
_max_shift_for_azimut int8 19 √ null
_natural_direction_or_left_rectified bool 1 √ null
_next_frame uuid 2147483647 √ null
_next_sign_in_frame uuid 2147483647 √ null
_previous_frame uuid 2147483647 √ null
_previous_sign_in_frame uuid 2147483647 √ null
_rank int8 19 √ null
_symbol_height int4 10 √ null
_symbol_shift int8 19 √ null
_symbol_value_de text 2147483647 √ null
_symbol_value_fr text 2147483647 √ null
_symbol_value_it text 2147483647 √ null
_symbol_value_ro text 2147483647 √ null
_symbol_width int4 10 √ null
_verso bool 1 √ null
azimut int2 5 √ null
case_decision text 2147483647 √ null
case_id text 2147483647 √ null
comment text 2147483647 √ null
complex bool 1 √ null
dimension_1 numeric 8,3 √ null
dimension_2 numeric 8,3 √ null
directional_sign bool 1 √ null
fk_coating int4 10 √ null
fk_durability int4 10 √ null
fk_lighting int4 10 √ null
fk_marker_type text 2147483647 √ null
fk_mirror_shape int4 10 √ null
fk_official_sign text 2147483647 √ null
fk_owner uuid 2147483647 √ null
fk_parent uuid 2147483647 √ null
fk_provider uuid 2147483647 √ null
fk_sign_type int4 10 √ null
fk_status int4 10 √ null
fk_support_base_type int4 10 √ null
fk_support_type int4 10 √ null
fk_user_sign uuid 2147483647 √ null
frame__inserted_date timestamp 29,6 √ null
frame__inserted_user text 2147483647 √ null
frame__last_modified_date timestamp 29,6 √ null
frame__last_modified_user text 2147483647 √ null
frame_anchor "signalo_db"."anchor" 2147483647 √ null
frame_comment text 2147483647 √ null
frame_dimension_1 numeric 8,3 √ null
frame_dimension_2 numeric 8,3 √ null
frame_double_sided bool 1 √ null
frame_fk_azimut uuid 2147483647 √ null
frame_fk_frame_fixing_type int4 10 √ null
frame_fk_frame_type int4 10 √ null
frame_fk_provider uuid 2147483647 √ null
frame_fk_status int4 10 √ null
frame_id uuid 2147483647 √ null
frame_picture text 2147483647 √ null
frame_rank int4 10 √ null
frame_usr_frame_1 text 2147483647 √ null
frame_usr_frame_2 text 2147483647 √ null
frame_usr_frame_3 text 2147483647 √ null
group_by_anchor bool 1 √ null
hanging_mode "signalo_db"."sign_hanging" 2147483647 √ null
id uuid 2147483647 √ null
inscription_1 text 2147483647 √ null
inscription_2 text 2147483647 √ null
inscription_3 text 2147483647 √ null
installation_date date 13 √ null
manufacturing_date date 13 √ null
mirror_protruding bool 1 √ null
mirror_red_frame bool 1 √ null
natural_direction_or_left bool 1 √ null
offset_x int4 10 √ null
offset_x_verso int4 10 √ null
offset_y int4 10 √ null
offset_y_verso int4 10 √ null
picture text 2147483647 √ null
pk text 2147483647 √ null
sign_rank int4 10 √ null
support_geometry geometry 2147483647 √ null
support_id uuid 2147483647 √ null
usr_sign_1 text 2147483647 √ null
usr_sign_2 text 2147483647 √ null
usr_sign_3 text 2147483647 √ null
official_sign_id text 2147483647 √ null
official_sign_active bool 1 √ null
official_sign_default_inscription1 text 2147483647 √ null
official_sign_default_inscription2 text 2147483647 √ null
official_sign_default_inscription3 text 2147483647 √ null
official_sign_default_inscription4 text 2147483647 √ null
official_sign_description_de text 2147483647 √ null
official_sign_description_fr text 2147483647 √ null
official_sign_description_it text 2147483647 √ null
official_sign_description_ro text 2147483647 √ null
official_sign_directional_sign bool 1 √ null
official_sign_img_de text 2147483647 √ null
official_sign_img_de_right text 2147483647 √ null
official_sign_img_fr text 2147483647 √ null
official_sign_img_fr_right text 2147483647 √ null
official_sign_img_height int4 10 √ null
official_sign_img_it text 2147483647 √ null
official_sign_img_it_right text 2147483647 √ null
official_sign_img_ro text 2147483647 √ null
official_sign_img_ro_right text 2147483647 √ null
official_sign_img_width int4 10 √ null
official_sign_no_dynamic_inscription int4 10 √ null
official_sign_value_de text 2147483647 √ null
official_sign_value_fr text 2147483647 √ null
official_sign_value_it text 2147483647 √ null
official_sign_value_ro text 2147483647 √ null
sign_type_id int4 10 √ null
sign_type_active bool 1 √ null
sign_type_description_de text 2147483647 √ null
sign_type_description_fr text 2147483647 √ null
sign_type_value_de text 2147483647 √ null
sign_type_value_fr text 2147483647 √ null
marker_type_id text 2147483647 √ null
marker_type_active bool 1 √ null
marker_type_default_inscription1 text 2147483647 √ null
marker_type_default_inscription2 text 2147483647 √ null
marker_type_default_inscription3 text 2147483647 √ null
marker_type_default_inscription4 text 2147483647 √ null
marker_type_description_de text 2147483647 √ null
marker_type_description_fr text 2147483647 √ null
marker_type_description_it text 2147483647 √ null
marker_type_description_ro text 2147483647 √ null
marker_type_directional_sign bool 1 √ null
marker_type_img_de text 2147483647 √ null
marker_type_img_de_right text 2147483647 √ null
marker_type_img_fr text 2147483647 √ null
marker_type_img_fr_right text 2147483647 √ null
marker_type_img_height int4 10 √ null
marker_type_img_it text 2147483647 √ null
marker_type_img_it_right text 2147483647 √ null
marker_type_img_ro text 2147483647 √ null
marker_type_img_ro_right text 2147483647 √ null
marker_type_img_width int4 10 √ null
marker_type_no_dynamic_inscription int4 10 √ null
marker_type_value_de text 2147483647 √ null
marker_type_value_fr text 2147483647 √ null
marker_type_value_it text 2147483647 √ null
marker_type_value_ro text 2147483647 √ null
mirror_shape_id int4 10 √ null
mirror_shape_active bool 1 √ null
mirror_shape_description_de text 2147483647 √ null
mirror_shape_description_fr text 2147483647 √ null
mirror_shape_value_de text 2147483647 √ null
mirror_shape_value_fr text 2147483647 √ null
durability_id int4 10 √ null
durability_active bool 1 √ null
durability_description_de text 2147483647 √ null
durability_description_fr text 2147483647 √ null
durability_value_de text 2147483647 √ null
durability_value_fr text 2147483647 √ null
coating_id int4 10 √ null
coating_active bool 1 √ null
coating_description_de text 2147483647 √ null
coating_description_fr text 2147483647 √ null
coating_value_de text 2147483647 √ null
coating_value_fr text 2147483647 √ null
lighting_id int4 10 √ null
lighting_active bool 1 √ null
lighting_description_de text 2147483647 √ null
lighting_description_fr text 2147483647 √ null
lighting_value_de text 2147483647 √ null
lighting_value_fr text 2147483647 √ null
support_type_id int4 10 √ null
support_type_active bool 1 √ null
support_type_description_de text 2147483647 √ null
support_type_description_fr text 2147483647 √ null
support_type_value_de text 2147483647 √ null
support_type_value_fr text 2147483647 √ null
support_base_type_id int4 10 √ null
support_base_type_active bool 1 √ null
support_base_type_description_de text 2147483647 √ null
support_base_type_description_fr text 2147483647 √ null
support_base_type_value_de text 2147483647 √ null
support_base_type_value_fr text 2147483647 √ null
owner_id uuid 2147483647 √ null
owner__inserted_date timestamp 29,6 √ null
owner__inserted_user text 2147483647 √ null
owner__last_modified_date timestamp 29,6 √ null
owner__last_modified_user text 2147483647 √ null
owner_active bool 1 √ null
owner_name text 2147483647 √ null
owner_usr_owner_1 text 2147483647 √ null
owner_usr_owner_2 text 2147483647 √ null
owner_usr_owner_3 text 2147483647 √ null
provider_id uuid 2147483647 √ null
provider__inserted_date timestamp 29,6 √ null
provider__inserted_user text 2147483647 √ null
provider__last_modified_date timestamp 29,6 √ null
provider__last_modified_user text 2147483647 √ null
provider_active bool 1 √ null
provider_name text 2147483647 √ null
provider_usr_provider_1 text 2147483647 √ null
provider_usr_provider_2 text 2147483647 √ null
provider_usr_provider_3 text 2147483647 √ null
status_id int4 10 √ null
status_active bool 1 √ null
status_description_de text 2147483647 √ null
status_description_fr text 2147483647 √ null
status_value_de text 2147483647 √ null
status_value_fr text 2147483647 √ null
frame_type_id int4 10 √ null
frame_type_active bool 1 √ null
frame_type_description_de text 2147483647 √ null
frame_type_description_fr text 2147483647 √ null
frame_type_value_de text 2147483647 √ null
frame_type_value_fr text 2147483647 √ null
frame_fixing_type_id int4 10 √ null
frame_fixing_type_active bool 1 √ null
frame_fixing_type_description_de text 2147483647 √ null
frame_fixing_type_description_fr text 2147483647 √ null
frame_fixing_type_value_de text 2147483647 √ null
frame_fixing_type_value_fr text 2147483647 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views