vw_channel

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_id varchar 16 tww_app.generate_oid('tww_od'::text, 'channel'::text)
bedding_encasement int4 10 null
connection_type int4 10 null
function_amelioration int4 10 null
function_hierarchic int4 10 null
function_hydraulic int4 10 null
jetting_interval numeric 4,2 null
pipe_length numeric 7,2 null
seepage int4 10 null
usage_current int4 10 null
usage_planned 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