id |
int4 |
10 |
√ |
|
null |
|
|
fk_district |
int4 |
10 |
√ |
|
null |
|
|
fk_pressurezone |
int4 |
10 |
√ |
|
null |
|
|
fk_printmap |
_int4 |
10 |
√ |
|
null |
|
|
_printmaps |
text |
2147483647 |
√ |
|
null |
|
|
_geometry_alt1_used |
bool |
1 |
√ |
|
null |
|
|
_geometry_alt2_used |
bool |
1 |
√ |
|
null |
|
|
_pipe_node_type |
pipe_connection |
2147483647 |
√ |
|
null |
|
|
_pipe_orientation |
float8 |
17,17 |
√ |
|
null |
|
|
_pipe_schema_visible |
bool |
1 |
√ |
|
null |
|
|
geometry |
geometry |
2147483647 |
√ |
|
null |
|
|
geometry_alt1 |
geometry |
2147483647 |
√ |
|
null |
|
|
geometry_alt2 |
geometry |
2147483647 |
√ |
|
null |
|
|
update_geometry_alt1 |
bool |
1 |
√ |
|
null |
|
|
update_geometry_alt2 |
bool |
1 |
√ |
|
null |
|
|
identification |
varchar |
50 |
√ |
|
null |
|
|
fk_distributor |
int4 |
10 |
√ |
|
null |
|
|
fk_status |
int4 |
10 |
√ |
|
null |
|
|
fk_folder |
int4 |
10 |
√ |
|
null |
|
|
fk_locationtype |
_int4 |
10 |
√ |
|
null |
|
|
fk_precision |
int4 |
10 |
√ |
|
null |
|
|
fk_precisionalti |
int4 |
10 |
√ |
|
null |
|
|
fk_object_reference |
int4 |
10 |
√ |
|
null |
|
|
altitude |
numeric |
10,3 |
√ |
|
null |
|
|
year |
int2 |
5 |
√ |
|
null |
|
|
year_end |
int2 |
5 |
√ |
|
null |
|
|
orientation |
float8 |
17,17 |
√ |
|
null |
|
|
remark |
text |
2147483647 |
√ |
|
null |
|
|
schema_force_visible |
bool |
1 |
√ |
|
null |
|
|
label_1_visible |
int2 |
5 |
√ |
|
null |
|
|
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 |
√ |
|
null |
|
|
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 |
|
|
installation_type |
installation_type |
2147483647 |
√ |
|
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 |
|
|
status_vl_active |
bool |
1 |
√ |
|
null |
|
|
status_short_fr |
varchar |
10 |
√ |
|
null |
|
|
status_short_en |
varchar |
10 |
√ |
|
null |
|
|
status_short_ro |
varchar |
10 |
√ |
|
null |
|
|
status_value_fr |
varchar |
50 |
√ |
|
null |
|
|
status_value_en |
varchar |
50 |
√ |
|
null |
|
|
status_value_ro |
varchar |
50 |
√ |
|
null |
|
|
status_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
status_description_en |
text |
2147483647 |
√ |
|
null |
|
|
status_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
status_active |
bool |
1 |
√ |
|
null |
|
|
status_functional |
bool |
1 |
√ |
|
null |
|
|
status_code_sire |
int2 |
5 |
√ |
|
null |
|
|
watertype_vl_active |
bool |
1 |
√ |
|
null |
|
|
watertype_short_fr |
varchar |
10 |
√ |
|
null |
|
|
watertype_short_en |
varchar |
10 |
√ |
|
null |
|
|
watertype_short_ro |
varchar |
10 |
√ |
|
null |
|
|
watertype_value_fr |
varchar |
50 |
√ |
|
null |
|
|
watertype_value_en |
varchar |
50 |
√ |
|
null |
|
|
watertype_value_ro |
varchar |
50 |
√ |
|
null |
|
|
watertype_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
watertype_description_en |
text |
2147483647 |
√ |
|
null |
|
|
watertype_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
watertype_code_sire |
int2 |
5 |
√ |
|
null |
|
|
pump_type_vl_active |
bool |
1 |
√ |
|
null |
|
|
pump_type_short_fr |
varchar |
10 |
√ |
|
null |
|
|
pump_type_short_en |
varchar |
10 |
√ |
|
null |
|
|
pump_type_short_ro |
varchar |
10 |
√ |
|
null |
|
|
pump_type_value_fr |
varchar |
50 |
√ |
|
null |
|
|
pump_type_value_en |
varchar |
50 |
√ |
|
null |
|
|
pump_type_value_ro |
varchar |
50 |
√ |
|
null |
|
|
pump_type_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
pump_type_description_en |
text |
2147483647 |
√ |
|
null |
|
|
pump_type_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
pump_type_code_sire |
int2 |
5 |
√ |
|
null |
|
|
object_reference_vl_active |
bool |
1 |
√ |
|
null |
|
|
object_reference_short_fr |
varchar |
10 |
√ |
|
null |
|
|
object_reference_short_en |
varchar |
10 |
√ |
|
null |
|
|
object_reference_short_ro |
varchar |
10 |
√ |
|
null |
|
|
object_reference_value_fr |
varchar |
50 |
√ |
|
null |
|
|
object_reference_value_en |
varchar |
50 |
√ |
|
null |
|
|
object_reference_value_ro |
varchar |
50 |
√ |
|
null |
|
|
object_reference_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
object_reference_description_en |
text |
2147483647 |
√ |
|
null |
|
|
object_reference_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
cistern2_vl_active |
bool |
1 |
√ |
|
null |
|
|
cistern2_short_fr |
varchar |
10 |
√ |
|
null |
|
|
cistern2_short_en |
varchar |
10 |
√ |
|
null |
|
|
cistern2_short_ro |
varchar |
10 |
√ |
|
null |
|
|
cistern2_value_fr |
varchar |
50 |
√ |
|
null |
|
|
cistern2_value_en |
varchar |
50 |
√ |
|
null |
|
|
cistern2_value_ro |
varchar |
50 |
√ |
|
null |
|
|
cistern2_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
cistern2_description_en |
text |
2147483647 |
√ |
|
null |
|
|
cistern2_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
precision_vl_active |
bool |
1 |
√ |
|
null |
|
|
precision_short_fr |
varchar |
10 |
√ |
|
null |
|
|
precision_short_en |
varchar |
10 |
√ |
|
null |
|
|
precision_short_ro |
varchar |
10 |
√ |
|
null |
|
|
precision_value_fr |
varchar |
50 |
√ |
|
null |
|
|
precision_value_en |
varchar |
50 |
√ |
|
null |
|
|
precision_value_ro |
varchar |
50 |
√ |
|
null |
|
|
precision_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
precision_description_en |
text |
2147483647 |
√ |
|
null |
|
|
precision_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
precision_code_sire |
int2 |
5 |
√ |
|
null |
|
|
tank_firestorage_vl_active |
bool |
1 |
√ |
|
null |
|
|
tank_firestorage_short_fr |
varchar |
10 |
√ |
|
null |
|
|
tank_firestorage_short_en |
varchar |
10 |
√ |
|
null |
|
|
tank_firestorage_short_ro |
varchar |
10 |
√ |
|
null |
|
|
tank_firestorage_value_fr |
varchar |
50 |
√ |
|
null |
|
|
tank_firestorage_value_en |
varchar |
50 |
√ |
|
null |
|
|
tank_firestorage_value_ro |
varchar |
50 |
√ |
|
null |
|
|
tank_firestorage_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
tank_firestorage_description_en |
text |
2147483647 |
√ |
|
null |
|
|
tank_firestorage_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
cistern1_vl_active |
bool |
1 |
√ |
|
null |
|
|
cistern1_short_fr |
varchar |
10 |
√ |
|
null |
|
|
cistern1_short_en |
varchar |
10 |
√ |
|
null |
|
|
cistern1_short_ro |
varchar |
10 |
√ |
|
null |
|
|
cistern1_value_fr |
varchar |
50 |
√ |
|
null |
|
|
cistern1_value_en |
varchar |
50 |
√ |
|
null |
|
|
cistern1_value_ro |
varchar |
50 |
√ |
|
null |
|
|
cistern1_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
cistern1_description_en |
text |
2147483647 |
√ |
|
null |
|
|
cistern1_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
source_type_vl_active |
bool |
1 |
√ |
|
null |
|
|
source_type_short_fr |
varchar |
10 |
√ |
|
null |
|
|
source_type_short_en |
varchar |
10 |
√ |
|
null |
|
|
source_type_short_ro |
varchar |
10 |
√ |
|
null |
|
|
source_type_value_fr |
varchar |
50 |
√ |
|
null |
|
|
source_type_value_en |
varchar |
50 |
√ |
|
null |
|
|
source_type_value_ro |
varchar |
50 |
√ |
|
null |
|
|
source_type_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
source_type_description_en |
text |
2147483647 |
√ |
|
null |
|
|
source_type_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
source_type_code_sire |
int2 |
5 |
√ |
|
null |
|
|
source_quality_vl_active |
bool |
1 |
√ |
|
null |
|
|
source_quality_short_fr |
varchar |
10 |
√ |
|
null |
|
|
source_quality_short_en |
varchar |
10 |
√ |
|
null |
|
|
source_quality_short_ro |
varchar |
10 |
√ |
|
null |
|
|
source_quality_value_fr |
varchar |
50 |
√ |
|
null |
|
|
source_quality_value_en |
varchar |
50 |
√ |
|
null |
|
|
source_quality_value_ro |
varchar |
50 |
√ |
|
null |
|
|
source_quality_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
source_quality_description_en |
text |
2147483647 |
√ |
|
null |
|
|
source_quality_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
source_quality_code_sire |
int2 |
5 |
√ |
|
null |
|
|
distributor_name |
varchar |
30 |
√ |
|
null |
|
|
overflow_vl_active |
bool |
1 |
√ |
|
null |
|
|
overflow_short_fr |
varchar |
10 |
√ |
|
null |
|
|
overflow_short_en |
varchar |
10 |
√ |
|
null |
|
|
overflow_short_ro |
varchar |
10 |
√ |
|
null |
|
|
overflow_value_fr |
varchar |
50 |
√ |
|
null |
|
|
overflow_value_en |
varchar |
50 |
√ |
|
null |
|
|
overflow_value_ro |
varchar |
50 |
√ |
|
null |
|
|
overflow_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
overflow_description_en |
text |
2147483647 |
√ |
|
null |
|
|
overflow_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
pressurecontrol_type_vl_active |
bool |
1 |
√ |
|
null |
|
|
pressurecontrol_type_short_fr |
varchar |
10 |
√ |
|
null |
|
|
pressurecontrol_type_short_en |
varchar |
10 |
√ |
|
null |
|
|
pressurecontrol_type_short_ro |
varchar |
10 |
√ |
|
null |
|
|
pressurecontrol_type_value_fr |
varchar |
50 |
√ |
|
null |
|
|
pressurecontrol_type_value_en |
varchar |
50 |
√ |
|
null |
|
|
pressurecontrol_type_value_ro |
varchar |
50 |
√ |
|
null |
|
|
pressurecontrol_type_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
pressurecontrol_type_description_en |
text |
2147483647 |
√ |
|
null |
|
|
pressurecontrol_type_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
remote_vl_active |
bool |
1 |
√ |
|
null |
|
|
remote_short_fr |
varchar |
10 |
√ |
|
null |
|
|
remote_short_en |
varchar |
10 |
√ |
|
null |
|
|
remote_short_ro |
varchar |
10 |
√ |
|
null |
|
|
remote_value_fr |
varchar |
50 |
√ |
|
null |
|
|
remote_value_en |
varchar |
50 |
√ |
|
null |
|
|
remote_value_ro |
varchar |
50 |
√ |
|
null |
|
|
remote_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
remote_description_en |
text |
2147483647 |
√ |
|
null |
|
|
remote_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
district_name |
varchar |
40 |
√ |
|
null |
|
|
district_shortname |
varchar |
12 |
√ |
|
null |
|
|
district_zip |
varchar |
12 |
√ |
|
null |
|
|
district_land_registry |
varchar |
12 |
√ |
|
null |
|
|
district_prefix |
varchar |
12 |
√ |
|
null |
|
|
district_colorcode |
int2 |
5 |
√ |
|
null |
|
|
pressurezone_fk_distributor |
int4 |
10 |
√ |
|
null |
|
|
pressurezone_fk_consumptionzone |
int4 |
10 |
√ |
|
null |
|
|
pressurezone_name |
varchar |
50 |
√ |
|
null |
|
|
pressurezone_population |
int4 |
10 |
√ |
|
null |
|
|
pressurezone_subscriber |
int4 |
10 |
√ |
|
null |
|
|
pressurezone_colorcode |
int2 |
5 |
√ |
|
null |
|
|
pressurezone__geometry_alt1_used |
bool |
1 |
√ |
|
null |
|
|
pressurezone__geometry_alt2_used |
bool |
1 |
√ |
|
null |
|
|
pressurezone_update_geometry_alt1 |
bool |
1 |
√ |
|
null |
|
|
pressurezone_update_geometry_alt2 |
bool |
1 |
√ |
|
null |
|
|
folder_identification |
varchar |
50 |
√ |
|
null |
|
|
folder_description |
text |
2147483647 |
√ |
|
null |
|
|
folder_date_start |
date |
13 |
√ |
|
null |
|
|
folder_date_end |
date |
13 |
√ |
|
null |
|
|
precisionalti_vl_active |
bool |
1 |
√ |
|
null |
|
|
precisionalti_short_fr |
varchar |
10 |
√ |
|
null |
|
|
precisionalti_short_en |
varchar |
10 |
√ |
|
null |
|
|
precisionalti_short_ro |
varchar |
10 |
√ |
|
null |
|
|
precisionalti_value_fr |
varchar |
50 |
√ |
|
null |
|
|
precisionalti_value_en |
varchar |
50 |
√ |
|
null |
|
|
precisionalti_value_ro |
varchar |
50 |
√ |
|
null |
|
|
precisionalti_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
precisionalti_description_en |
text |
2147483647 |
√ |
|
null |
|
|
precisionalti_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
precisionalti_code_sire |
int2 |
5 |
√ |
|
null |
|
|
pump_operating_vl_active |
bool |
1 |
√ |
|
null |
|
|
pump_operating_short_fr |
varchar |
10 |
√ |
|
null |
|
|
pump_operating_short_en |
varchar |
10 |
√ |
|
null |
|
|
pump_operating_short_ro |
varchar |
10 |
√ |
|
null |
|
|
pump_operating_value_fr |
varchar |
50 |
√ |
|
null |
|
|
pump_operating_value_en |
varchar |
50 |
√ |
|
null |
|
|
pump_operating_value_ro |
varchar |
50 |
√ |
|
null |
|
|
pump_operating_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
pump_operating_description_en |
text |
2147483647 |
√ |
|
null |
|
|
pump_operating_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
pump_operating_code_sire |
int2 |
5 |
√ |
|
null |
|
|