vw_tww_channel_maintenance

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
obj_id varchar 16 null
base_data text 2147483647 null
cost numeric 10,2 null
data_details text 2147483647 null
duration int2 5 null
fk_dataowner varchar 16 null
fk_measure varchar 16 null
fk_operating_company varchar 16 null
fk_provider varchar 16 null
identifier text 2147483647 null
last_modification timestamp 29,6 null
operator text 2147483647 null
reason text 2147483647 null
remark text 2147483647 null
result text 2147483647 null
status int4 10 null
time_point timestamp 29,6 null
kind int4 10 null
ch__bottom_label text 2147483647 null
ch__cover_label text 2147483647 null
ch__input_label text 2147483647 null
ch__length_effective numeric 0 null
ch__materials _int4 10 null
ch__max_height int4 10 null
ch__min_height int4 10 null
ch__output_label text 2147483647 null
ch_accessibility int4 10 null
ch_ch_bedding_encasement int4 10 null
ch_ch_connection_type int4 10 null
ch_ch_function_amelioration int4 10 null
ch_ch_function_hierarchic int4 10 null
ch_ch_function_hydraulic int4 10 null
ch_ch_jetting_interval numeric 4,2 null
ch_ch_pipe_length numeric 7,2 null
ch_ch_seepage int4 10 null
ch_ch_usage_current int4 10 null
ch_ch_usage_planned int4 10 null
ch_condition_score numeric 3,2 null
ch_contract_section text 2147483647 null
ch_elevation_determination int4 10 null
ch_financing int4 10 null
ch_fk_main_wastewater_node varchar 16 null
ch_fk_operator varchar 16 null
ch_gross_costs numeric 10,2 null
ch_identifier text 2147483647 null
ch_inspection_interval numeric 4,2 null
ch_last_modification timestamp 29,6 null
ch_location_name text 2147483647 null
ch_obj_id varchar 16 null
ch_progression2d_geometry geometry 2147483647 null
ch_records text 2147483647 null
ch_remark text 2147483647 null
ch_renovation_necessity int4 10 null
ch_replacement_value numeric 10,2 null
ch_rv_base_year int2 5 null
ch_rv_construction_type int4 10 null
ch_status int4 10 null
ch_status_survey_year int2 5 null
ch_structure_condition int4 10 null
ch_subsidies numeric 10,2 null
ch_tww_is_primary bool 1 null
ch_urgency_figure int2 5 null
ch_year_of_construction int2 5 null
ch_year_of_replacement int2 5 null

Relationships

View Definition


Possibly Referenced Tables/Views