vw_tww_ws_maintenance

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 √ null
situation3d_geometry geometry 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
ws_obj_id varchar 16 √ null
ws__bottom_label text 2147483647 √ null
ws__cover_label text 2147483647 √ null
ws__input_label text 2147483647 √ null
ws__label text 2147483647 √ null
ws__output_label text 2147483647 √ null
ws_condition_score numeric 3,2 √ null
ws_financing int4 10 √ 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_renovation_necessity int4 10 √ null
ws_status int4 10 √ null
ws_status_survey_year int2 5 √ null
ws_structure_condition int4 10 √ null
ws_urgency_figure int2 5 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views