vw_tww_catchment_area_totals

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_id varchar 16 √ tww_app.generate_oid('tww_od'::text, 'catchment_area_totals'::text)
discharge_freight_nh4_n int4 10 √ null
discharge_proportion_nh4_n numeric 5,2 √ null
fk_dataowner varchar 16 √ null
fk_discharge_point varchar 16 √ null
fk_hydraulic_char_data varchar 16 √ null
fk_provider varchar 16 √ null
identifier text 2147483647 √ null
last_modification timestamp 29,6 √ null
population int4 10 √ null
population_dim int4 10 √ null
sewer_infiltration_water numeric 9,3 √ null
surface_area numeric 10,4 √ null
surface_dim numeric 10,4 √ null
surface_imp numeric 10,4 √ null
surface_imp_dim numeric 10,4 √ null
surface_red numeric 10,4 √ null
surface_red_dim numeric 10,4 √ null
waste_water_production numeric 9,3 √ null
fk_log_card varchar 16 √ null
perimeter_geometry geometry 2147483647 √ null
situation3d_geometry geometry 2147483647 √ null
wn_obj_id varchar 16 √ null
hc_c_obj_id varchar 16 √ tww_app.generate_oid('tww_od'::text, 'hydraulic_char_data'::text)
hc_c_aggregate_number int2 5 √ null
hc_c_delivery_height_geodaetic numeric 7,2 √ null
hc_c_fk_dataowner varchar 16 √ null
hc_c_fk_overflow_char varchar 16 √ null
hc_c_fk_primary_direction varchar 16 √ null
hc_c_fk_provider varchar 16 √ null
hc_c_identifier text 2147483647 √ null
hc_c_is_overflowing int4 10 √ null
hc_c_last_modification timestamp 29,6 √ null
hc_c_main_weir_kind int4 10 √ null
hc_c_overcharge int2 5 √ null
hc_c_overflow_duration numeric 6,1 √ null
hc_c_overflow_freight int4 10 √ null
hc_c_overflow_frequency numeric 4,1 √ null
hc_c_overflow_volume numeric 10,2 √ null
hc_c_pump_characteristics int4 10 √ null
hc_c_pump_flow_max numeric 9,3 √ null
hc_c_pump_flow_min numeric 9,3 √ null
hc_c_q_discharge numeric 9,3 √ null
hc_c_qon numeric 9,3 √ null
hc_c_remark text 2147483647 √ null
hc_o_obj_id varchar 16 √ tww_app.generate_oid('tww_od'::text, 'hydraulic_char_data'::text)
hc_o_aggregate_number int2 5 √ null
hc_o_delivery_height_geodaetic numeric 7,2 √ null
hc_o_fk_dataowner varchar 16 √ null
hc_o_fk_overflow_char varchar 16 √ null
hc_o_fk_primary_direction varchar 16 √ null
hc_o_fk_provider varchar 16 √ null
hc_o_identifier text 2147483647 √ null
hc_o_is_overflowing int4 10 √ null
hc_o_last_modification timestamp 29,6 √ null
hc_o_main_weir_kind int4 10 √ null
hc_o_overcharge int2 5 √ null
hc_o_overflow_duration numeric 6,1 √ null
hc_o_overflow_freight int4 10 √ null
hc_o_overflow_frequency numeric 4,1 √ null
hc_o_overflow_volume numeric 10,2 √ null
hc_o_pump_characteristics int4 10 √ null
hc_o_pump_flow_max numeric 9,3 √ null
hc_o_pump_flow_min numeric 9,3 √ null
hc_o_q_discharge numeric 9,3 √ null
hc_o_qon numeric 9,3 √ null
hc_o_remark text 2147483647 √ null
hc_p_obj_id varchar 16 √ tww_app.generate_oid('tww_od'::text, 'hydraulic_char_data'::text)
hc_p_aggregate_number int2 5 √ null
hc_p_delivery_height_geodaetic numeric 7,2 √ null
hc_p_fk_dataowner varchar 16 √ null
hc_p_fk_overflow_char varchar 16 √ null
hc_p_fk_primary_direction varchar 16 √ null
hc_p_fk_provider varchar 16 √ null
hc_p_identifier text 2147483647 √ null
hc_p_is_overflowing int4 10 √ null
hc_p_last_modification timestamp 29,6 √ null
hc_p_main_weir_kind int4 10 √ null
hc_p_overcharge int2 5 √ null
hc_p_overflow_duration numeric 6,1 √ null
hc_p_overflow_freight int4 10 √ null
hc_p_overflow_frequency numeric 4,1 √ null
hc_p_overflow_volume numeric 10,2 √ null
hc_p_pump_characteristics int4 10 √ null
hc_p_pump_flow_max numeric 9,3 √ null
hc_p_pump_flow_min numeric 9,3 √ null
hc_p_q_discharge numeric 9,3 √ null
hc_p_qon numeric 9,3 √ null
hc_p_remark text 2147483647 √ null
hg_c_obj_id varchar 16 √ tww_app.generate_oid('tww_od'::text, 'hydr_geometry'::text)
hg_c_fk_dataowner varchar 16 √ null
hg_c_fk_provider varchar 16 √ null
hg_c_identifier text 2147483647 √ null
hg_c_last_modification timestamp 29,6 √ null
hg_c_remark text 2147483647 √ null
hg_c_storage_volume numeric 10,2 √ null
hg_c_usable_capacity_storage numeric 10,2 √ null
hg_c_usable_capacity_treatment numeric 10,2 √ null
hg_c_utilisable_capacity numeric 10,2 √ null
hg_c_volume_pump_sump numeric 10,2 √ null
ws_status int4 10 √ null
ma_function int4 10 √ null
ss_function int4 10 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views