Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pp_type | text | 2147483647 | √ | null |
|
|
||
| pn_kind | int4 | 10 | √ | null |
|
|
||
| pf_kind | int4 | 10 | √ | null |
|
|
||
| fk_owner | varchar | 16 | √ | null |
|
|
||
| obj_id | varchar | 16 | √ | tdh_app.generate_oid('tdh_od'::text, 'pipe_point'::text) |
|
|
||
| altitude1 | numeric | 7,3 | √ | null |
|
|
||
| altitude2 | numeric | 7,3 | √ | null |
|
|
||
| elevation_determination | int4 | 10 | √ | null |
|
|
||
| fk_dataowner | varchar | 16 | √ | null |
|
|
||
| fk_provider | varchar | 16 | √ | null |
|
|
||
| horizontal_positioning | int4 | 10 | √ | null |
|
|
||
| last_modification | timestamp | 29,6 | √ | null |
|
|
||
| remark | text | 2147483647 | √ | null |
|
|
||
| symbolori | numeric | 4,1 | √ | null |
|
|
||
| situation3d_geometry | geometry | 2147483647 | √ | null |
|
|
||
| pn_armature_setting | int4 | 10 | √ | null |
|
|
||
| pn_material | int4 | 10 | √ | null |
|
|
||
| pf_aperture_value | int4 | 10 | √ | null |
|
|
||
| pf_category | int4 | 10 | √ | null |
|
|
||
| pf_flow_temperature | int4 | 10 | √ | null |
|
|
||
| pf_heat_consumption | int4 | 10 | √ | null |
|
|
||
| pf_heated_volume | int4 | 10 | √ | null |
|
|
||
| pf_power_output | int4 | 10 | √ | null |
|
|
||
| pf_power_output_installed | int4 | 10 | √ | null |
|
|
||
| pf_power_output_ordered | int4 | 10 | √ | null |
|
|
||
| pf_pressure | int2 | 5 | √ | null |
|
|
||
| pf_q_subscribed | numeric | 7,3 | √ | null |
|
|
||
| pf_return_flow_temperature | int4 | 10 | √ | null |
|
|
||
| pf_year_of_commissioning | int2 | 5 | √ | null |
|
|
||
| pf_year_of_reconstruction | int2 | 5 | √ | null |
|
|