vw_tww_channel_maintenance

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
me_obj_id varchar 16 null
me_base_data text 2147483647 null
me_cost numeric 10,2 null
me_data_details text 2147483647 null
me_duration int2 5 null
me_fk_dataowner varchar 16 null
me_fk_measure varchar 16 null
me_fk_operating_company varchar 16 null
me_fk_provider varchar 16 null
me_identifier text 2147483647 null
me_last_modification timestamp 29,6 null
me_operator text 2147483647 null
me_reason text 2147483647 null
me_remark text 2147483647 null
me_result text 2147483647 null
me_status int4 10 null
me_time_point timestamp 29,6 null
mn_kind int4 10 null
_from_node varchar 2147483647 null
_re_length_effective numeric 0 null
_re_materials _varchar 2147483647 null
_re_max_height int4 10 null
_re_min_height int4 10 null
_to_node varchar 2147483647 null
ch_bedding_encasement int4 10 null
ch_connection_type int4 10 null
ch_function_amelioration int4 10 null
ch_function_hierarchic int4 10 null
ch_function_hydraulic int4 10 null
ch_jetting_interval numeric 4,2 null
ch_obj_id varchar 16 null
ch_pipe_length numeric 7,2 null
progression2d_geometry geometry 2147483647 null
ch_seepage int4 10 null
tww_is_primary bool 1 null
ch_usage_current int4 10 null
ch_usage_planned int4 10 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_fk_owner 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 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

Relationships

View Definition


Possibly Referenced Tables/Views