| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| id |
serial |
10 |
|
√ |
nextval('qwat_od.pressurezone_id_seq'::regclass) |
| node.fk_pressurezone
|
node_fk_pressurezone R |
| pipe.fk_pressurezone
|
pipe_fk_pressurezone R |
| valve.fk_pressurezone
|
valve_fk_pressurezone R |
|
|
| fk_distributor |
int4 |
10 |
|
|
|
|
|
| fk_consumptionzone |
int4 |
10 |
√ |
|
null |
|
|
| name |
varchar |
50 |
|
|
|
|
|
| population |
int4 |
10 |
√ |
|
null |
|
|
| subscriber |
int4 |
10 |
√ |
|
null |
|
|
| colorcode |
int2 |
5 |
√ |
|
null |
|
|
| geometry |
geometry |
2147483647 |
√ |
|
null |
|
|
| geometry_alt1 |
geometry |
2147483647 |
√ |
|
null |
|
|
| geometry_alt2 |
geometry |
2147483647 |
√ |
|
null |
|
|
| _geometry_alt1_used |
bool |
1 |
√ |
|
null |
|
|
| _geometry_alt2_used |
bool |
1 |
√ |
|
null |
|
|
| update_geometry_alt1 |
bool |
1 |
√ |
|
null |
|
|
| update_geometry_alt2 |
bool |
1 |
√ |
|
null |
|
|
| label_1_visible |
int2 |
5 |
√ |
|
1 |
|
| visible.vl_code_int
|
pressurezone_label_1_visible R |
|
| label_1_x |
float8 |
17,17 |
√ |
|
null |
|
|
| label_1_y |
float8 |
17,17 |
√ |
|
null |
|
|
| label_1_rotation |
float8 |
17,17 |
√ |
|
null |
|
|
| label_1_text |
varchar |
120 |
√ |
|
null |
|
|
| label_2_visible |
int2 |
5 |
√ |
|
1 |
|
| visible.vl_code_int
|
pressurezone_label_2_visible R |
|
| label_2_x |
float8 |
17,17 |
√ |
|
null |
|
|
| label_2_y |
float8 |
17,17 |
√ |
|
null |
|
|
| label_2_rotation |
float8 |
17,17 |
√ |
|
null |
|
|
| label_2_text |
varchar |
120 |
√ |
|
null |
|
|
Table contained 50 rows at mar. mars 21 17:52 CET 2017
|
