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) |
|
|
INTERLIS STANDARD OID (with Postfix/Präfix), see www.interlis.ch |
|||||
| kind | int4 | 10 | √ | null |
|
|
|||||
| power_output_ordered | int4 | 10 | √ | null |
|
|
|||||
| power_output_installed | int4 | 10 | √ | null |
|
|
|||||
| aperture_value | int4 | 10 | √ | null |
|
|
|||||
| q_subscribed | numeric | 7,3 | √ | null |
|
|
|||||
| category | int4 | 10 | √ | null |
|
|
|||||
| year_of_commissioning | int2 | 5 | √ | null |
|
|
|||||
| year_of_reconstruction | int2 | 5 | √ | null |
|
|
Year of reconstruction / Jahr des Umbaus / Année de transformation |
||||
| pressure | int2 | 5 | √ | null |
|
|
/ Primaerer_Konstruktionsdruck (bar_Ue) / pression de construction primaire [bar] |
||||
| flow_temperature | int4 | 10 | √ | null |
|
|
/ température |
||||
| return_flow_temperature | int4 | 10 | √ | null |
|
|
/ température |
||||
| heated_volume | int4 | 10 | √ | null |
|
|
yyy_Beheiztes Volumen / Beheiztes Volumen / xxx_Beheiztes Volumen |
||||
| heat_consumption | int4 | 10 | √ | null |
|
|
per year / Pro Jahr / par année |
||||
| power_output | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pkey_tdh_od_pipe_point_feed_obj_id | Primary key | Asc | obj_id |