vw_tww_maintenance_event

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
maintenance_event_type "tww_app"."maintenance_event_type" 2147483647 null
obj_id varchar 16 tww_app.generate_oid('tww_od'::text, 'maintenance_event'::text)
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
bo_comparison_last int4 10 null
bo_date_last_examen timestamp 29,6 null
bo_impact_auxiliary_indic int4 10 null
bo_impact_external_aspect int4 10 null
bo_impact_macroinvertebrates int4 10 null
bo_impact_water_plants int4 10 null
bo_intervention_demand int4 10 null
bo_io_calculation int4 10 null
bo_kind_water_body int4 10 null
bo_outlet_pipe_clear_height int4 10 null
bo_q347 numeric 8,3 null
bo_relevance_matrix int4 10 null
bo_relevant_slope int2 5 null
bo_surface_water_bodies text 2147483647 null
bo_water_specific_discharge_freight_nh4_n_current int2 5 null
bo_water_specific_discharge_freight_nh4_n_current_opt int2 5 null
bo_water_specific_discharge_freight_nh4_n_planned int2 5 null
ex_equipment text 2147483647 null
ex_fk_reach_point varchar 16 null
ex_from_point_identifier text 2147483647 null
ex_inspected_length numeric 7,2 null
ex_recording_type int4 10 null
ex_to_point_identifier text 2147483647 null
ex_vehicle text 2147483647 null
ex_videonumber text 2147483647 null
ex_weather int4 10 null
mn_kind int4 10 null

Relationships

View Definition


Possibly Referenced Tables/Views