vw_export_reach

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
_slope_per_mill numeric 0 null
ch_bedding_encasement int4 10 null
ch_connection_type int4 10 null
ch_function_amelioration int4 10 null
ch_function_hierarchic int4 10 null
ch_function_hydraulic int4 10 null
ch_jetting_interval numeric 4,2 null
ch_pipe_length numeric 7,2 null
ch_seepage int4 10 null
ch_usage_current int4 10 null
ch_usage_planned int4 10 null
clear_height int4 10 null
coefficient_of_friction int2 5 null
elevation_determination int4 10 null
fk_dataowner varchar 16 null
fk_pipe_profile varchar 16 null
fk_provider varchar 16 null
flow_time_dry_weather numeric 7 null
horizontal_positioning int4 10 null
hydraulic_load_current int2 5 null
identifier text 2147483647 null
inside_coating int4 10 null
last_modification timestamp 29,6 null
leak_protection int4 10 null
length_effective numeric 7,2 null
material int4 10 null
obj_id varchar 16 null
progression3d_geometry geometry 2147483647 null
reliner_material int4 10 null
reliner_nominal_size int4 10 null
relining_construction int4 10 null
relining_kind int4 10 null
remark text 2147483647 null
ring_stiffness int2 5 null
rp_from_elevation_accuracy int4 10 null
rp_from_fk_dataowner varchar 16 null
rp_from_fk_provider varchar 16 null
rp_from_fk_wastewater_networkelement varchar 16 null
rp_from_identifier text 2147483647 null
rp_from_last_modification timestamp 29,6 null
rp_from_level numeric 7,3 null
rp_from_obj_id varchar 16 null
rp_from_outlet_shape int4 10 null
rp_from_pipe_closure int4 10 null
rp_from_position_of_connection int2 5 null
rp_from_remark text 2147483647 null
rp_to_elevation_accuracy int4 10 null
rp_to_fk_dataowner varchar 16 null
rp_to_fk_provider varchar 16 null
rp_to_fk_wastewater_networkelement varchar 16 null
rp_to_identifier text 2147483647 null
rp_to_last_modification timestamp 29,6 null
rp_to_level numeric 7,3 null
rp_to_obj_id varchar 16 null
rp_to_outlet_shape int4 10 null
rp_to_pipe_closure int4 10 null
rp_to_position_of_connection int2 5 null
rp_to_remark text 2147483647 null
slope_building_plan int2 5 null
swmm_default_coefficient_of_friction int2 5 null
wall_roughness numeric 5,2 null
width int4 10 null
ws__bottom_label text 2147483647 null
ws__cover_label text 2147483647 null
ws__input_label text 2147483647 null
ws__output_label text 2147483647 null
ws_accessibility int4 10 null
ws_condition_score numeric 3,2 null
ws_contract_section text 2147483647 null
ws_elevation_determination int4 10 null
ws_financing int4 10 null
ws_fk_main_wastewater_node varchar 16 null
ws_fk_operator varchar 16 null
ws_fk_owner varchar 16 null
ws_gross_costs numeric 10,2 null
ws_identifier text 2147483647 null
ws_inspection_interval numeric 4,2 null
ws_last_modification timestamp 29,6 null
ws_location_name text 2147483647 null
ws_obj_id varchar 16 null
ws_records text 2147483647 null
ws_remark text 2147483647 null
ws_renovation_necessity int4 10 null
ws_replacement_value numeric 10,2 null
ws_rv_base_year int2 5 null
ws_rv_construction_type int4 10 null
ws_status int4 10 null
ws_status_survey_year int2 5 null
ws_structure_condition int4 10 null
ws_subsidies numeric 10,2 null
ws_urgency_figure int2 5 null
ws_year_of_construction int2 5 null
ws_year_of_replacement int2 5 null
elevation_determination_code int4 10 null
elevation_determination_abbr_de varchar 3 null
elevation_determination_abbr_en varchar 3 null
elevation_determination_abbr_fr varchar 3 null
elevation_determination_abbr_it varchar 3 null
elevation_determination_abbr_ro varchar 3 null
elevation_determination_active bool 1 null
elevation_determination_value_de varchar 100 null
elevation_determination_value_en varchar 100 null
elevation_determination_value_fr varchar 100 null
elevation_determination_value_it varchar 100 null
elevation_determination_value_ro varchar 100 null
elevation_determination_vsacode int4 10 null
horizontal_positioning_code int4 10 null
horizontal_positioning_abbr_de varchar 3 null
horizontal_positioning_abbr_en varchar 3 null
horizontal_positioning_abbr_fr varchar 3 null
horizontal_positioning_abbr_it varchar 3 null
horizontal_positioning_abbr_ro varchar 3 null
horizontal_positioning_active bool 1 null
horizontal_positioning_value_de varchar 100 null
horizontal_positioning_value_en varchar 100 null
horizontal_positioning_value_fr varchar 100 null
horizontal_positioning_value_it varchar 100 null
horizontal_positioning_value_ro varchar 100 null
horizontal_positioning_vsacode int4 10 null
inside_coating_code int4 10 null
inside_coating_abbr_de varchar 3 null
inside_coating_abbr_en varchar 3 null
inside_coating_abbr_fr varchar 3 null
inside_coating_abbr_it varchar 3 null
inside_coating_abbr_ro varchar 3 null
inside_coating_active bool 1 null
inside_coating_value_de varchar 100 null
inside_coating_value_en varchar 100 null
inside_coating_value_fr varchar 100 null
inside_coating_value_it varchar 100 null
inside_coating_value_ro varchar 100 null
inside_coating_vsacode int4 10 null
material_code int4 10 null
material_abbr_de varchar 3 null
material_abbr_en varchar 3 null
material_abbr_fr varchar 3 null
material_abbr_it varchar 3 null
material_abbr_ro varchar 3 null
material_active bool 1 null
material_value_de varchar 100 null
material_value_en varchar 100 null
material_value_fr varchar 100 null
material_value_it varchar 100 null
material_value_ro varchar 100 null
material_vsacode int4 10 null
reliner_material_code int4 10 null
reliner_material_abbr_de varchar 3 null
reliner_material_abbr_en varchar 3 null
reliner_material_abbr_fr varchar 3 null
reliner_material_abbr_it varchar 3 null
reliner_material_abbr_ro varchar 3 null
reliner_material_active bool 1 null
reliner_material_value_de varchar 100 null
reliner_material_value_en varchar 100 null
reliner_material_value_fr varchar 100 null
reliner_material_value_it varchar 100 null
reliner_material_value_ro varchar 100 null
reliner_material_vsacode int4 10 null
relining_construction_code int4 10 null
relining_construction_abbr_de varchar 3 null
relining_construction_abbr_en varchar 3 null
relining_construction_abbr_fr varchar 3 null
relining_construction_abbr_it varchar 3 null
relining_construction_abbr_ro varchar 3 null
relining_construction_active bool 1 null
relining_construction_value_de varchar 100 null
relining_construction_value_en varchar 100 null
relining_construction_value_fr varchar 100 null
relining_construction_value_it varchar 100 null
relining_construction_value_ro varchar 100 null
relining_construction_vsacode int4 10 null
relining_kind_code int4 10 null
relining_kind_abbr_de varchar 3 null
relining_kind_abbr_en varchar 3 null
relining_kind_abbr_fr varchar 3 null
relining_kind_abbr_it varchar 3 null
relining_kind_abbr_ro varchar 3 null
relining_kind_active bool 1 null
relining_kind_value_de varchar 100 null
relining_kind_value_en varchar 100 null
relining_kind_value_fr varchar 100 null
relining_kind_value_it varchar 100 null
relining_kind_value_ro varchar 100 null
relining_kind_vsacode int4 10 null
profile_obj_id varchar 16 null
profile_fk_dataowner varchar 16 null
profile_fk_provider varchar 16 null
profile_height_width_ratio numeric 5,2 null
profile_identifier text 2147483647 null
profile_last_modification timestamp 29,6 null
profile_profile_type int4 10 null
profile_remark text 2147483647 null
function_hierarchic_code int4 10 null
function_hierarchic_abbr_de varchar 3 null
function_hierarchic_abbr_en varchar 3 null
function_hierarchic_abbr_fr varchar 3 null
function_hierarchic_abbr_it varchar 3 null
function_hierarchic_abbr_ro varchar 3 null
function_hierarchic_active bool 1 null
function_hierarchic_tww_is_primary bool 1 null
function_hierarchic_tww_symbology_inflow_prio bool 1 null
function_hierarchic_tww_symbology_order int2 5 null
function_hierarchic_tww_use_in_labels bool 1 null
function_hierarchic_value_de varchar 100 null
function_hierarchic_value_en varchar 100 null
function_hierarchic_value_fr varchar 100 null
function_hierarchic_value_it varchar 100 null
function_hierarchic_value_ro varchar 100 null
function_hierarchic_vsacode int4 10 null
connection_type_code int4 10 null
connection_type_abbr_de varchar 3 null
connection_type_abbr_en varchar 3 null
connection_type_abbr_fr varchar 3 null
connection_type_abbr_it varchar 3 null
connection_type_abbr_ro varchar 3 null
connection_type_active bool 1 null
connection_type_value_de varchar 100 null
connection_type_value_en varchar 100 null
connection_type_value_fr varchar 100 null
connection_type_value_it varchar 100 null
connection_type_value_ro varchar 100 null
connection_type_vsacode int4 10 null
function_hydraulic_code int4 10 null
function_hydraulic_abbr_de varchar 3 null
function_hydraulic_abbr_en varchar 3 null
function_hydraulic_abbr_fr varchar 3 null
function_hydraulic_abbr_it varchar 3 null
function_hydraulic_abbr_ro varchar 3 null
function_hydraulic_active bool 1 null
function_hydraulic_value_de varchar 100 null
function_hydraulic_value_en varchar 100 null
function_hydraulic_value_fr varchar 100 null
function_hydraulic_value_it varchar 100 null
function_hydraulic_value_ro varchar 100 null
function_hydraulic_vsacode int4 10 null
usage_current_code int4 10 null
usage_current_abbr_de varchar 3 null
usage_current_abbr_en varchar 3 null
usage_current_abbr_fr varchar 3 null
usage_current_abbr_it varchar 3 null
usage_current_abbr_ro varchar 3 null
usage_current_active bool 1 null
usage_current_tww_symbology_order int2 5 null
usage_current_value_de varchar 100 null
usage_current_value_en varchar 100 null
usage_current_value_fr varchar 100 null
usage_current_value_it varchar 100 null
usage_current_value_ro varchar 100 null
usage_current_vsacode int4 10 null
usage_planned_code int4 10 null
usage_planned_abbr_de varchar 3 null
usage_planned_abbr_en varchar 3 null
usage_planned_abbr_fr varchar 3 null
usage_planned_abbr_it varchar 3 null
usage_planned_abbr_ro varchar 3 null
usage_planned_active bool 1 null
usage_planned_value_de varchar 100 null
usage_planned_value_en varchar 100 null
usage_planned_value_fr varchar 100 null
usage_planned_value_it varchar 100 null
usage_planned_value_ro varchar 100 null
usage_planned_vsacode int4 10 null
accessibility_code int4 10 null
accessibility_abbr_de varchar 3 null
accessibility_abbr_en varchar 3 null
accessibility_abbr_fr varchar 3 null
accessibility_abbr_it varchar 3 null
accessibility_abbr_ro varchar 3 null
accessibility_active bool 1 null
accessibility_value_de varchar 100 null
accessibility_value_en varchar 100 null
accessibility_value_fr varchar 100 null
accessibility_value_it varchar 100 null
accessibility_value_ro varchar 100 null
accessibility_vsacode int4 10 null
financing_code int4 10 null
financing_abbr_de varchar 3 null
financing_abbr_en varchar 3 null
financing_abbr_fr varchar 3 null
financing_abbr_it varchar 3 null
financing_abbr_ro varchar 3 null
financing_active bool 1 null
financing_value_de varchar 100 null
financing_value_en varchar 100 null
financing_value_fr varchar 100 null
financing_value_it varchar 100 null
financing_value_ro varchar 100 null
financing_vsacode int4 10 null
renovation_necessity_code int4 10 null
renovation_necessity_abbr_de varchar 3 null
renovation_necessity_abbr_en varchar 3 null
renovation_necessity_abbr_fr varchar 3 null
renovation_necessity_abbr_it varchar 3 null
renovation_necessity_abbr_ro varchar 3 null
renovation_necessity_active bool 1 null
renovation_necessity_value_de varchar 100 null
renovation_necessity_value_en varchar 100 null
renovation_necessity_value_fr varchar 100 null
renovation_necessity_value_it varchar 100 null
renovation_necessity_value_ro varchar 100 null
renovation_necessity_vsacode int4 10 null
rv_construction_type_code int4 10 null
rv_construction_type_abbr_de varchar 3 null
rv_construction_type_abbr_en varchar 3 null
rv_construction_type_abbr_fr varchar 3 null
rv_construction_type_abbr_it varchar 3 null
rv_construction_type_abbr_ro varchar 3 null
rv_construction_type_active bool 1 null
rv_construction_type_value_de varchar 100 null
rv_construction_type_value_en varchar 100 null
rv_construction_type_value_fr varchar 100 null
rv_construction_type_value_it varchar 100 null
rv_construction_type_value_ro varchar 100 null
rv_construction_type_vsacode int4 10 null
status_code int4 10 null
status_abbr_de varchar 3 null
status_abbr_en varchar 3 null
status_abbr_fr varchar 3 null
status_abbr_it varchar 3 null
status_abbr_ro varchar 3 null
status_active bool 1 null
status_value_de varchar 100 null
status_value_en varchar 100 null
status_value_fr varchar 100 null
status_value_it varchar 100 null
status_value_ro varchar 100 null
status_vsacode int4 10 null
structure_condition_code int4 10 null
structure_condition_abbr_de varchar 3 null
structure_condition_abbr_en varchar 3 null
structure_condition_abbr_fr varchar 3 null
structure_condition_abbr_it varchar 3 null
structure_condition_abbr_ro varchar 3 null
structure_condition_active bool 1 null
structure_condition_value_de varchar 100 null
structure_condition_value_en varchar 100 null
structure_condition_value_fr varchar 100 null
structure_condition_value_it varchar 100 null
structure_condition_value_ro varchar 100 null
structure_condition_vsacode int4 10 null
owner_obj_id varchar 16 null
owner_fk_dataowner varchar 16 null
owner_fk_provider varchar 16 null
owner_identifier text 2147483647 null
owner_identifier_short text 2147483647 null
owner_last_modification timestamp 29,6 null
owner_municipality_number int2 5 null
owner_organisation_type int4 10 null
owner_remark text 2147483647 null
owner_status int4 10 null
owner_tww_active bool 1 null
owner_tww_local_extension bool 1 null
owner_uid text 2147483647 null
operator_obj_id varchar 16 null
operator_fk_dataowner varchar 16 null
operator_fk_provider varchar 16 null
operator_identifier text 2147483647 null
operator_identifier_short text 2147483647 null
operator_last_modification timestamp 29,6 null
operator_municipality_number int2 5 null
operator_organisation_type int4 10 null
operator_remark text 2147483647 null
operator_status int4 10 null
operator_tww_active bool 1 null
operator_tww_local_extension bool 1 null
operator_uid text 2147483647 null

Relationships

View Definition


Possibly Referenced Tables/Views