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_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
tww_is_primary bool 1 √ null
_owner_organisation_type int4 10 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views