| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| id |
int4 |
10 |
√ |
|
null |
|
|
| fk_function |
int4 |
10 |
√ |
|
null |
|
|
| fk_installmethod |
int4 |
10 |
√ |
|
null |
|
|
| fk_material |
int4 |
10 |
√ |
|
null |
|
|
| fk_distributor |
int4 |
10 |
√ |
|
null |
|
|
| fk_precision |
int4 |
10 |
√ |
|
null |
|
|
| fk_protection |
int4 |
10 |
√ |
|
null |
|
|
| fk_status |
int4 |
10 |
√ |
|
null |
|
|
| fk_folder |
int4 |
10 |
√ |
|
null |
|
|
| year |
int2 |
5 |
√ |
|
null |
|
|
| year_end |
int2 |
5 |
√ |
|
null |
|
|
| pressure_nominal |
int2 |
5 |
√ |
|
null |
|
|
| remark |
text |
2147483647 |
√ |
|
null |
|
|
| fk_district |
int4 |
10 |
√ |
|
null |
|
|
| fk_pressurezone |
int4 |
10 |
√ |
|
null |
|
|
| fk_printmap |
_int4 |
10 |
√ |
|
null |
|
|
| _printmaps |
varchar |
100 |
√ |
|
null |
|
|
| label_2_visible |
int2 |
5 |
√ |
|
null |
|
|
| label_2_text |
varchar |
120 |
√ |
|
null |
|
|
| _length2d |
numeric |
131089 |
√ |
|
null |
|
|
| _length3d |
numeric |
131089 |
√ |
|
null |
|
|
| number_of_pipe |
int8 |
19 |
√ |
|
null |
|
|
| tunnel_or_bridge |
bool |
1 |
√ |
|
null |
|
|
| _valve_count |
int8 |
19 |
√ |
|
null |
|
|
| _valve_closed |
bool |
1 |
√ |
|
null |
|
|
| _pressurezone |
varchar |
50 |
√ |
|
null |
|
|
| _pressurezone_colorcode |
int2 |
5 |
√ |
|
null |
|
|
| geometry |
geometry |
2147483647 |
√ |
|
null |
|
|
Analyzed at mar. mars 21 17:52 CET 2017
|