Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
id |
serial |
10 |
|
√ |
nextval('qwat_od.district_id_seq'::regclass) |
node.fk_district
|
node_fk_district R |
pipe.fk_district
|
pipe_fk_district R |
printmap.fk_district
|
printmap_fk_district R |
valve.fk_district
|
valve_fk_district R |
|
|
name |
varchar |
40 |
|
|
|
|
|
shortname |
varchar |
12 |
√ |
|
null |
|
|
zip |
varchar |
12 |
√ |
|
null |
|
|
land_registry |
varchar |
12 |
√ |
|
null |
|
|
prefix |
varchar |
12 |
√ |
|
null |
|
|
colorcode |
int2 |
5 |
√ |
|
1 |
|
|
geometry |
geometry |
2147483647 |
√ |
|
null |
|
|
label_1_visible |
int2 |
5 |
√ |
|
1 |
|
visible.vl_code_int
|
district_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
|
district_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 4 rows at mar. mars 21 17:52 CET 2017
|