vw_tww_infiltration_installation

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier text 2147483647 √ 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
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
mp_obj_id varchar 16 √ tww_app.generate_oid('tww_od'::text, 'mechanical_pretreatment'::text)
mp_fk_dataowner varchar 16 √ null
mp_fk_provider varchar 16 √ null
mp_fk_wastewater_structure varchar 16 √ null
mp_identifier text 2147483647 √ null
mp_kind int4 10 √ null
mp_last_modification timestamp 29,6 √ null
mp_remark text 2147483647 √ null
rb_obj_id varchar 16 √ tww_app.generate_oid('tww_od'::text, 'retention_body'::text)
rb_fk_dataowner varchar 16 √ null
rb_fk_provider varchar 16 √ null
rb_identifier text 2147483647 √ null
rb_kind int4 10 √ null
rb_last_modification timestamp 29,6 √ null
rb_remark text 2147483647 √ null
rb_volume numeric 10,2 √ 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
_channel_usage_current int4 10 √ null
_channel_function_hierarchic int4 10 √ null
tww_is_primary bool 1 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views