vw_tww_reach

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_id varchar 16 tww_app.generate_oid('tww_od'::text, 'reach'::text)
clear_height int4 10 null
material int4 10 null
ch_usage_current int4 10 null
ch_function_hierarchic int4 10 null
ws_status int4 10 null
ws_fk_owner varchar 16 null
ch_function_hydraulic int4 10 null
width int4 10 null
_slope_per_mill numeric 0 null
coefficient_of_friction int2 5 null
elevation_determination int4 10 null
fk_pipe_profile varchar 16 null
flow_time_dry_weather numeric 7 null
horizontal_positioning int4 10 null
hydraulic_load_current int2 5 null
inside_coating int4 10 null
leak_protection int4 10 null
length_effective numeric 7,2 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
ring_stiffness int2 5 null
slope_building_plan int2 5 null
swmm_default_coefficient_of_friction int2 5 null
wall_roughness numeric 5,2 null
fk_dataowner varchar 16 null
fk_provider varchar 16 null
identifier text 2147483647 null
last_modification timestamp 29,6 null
remark text 2147483647 null
ch_bedding_encasement int4 10 null
ch_connection_type int4 10 null
ch_function_amelioration int4 10 null
ch_jetting_interval numeric 4,2 null
ch_pipe_length numeric 7,2 null
ch_seepage int4 10 null
ch_usage_planned int4 10 null
ws_obj_id varchar 16 tww_app.generate_oid('tww_od'::text, 'channel'::text)
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_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_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_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
rp_from_obj_id varchar 16 tww_app.generate_oid('tww_od'::text, 'reach_point'::text)
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_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_obj_id varchar 16 tww_app.generate_oid('tww_od'::text, 'reach_point'::text)
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_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

Relationships

View Definition


Possibly Referenced Tables/Views