Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
obj_id | varchar | 16 | √ | tww_app.generate_oid('tww_od'::text, 'reach'::text) |
|
|
||
clear_height | int4 | 10 | √ | null |
|
|
||
coefficient_of_friction | int2 | 5 | √ | null |
|
|
||
elevation_determination | int4 | 10 | √ | null |
|
|
||
fk_pipe_profile | varchar | 16 | √ | null |
|
|
||
fk_reach_point_from | varchar | 16 | √ | null |
|
|
||
fk_reach_point_to | varchar | 16 | √ | null |
|
|
||
flow_time_dry_weather | numeric | 7 | √ | null |
|
|
||
horizontal_positioning | int4 | 10 | √ | null |
|
|
||
hydraulic_load_current | int2 | 5 | √ | null |
|
|
||
inside_coating | int4 | 10 | √ | null |
|
|
||
leak_protection | int4 | 10 | √ | null |
|
|
||
length_effective | numeric | 7,2 | √ | null |
|
|
||
material | int4 | 10 | √ | null |
|
|
||
progression3d_geometry | geometry | 2147483647 | √ | null |
|
|
||
reliner_material | int4 | 10 | √ | null |
|
|
||
reliner_nominal_size | int4 | 10 | √ | null |
|
|
||
relining_construction | int4 | 10 | √ | null |
|
|
||
relining_kind | int4 | 10 | √ | null |
|
|
||
ring_stiffness | int2 | 5 | √ | null |
|
|
||
slope_building_plan | int2 | 5 | √ | null |
|
|
||
swmm_default_coefficient_of_friction | int2 | 5 | √ | null |
|
|
||
wall_roughness | numeric | 5,2 | √ | null |
|
|
||
fk_dataowner | varchar | 16 | √ | null |
|
|
||
fk_provider | varchar | 16 | √ | null |
|
|
||
fk_wastewater_structure | varchar | 16 | √ | null |
|
|
||
identifier | text | 2147483647 | √ | null |
|
|
||
last_modification | timestamp | 29,6 | √ | null |
|
|
||
remark | text | 2147483647 | √ | null |
|
|