Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
installation_type |
installation_type |
2147483647 |
√ |
|
null |
|
|
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_source_type |
int2 |
5 |
√ |
|
null |
|
|
fk_source_quality |
int2 |
5 |
√ |
|
null |
|
|
flow_lowest |
numeric |
10,3 |
√ |
|
null |
|
|
flow_average |
numeric |
10,3 |
√ |
|
null |
|
|
flow_concession |
numeric |
10,2 |
√ |
|
null |
|
|
contract_end |
date |
13 |
√ |
|
null |
|
|
gathering_chamber |
bool |
1 |
√ |
|
null |
|
|
fk_pump_type |
int2 |
5 |
√ |
|
null |
|
|
fk_pipe_in |
int4 |
10 |
√ |
|
null |
|
|
fk_pipe_out |
int4 |
10 |
√ |
|
null |
|
|
fk_pump_operating |
int2 |
5 |
√ |
|
null |
|
|
no_pumps |
int2 |
5 |
√ |
|
null |
|
|
rejected_flow |
numeric |
10,2 |
√ |
|
null |
|
|
manometric_height |
numeric |
10,2 |
√ |
|
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 |
|
|
sanitization_uv |
bool |
1 |
√ |
|
null |
|
|
sanitization_chlorine_liquid |
bool |
1 |
√ |
|
null |
|
|
sanitization_chlorine_gazeous |
bool |
1 |
√ |
|
null |
|
|
sanitization_ozone |
bool |
1 |
√ |
|
null |
|
|
filtration_membrane |
bool |
1 |
√ |
|
null |
|
|
filtration_sandorgravel |
bool |
1 |
√ |
|
null |
|
|
flocculation |
bool |
1 |
√ |
|
null |
|
|
activatedcharcoal |
bool |
1 |
√ |
|
null |
|
|
settling |
bool |
1 |
√ |
|
null |
|
|
treatment_capacity |
numeric |
10,2 |
√ |
|
null |
|
|
networkseparation |
bool |
1 |
√ |
|
null |
|
|
flow_meter |
bool |
1 |
√ |
|
null |
|
|
water_meter |
bool |
1 |
√ |
|
null |
|
|
manometer |
bool |
1 |
√ |
|
null |
|
|
depth |
numeric |
10,3 |
√ |
|
null |
|
|
no_valves |
int2 |
5 |
√ |
|
null |
|
|
fk_pressurecontrol_type |
int4 |
10 |
√ |
|
null |
|
|
Analyzed at mar. mars 21 17:52 CET 2017
|