id |
int4 |
10 |
√ |
|
null |
|
|
fk_parent |
int4 |
10 |
√ |
|
null |
|
|
fk_function |
int4 |
10 |
√ |
|
null |
|
|
fk_installmethod |
int4 |
10 |
√ |
|
null |
|
|
fk_material |
int4 |
10 |
√ |
|
null |
|
|
fk_distributor |
int4 |
10 |
√ |
|
null |
|
|
fk_precision |
int4 |
10 |
√ |
|
null |
|
|
fk_bedding |
int4 |
10 |
√ |
|
null |
|
|
fk_protection |
int4 |
10 |
√ |
|
null |
|
|
fk_status |
int4 |
10 |
√ |
|
null |
|
|
fk_watertype |
int4 |
10 |
√ |
|
null |
|
|
fk_locationtype |
_int4 |
10 |
√ |
|
null |
|
|
fk_folder |
int4 |
10 |
√ |
|
null |
|
|
year |
int2 |
5 |
√ |
|
null |
|
|
year_rehabilitation |
int2 |
5 |
√ |
|
null |
|
|
year_end |
int2 |
5 |
√ |
|
null |
|
|
tunnel_or_bridge |
bool |
1 |
√ |
|
null |
|
|
pressure_nominal |
int2 |
5 |
√ |
|
null |
|
|
remark |
text |
2147483647 |
√ |
|
null |
|
|
_valve_count |
int2 |
5 |
√ |
|
null |
|
|
_valve_closed |
bool |
1 |
√ |
|
null |
|
|
schema_force_visible |
bool |
1 |
√ |
|
null |
|
|
label_1_visible |
int2 |
5 |
√ |
|
null |
|
|
label_1_text |
varchar |
120 |
√ |
|
null |
|
|
label_2_visible |
int2 |
5 |
√ |
|
null |
|
|
label_2_text |
varchar |
120 |
√ |
|
null |
|
|
fk_node_a |
int4 |
10 |
√ |
|
null |
|
|
fk_node_b |
int4 |
10 |
√ |
|
null |
|
|
fk_district |
int4 |
10 |
√ |
|
null |
|
|
fk_pressurezone |
int4 |
10 |
√ |
|
null |
|
|
fk_printmap |
_int4 |
10 |
√ |
|
null |
|
|
_length2d |
numeric |
8,2 |
√ |
|
null |
|
|
_length3d |
numeric |
8,2 |
√ |
|
null |
|
|
_diff_elevation |
numeric |
8,2 |
√ |
|
null |
|
|
_printmaps |
varchar |
100 |
√ |
|
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 |
|
|
geometry |
geometry |
2147483647 |
√ |
|
null |
|
|
geometry_alt1 |
geometry |
2147483647 |
√ |
|
null |
|
|
geometry_alt2 |
geometry |
2147483647 |
√ |
|
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 |
|
|
function_vl_active |
bool |
1 |
√ |
|
null |
|
|
function_short_fr |
varchar |
10 |
√ |
|
null |
|
|
function_short_en |
varchar |
10 |
√ |
|
null |
|
|
function_short_ro |
varchar |
10 |
√ |
|
null |
|
|
function_value_fr |
varchar |
50 |
√ |
|
null |
|
|
function_value_en |
varchar |
50 |
√ |
|
null |
|
|
function_value_ro |
varchar |
50 |
√ |
|
null |
|
|
function_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
function_description_en |
text |
2147483647 |
√ |
|
null |
|
|
function_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
function_schema_visible |
bool |
1 |
√ |
|
null |
|
|
function_major |
bool |
1 |
√ |
|
null |
|
|
function_code_sire |
int2 |
5 |
√ |
|
null |
|
|
installmethod_vl_active |
bool |
1 |
√ |
|
null |
|
|
installmethod_short_fr |
varchar |
10 |
√ |
|
null |
|
|
installmethod_short_en |
varchar |
10 |
√ |
|
null |
|
|
installmethod_short_ro |
varchar |
10 |
√ |
|
null |
|
|
installmethod_value_fr |
varchar |
50 |
√ |
|
null |
|
|
installmethod_value_en |
varchar |
50 |
√ |
|
null |
|
|
installmethod_value_ro |
varchar |
50 |
√ |
|
null |
|
|
installmethod_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
installmethod_description_en |
text |
2147483647 |
√ |
|
null |
|
|
installmethod_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 |
|
|
material_vl_active |
bool |
1 |
√ |
|
null |
|
|
material_short_fr |
varchar |
10 |
√ |
|
null |
|
|
material_short_en |
varchar |
10 |
√ |
|
null |
|
|
material_short_ro |
varchar |
10 |
√ |
|
null |
|
|
material_value_fr |
varchar |
50 |
√ |
|
null |
|
|
material_value_en |
varchar |
50 |
√ |
|
null |
|
|
material_value_ro |
varchar |
50 |
√ |
|
null |
|
|
material_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
material_description_en |
text |
2147483647 |
√ |
|
null |
|
|
material_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
material__displayname_fr |
varchar |
30 |
√ |
|
null |
|
|
material__displayname_en |
varchar |
30 |
√ |
|
null |
|
|
material__displayname_ro |
varchar |
30 |
√ |
|
null |
|
|
material_diameter |
varchar |
10 |
√ |
|
null |
|
|
material_diameter_nominal |
int2 |
5 |
√ |
|
null |
|
|
material_diameter_internal |
numeric |
7,3 |
√ |
|
null |
|
|
material_diameter_external |
numeric |
7,3 |
√ |
|
null |
|
|
material_code_sire |
int2 |
5 |
√ |
|
null |
|
|
material_pressure_nominal |
float8 |
17,17 |
√ |
|
null |
|
|
material_sdr |
float8 |
17,17 |
√ |
|
null |
|
|
material_wall_thickness |
numeric |
4,1 |
√ |
|
null |
|
|
material_sn |
int4 |
10 |
√ |
|
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 |
|
|
protection_vl_active |
bool |
1 |
√ |
|
null |
|
|
protection_short_fr |
varchar |
10 |
√ |
|
null |
|
|
protection_short_en |
varchar |
10 |
√ |
|
null |
|
|
protection_short_ro |
varchar |
10 |
√ |
|
null |
|
|
protection_value_fr |
varchar |
50 |
√ |
|
null |
|
|
protection_value_en |
varchar |
50 |
√ |
|
null |
|
|
protection_value_ro |
varchar |
50 |
√ |
|
null |
|
|
protection_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
protection_description_en |
text |
2147483647 |
√ |
|
null |
|
|
protection_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
distributor_name |
varchar |
30 |
√ |
|
null |
|
|
folder_identification |
varchar |
50 |
√ |
|
null |
|
|
folder_description |
text |
2147483647 |
√ |
|
null |
|
|
folder_date_start |
date |
13 |
√ |
|
null |
|
|
folder_date_end |
date |
13 |
√ |
|
null |
|
|
node_b_fk_district |
int4 |
10 |
√ |
|
null |
|
|
node_b_fk_pressurezone |
int4 |
10 |
√ |
|
null |
|
|
node_b_fk_printmap |
_int4 |
10 |
√ |
|
null |
|
|
node_b__printmaps |
text |
2147483647 |
√ |
|
null |
|
|
node_b__geometry_alt1_used |
bool |
1 |
√ |
|
null |
|
|
node_b__geometry_alt2_used |
bool |
1 |
√ |
|
null |
|
|
node_b__pipe_node_type |
pipe_connection |
2147483647 |
√ |
|
null |
|
|
node_b__pipe_orientation |
float8 |
17,17 |
√ |
|
null |
|
|
node_b__pipe_schema_visible |
bool |
1 |
√ |
|
null |
|
|
node_b_update_geometry_alt1 |
bool |
1 |
√ |
|
null |
|
|
node_b_update_geometry_alt2 |
bool |
1 |
√ |
|
null |
|
|
node_a_fk_district |
int4 |
10 |
√ |
|
null |
|
|
node_a_fk_pressurezone |
int4 |
10 |
√ |
|
null |
|
|
node_a_fk_printmap |
_int4 |
10 |
√ |
|
null |
|
|
node_a__printmaps |
text |
2147483647 |
√ |
|
null |
|
|
node_a__geometry_alt1_used |
bool |
1 |
√ |
|
null |
|
|
node_a__geometry_alt2_used |
bool |
1 |
√ |
|
null |
|
|
node_a__pipe_node_type |
pipe_connection |
2147483647 |
√ |
|
null |
|
|
node_a__pipe_orientation |
float8 |
17,17 |
√ |
|
null |
|
|
node_a__pipe_schema_visible |
bool |
1 |
√ |
|
null |
|
|
node_a_update_geometry_alt1 |
bool |
1 |
√ |
|
null |
|
|
node_a_update_geometry_alt2 |
bool |
1 |
√ |
|
null |
|
|