vw_tww_wastewater_structure

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier text 2147483647 null
ws_type text 2147483647 null
ma_function int4 10 null
ss_function int4 10 null
fk_owner varchar 16 null
status int4 10 null
obj_id varchar 16 tww_app.generate_oid('tww_od'::text, 'wastewater_structure'::text)
_depth numeric 6,3 null
accessibility int4 10 null
condition_score numeric 3,2 null
contract_section text 2147483647 null
elevation_determination int4 10 null
financing int4 10 null
fk_dataowner varchar 16 null
fk_operator varchar 16 null
fk_provider varchar 16 null
gross_costs numeric 10,2 null
inspection_interval numeric 4,2 null
last_modification timestamp 29,6 null
location_name text 2147483647 null
records text 2147483647 null
remark text 2147483647 null
renovation_necessity int4 10 null
replacement_value numeric 10,2 null
rv_base_year int2 5 null
rv_construction_type int4 10 null
status_survey_year int2 5 null
structure_condition int4 10 null
subsidies numeric 10,2 null
urgency_figure int2 5 null
year_of_construction int2 5 null
year_of_replacement int2 5 null
co_identifier text 2147483647 null
co_remark text 2147483647 null
co_renovation_demand int4 10 null
co_obj_id varchar 16 tww_app.generate_oid('tww_od'::text, 'cover'::text)
co_brand text 2147483647 null
co_shape int4 10 null
co_diameter int2 5 null
co_fastening int4 10 null
co_level numeric 7,3 null
co_material int4 10 null
co_positional_accuracy int4 10 null
co_sludge_bucket int4 10 null
co_venting int4 10 null
situation3d_geometry geometry 2147483647 null
ma_orientation numeric 0 null
ma_amphibian_exit int4 10 null
ma_dimension1 int2 5 null
ma_dimension2 int2 5 null
ma_material int4 10 null
ma_possibility_intervention int4 10 null
ma_surface_inflow int4 10 null
ss_amphibian_exit int4 10 null
ss_bypass int4 10 null
ss_emergency_overflow int4 10 null
ss_possibility_intervention int4 10 null
ss_stormwater_tank_arrangement int4 10 null
ss_upper_elevation numeric 7,3 null
ii_absorption_capacity numeric 9,3 null
ii_defects int4 10 null
ii_dimension1 int2 5 null
ii_dimension2 int2 5 null
ii_distance_to_aquifer numeric 7,2 null
ii_effective_area numeric 8,2 null
ii_emergency_overflow int4 10 null
ii_filling_material int4 10 null
ii_fk_dss15_aquifer varchar 16 null
ii_kind int4 10 null
ii_labeling int4 10 null
ii_seepage_utilization int4 10 null
ii_upper_elevation numeric 7,3 null
ii_vehicle_access int4 10 null
ii_watertightness int4 10 null
dp_highwater_level numeric 7,3 null
dp_relevance int4 10 null
dp_terrain_level numeric 7,3 null
dp_upper_elevation numeric 7,3 null
dp_water_course_number text 2147483647 null
dp_water_course_segment_canton text 2147483647 null
dp_waterlevel_hydraulic numeric 7,3 null
wn_obj_id varchar 16 tww_app.generate_oid('tww_od'::text, 'wastewater_node'::text)
wn_backflow_level_current numeric 7,3 null
wn_bottom_level numeric 7,3 null
wn_elevation_accuracy int4 10 null
wn_fk_hydr_geometry varchar 16 null
wn_function_node_amelioration int4 10 null
wn_wwtp_number int4 10 null
wn_fk_dataowner varchar 16 null
wn_fk_provider varchar 16 null
wn_fk_wastewater_structure varchar 16 null
wn_identifier text 2147483647 null
wn_last_modification timestamp 29,6 null
wn_remark text 2147483647 null
_label text 2147483647 null
_cover_label text 2147483647 null
_bottom_label text 2147483647 null
_input_label text 2147483647 null
_output_label text 2147483647 null
_channel_usage_current int4 10 null
_channel_function_hierarchic int4 10 null

Relationships

View Definition


Possibly Referenced Tables/Views