Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| obj_id | varchar | 16 | √ | tdh_app.generate_oid('tdh_od'::text, 'pipe_point_feed'::text) |
|
|
||
| aperture_value | int4 | 10 | √ | null |
|
|
||
| category | int4 | 10 | √ | null |
|
|
||
| flow_temperature | int4 | 10 | √ | null |
|
|
||
| heat_consumption | int4 | 10 | √ | null |
|
|
||
| heated_volume | int4 | 10 | √ | null |
|
|
||
| kind | int4 | 10 | √ | null |
|
|
||
| power_output | int4 | 10 | √ | null |
|
|
||
| power_output_installed | int4 | 10 | √ | null |
|
|
||
| power_output_ordered | int4 | 10 | √ | null |
|
|
||
| pressure | int2 | 5 | √ | null |
|
|
||
| q_subscribed | numeric | 7,3 | √ | null |
|
|
||
| return_flow_temperature | int4 | 10 | √ | null |
|
|
||
| year_of_commissioning | int2 | 5 | √ | null |
|
|
||
| year_of_reconstruction | int2 | 5 | √ | null |
|
|
||
| altitude1 | numeric | 7,3 | √ | null |
|
|
||
| altitude2 | numeric | 7,3 | √ | null |
|
|
||
| elevation_determination | int4 | 10 | √ | null |
|
|
||
| fk_dataowner | varchar | 16 | √ | null |
|
|
||
| fk_owner | varchar | 16 | √ | null |
|
|
||
| fk_provider | varchar | 16 | √ | null |
|
|
||
| geometry3d_geometry | geometry | 2147483647 | √ | null |
|
|
||
| horizontal_positioning | int4 | 10 | √ | null |
|
|
||
| last_modification | timestamp | 29,6 | √ | null |
|
|
||
| remark | text | 2147483647 | √ | null |
|
|
||
| symbolori | numeric | 4,1 | √ | null |
|
|