| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| id |
int4 |
10 |
√ |
|
null |
|
|
| name |
varchar |
60 |
√ |
|
null |
|
|
| fk_parent |
int4 |
10 |
√ |
|
null |
|
|
| fk_remote |
int4 |
10 |
√ |
|
null |
|
|
| fk_watertype |
int4 |
10 |
√ |
|
null |
|
|
| parcel |
varchar |
30 |
√ |
|
null |
|
|
| eca |
varchar |
30 |
√ |
|
null |
|
|
| open_water_surface |
bool |
1 |
√ |
|
null |
|
|
| geometry_polygon |
geometry |
2147483647 |
√ |
|
null |
|
|
| fk_overflow |
int4 |
10 |
√ |
|
null |
|
|
| fk_tank_firestorage |
int4 |
10 |
√ |
|
null |
|
|
| storage_total |
numeric |
10,1 |
√ |
|
null |
|
|
| storage_supply |
numeric |
10,1 |
√ |
|
null |
|
|
| storage_fire |
numeric |
10,1 |
√ |
|
null |
|
|
| altitude_overflow |
numeric |
7,3 |
√ |
|
null |
|
|
| altitude_apron |
numeric |
7,3 |
√ |
|
null |
|
|
| height_max |
numeric |
7,3 |
√ |
|
null |
|
|
| fire_valve |
bool |
1 |
√ |
|
null |
|
|
| fire_remote |
bool |
1 |
√ |
|
null |
|
|
| _litrepercm |
numeric |
9,3 |
√ |
|
null |
|
|
| cistern1_fk_type |
int4 |
10 |
√ |
|
null |
|
|
| cistern1_dimension_1 |
numeric |
10,2 |
√ |
|
null |
|
|
| cistern1_dimension_2 |
numeric |
10,2 |
√ |
|
null |
|
|
| cistern1_storage |
numeric |
10,2 |
√ |
|
null |
|
|
| _cistern1_litrepercm |
numeric |
9,3 |
√ |
|
null |
|
|
| cistern2_fk_type |
int4 |
10 |
√ |
|
null |
|
|
| cistern2_dimension_1 |
numeric |
10,2 |
√ |
|
null |
|
|
| cistern2_dimension_2 |
numeric |
10,2 |
√ |
|
null |
|
|
| cistern2_storage |
numeric |
10,2 |
√ |
|
null |
|
|
| _cistern2_litrepercm |
numeric |
9,3 |
√ |
|
null |
|
|
Analyzed at mar. mars 21 17:52 CET 2017
|