vw_manhole

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_id varchar 16 tww_app.generate_oid('tww_od'::text, 'manhole'::text)
_orientation numeric 0 null
amphibian_exit int4 10 null
dimension1 int2 5 null
dimension2 int2 5 null
function int4 10 null
material int4 10 null
possibility_intervention int4 10 null
surface_inflow int4 10 null
_bottom_label text 2147483647 null
_cover_label text 2147483647 null
_depth numeric 6,3 null
_input_label text 2147483647 null
_label text 2147483647 null
_output_label text 2147483647 null
accessibility int4 10 null
condition_score numeric 3,2 null
contract_section text 2147483647 null
detail_geometry3d_geometry geometry 2147483647 null
elevation_determination int4 10 null
financing int4 10 null
fk_dataowner varchar 16 null
fk_main_cover varchar 16 null
fk_main_wastewater_node varchar 16 null
fk_operator varchar 16 null
fk_owner varchar 16 null
fk_provider varchar 16 null
gross_costs numeric 10,2 null
identifier text 2147483647 null
inspection_interval numeric 4,2 null
last_modification timestamp 29,6 null
location_name text 2147483647 null
records text 2147483647 null
remark text 2147483647 null
renovation_necessity int4 10 null
replacement_value numeric 10,2 null
rv_base_year int2 5 null
rv_construction_type int4 10 null
status int4 10 null
status_survey_year int2 5 null
structure_condition int4 10 null
subsidies numeric 10,2 null
urgency_figure int2 5 null
year_of_construction int2 5 null
year_of_replacement int2 5 null

Relationships

View Definition


Possibly Referenced Tables/Views