id |
int4 |
10 |
√ |
|
null |
|
|
fk_cause |
int4 |
10 |
√ |
|
null |
|
|
fk_pipe |
int4 |
10 |
√ |
|
null |
|
|
widespread_damage |
bool |
1 |
√ |
|
null |
|
|
detection_date |
date |
13 |
√ |
|
null |
|
|
repair_date |
date |
13 |
√ |
|
null |
|
|
_repaired |
bool |
1 |
√ |
|
null |
|
|
address |
text |
2147483647 |
√ |
|
null |
|
|
pipe_replaced |
bool |
1 |
√ |
|
null |
|
|
description |
text |
2147483647 |
√ |
|
null |
|
|
repair |
text |
2147483647 |
√ |
|
null |
|
|
geometry |
geometry |
2147483647 |
√ |
|
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 |
|
|
pipe_fk_parent |
int4 |
10 |
√ |
|
null |
|
|
pipe_fk_function |
int4 |
10 |
√ |
|
null |
|
|
pipe_fk_installmethod |
int4 |
10 |
√ |
|
null |
|
|
pipe_fk_material |
int4 |
10 |
√ |
|
null |
|
|
pipe_fk_distributor |
int4 |
10 |
√ |
|
null |
|
|
pipe_fk_precision |
int4 |
10 |
√ |
|
null |
|
|
pipe_fk_bedding |
int4 |
10 |
√ |
|
null |
|
|
pipe_fk_protection |
int4 |
10 |
√ |
|
null |
|
|
pipe_fk_status |
int4 |
10 |
√ |
|
null |
|
|
pipe_fk_watertype |
int4 |
10 |
√ |
|
null |
|
|
pipe_fk_locationtype |
_int4 |
10 |
√ |
|
null |
|
|
pipe_fk_folder |
int4 |
10 |
√ |
|
null |
|
|
pipe_year |
int2 |
5 |
√ |
|
null |
|
|
pipe_year_rehabilitation |
int2 |
5 |
√ |
|
null |
|
|
pipe_year_end |
int2 |
5 |
√ |
|
null |
|
|
pipe_tunnel_or_bridge |
bool |
1 |
√ |
|
null |
|
|
pipe_pressure_nominal |
int2 |
5 |
√ |
|
null |
|
|
pipe_remark |
text |
2147483647 |
√ |
|
null |
|
|
pipe__valve_count |
int2 |
5 |
√ |
|
null |
|
|
pipe__valve_closed |
bool |
1 |
√ |
|
null |
|
|
pipe_schema_force_visible |
bool |
1 |
√ |
|
null |
|
|
pipe_fk_node_a |
int4 |
10 |
√ |
|
null |
|
|
pipe_fk_node_b |
int4 |
10 |
√ |
|
null |
|
|
pipe_fk_district |
int4 |
10 |
√ |
|
null |
|
|
pipe_fk_pressurezone |
int4 |
10 |
√ |
|
null |
|
|
pipe_fk_printmap |
_int4 |
10 |
√ |
|
null |
|
|
pipe__length2d |
numeric |
8,2 |
√ |
|
null |
|
|
pipe__length3d |
numeric |
8,2 |
√ |
|
null |
|
|
pipe__diff_elevation |
numeric |
8,2 |
√ |
|
null |
|
|
pipe__printmaps |
varchar |
100 |
√ |
|
null |
|
|
pipe__geometry_alt1_used |
bool |
1 |
√ |
|
null |
|
|
pipe__geometry_alt2_used |
bool |
1 |
√ |
|
null |
|
|
pipe_update_geometry_alt1 |
bool |
1 |
√ |
|
null |
|
|
pipe_update_geometry_alt2 |
bool |
1 |
√ |
|
null |
|
|
pipe_status_vl_active |
bool |
1 |
√ |
|
null |
|
|
pipe_status_short_fr |
varchar |
10 |
√ |
|
null |
|
|
pipe_status_short_en |
varchar |
10 |
√ |
|
null |
|
|
pipe_status_short_ro |
varchar |
10 |
√ |
|
null |
|
|
pipe_status_value_fr |
varchar |
50 |
√ |
|
null |
|
|
pipe_status_value_en |
varchar |
50 |
√ |
|
null |
|
|
pipe_status_value_ro |
varchar |
50 |
√ |
|
null |
|
|
pipe_status_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
pipe_status_description_en |
text |
2147483647 |
√ |
|
null |
|
|
pipe_status_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
pipe_status_active |
bool |
1 |
√ |
|
null |
|
|
pipe_status_functional |
bool |
1 |
√ |
|
null |
|
|
pipe_status_code_sire |
int2 |
5 |
√ |
|
null |
|
|
pipe_function_vl_active |
bool |
1 |
√ |
|
null |
|
|
pipe_function_short_fr |
varchar |
10 |
√ |
|
null |
|
|
pipe_function_short_en |
varchar |
10 |
√ |
|
null |
|
|
pipe_function_short_ro |
varchar |
10 |
√ |
|
null |
|
|
pipe_function_value_fr |
varchar |
50 |
√ |
|
null |
|
|
pipe_function_value_en |
varchar |
50 |
√ |
|
null |
|
|
pipe_function_value_ro |
varchar |
50 |
√ |
|
null |
|
|
pipe_function_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
pipe_function_description_en |
text |
2147483647 |
√ |
|
null |
|
|
pipe_function_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
pipe_function_schema_visible |
bool |
1 |
√ |
|
null |
|
|
pipe_function_major |
bool |
1 |
√ |
|
null |
|
|
pipe_function_code_sire |
int2 |
5 |
√ |
|
null |
|
|
pipe_installmethod_vl_active |
bool |
1 |
√ |
|
null |
|
|
pipe_installmethod_short_fr |
varchar |
10 |
√ |
|
null |
|
|
pipe_installmethod_short_en |
varchar |
10 |
√ |
|
null |
|
|
pipe_installmethod_short_ro |
varchar |
10 |
√ |
|
null |
|
|
pipe_installmethod_value_fr |
varchar |
50 |
√ |
|
null |
|
|
pipe_installmethod_value_en |
varchar |
50 |
√ |
|
null |
|
|
pipe_installmethod_value_ro |
varchar |
50 |
√ |
|
null |
|
|
pipe_installmethod_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
pipe_installmethod_description_en |
text |
2147483647 |
√ |
|
null |
|
|
pipe_installmethod_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
pipe_district_name |
varchar |
40 |
√ |
|
null |
|
|
pipe_district_shortname |
varchar |
12 |
√ |
|
null |
|
|
pipe_district_zip |
varchar |
12 |
√ |
|
null |
|
|
pipe_district_land_registry |
varchar |
12 |
√ |
|
null |
|
|
pipe_district_prefix |
varchar |
12 |
√ |
|
null |
|
|
pipe_district_colorcode |
int2 |
5 |
√ |
|
null |
|
|
pipe_pressurezone_fk_distributor |
int4 |
10 |
√ |
|
null |
|
|
pipe_pressurezone_fk_consumptionzone |
int4 |
10 |
√ |
|
null |
|
|
pipe_pressurezone_name |
varchar |
50 |
√ |
|
null |
|
|
pipe_pressurezone_population |
int4 |
10 |
√ |
|
null |
|
|
pipe_pressurezone_subscriber |
int4 |
10 |
√ |
|
null |
|
|
pipe_pressurezone_colorcode |
int2 |
5 |
√ |
|
null |
|
|
pipe_pressurezone__geometry_alt1_used |
bool |
1 |
√ |
|
null |
|
|
pipe_pressurezone__geometry_alt2_used |
bool |
1 |
√ |
|
null |
|
|
pipe_pressurezone_update_geometry_alt1 |
bool |
1 |
√ |
|
null |
|
|
pipe_pressurezone_update_geometry_alt2 |
bool |
1 |
√ |
|
null |
|
|
pipe_material_vl_active |
bool |
1 |
√ |
|
null |
|
|
pipe_material_short_fr |
varchar |
10 |
√ |
|
null |
|
|
pipe_material_short_en |
varchar |
10 |
√ |
|
null |
|
|
pipe_material_short_ro |
varchar |
10 |
√ |
|
null |
|
|
pipe_material_value_fr |
varchar |
50 |
√ |
|
null |
|
|
pipe_material_value_en |
varchar |
50 |
√ |
|
null |
|
|
pipe_material_value_ro |
varchar |
50 |
√ |
|
null |
|
|
pipe_material_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
pipe_material_description_en |
text |
2147483647 |
√ |
|
null |
|
|
pipe_material_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
pipe_material__displayname_fr |
varchar |
30 |
√ |
|
null |
|
|
pipe_material__displayname_en |
varchar |
30 |
√ |
|
null |
|
|
pipe_material__displayname_ro |
varchar |
30 |
√ |
|
null |
|
|
pipe_material_diameter |
varchar |
10 |
√ |
|
null |
|
|
pipe_material_diameter_nominal |
int2 |
5 |
√ |
|
null |
|
|
pipe_material_diameter_internal |
numeric |
7,3 |
√ |
|
null |
|
|
pipe_material_diameter_external |
numeric |
7,3 |
√ |
|
null |
|
|
pipe_material_code_sire |
int2 |
5 |
√ |
|
null |
|
|
pipe_material_pressure_nominal |
float8 |
17,17 |
√ |
|
null |
|
|
pipe_material_sdr |
float8 |
17,17 |
√ |
|
null |
|
|
pipe_material_wall_thickness |
numeric |
4,1 |
√ |
|
null |
|
|
pipe_material_sn |
int4 |
10 |
√ |
|
null |
|
|
pipe_precision_vl_active |
bool |
1 |
√ |
|
null |
|
|
pipe_precision_short_fr |
varchar |
10 |
√ |
|
null |
|
|
pipe_precision_short_en |
varchar |
10 |
√ |
|
null |
|
|
pipe_precision_short_ro |
varchar |
10 |
√ |
|
null |
|
|
pipe_precision_value_fr |
varchar |
50 |
√ |
|
null |
|
|
pipe_precision_value_en |
varchar |
50 |
√ |
|
null |
|
|
pipe_precision_value_ro |
varchar |
50 |
√ |
|
null |
|
|
pipe_precision_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
pipe_precision_description_en |
text |
2147483647 |
√ |
|
null |
|
|
pipe_precision_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
pipe_precision_code_sire |
int2 |
5 |
√ |
|
null |
|
|
pipe_protection_vl_active |
bool |
1 |
√ |
|
null |
|
|
pipe_protection_short_fr |
varchar |
10 |
√ |
|
null |
|
|
pipe_protection_short_en |
varchar |
10 |
√ |
|
null |
|
|
pipe_protection_short_ro |
varchar |
10 |
√ |
|
null |
|
|
pipe_protection_value_fr |
varchar |
50 |
√ |
|
null |
|
|
pipe_protection_value_en |
varchar |
50 |
√ |
|
null |
|
|
pipe_protection_value_ro |
varchar |
50 |
√ |
|
null |
|
|
pipe_protection_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
pipe_protection_description_en |
text |
2147483647 |
√ |
|
null |
|
|
pipe_protection_description_ro |
text |
2147483647 |
√ |
|
null |
|
|
pipe_distributor_name |
varchar |
30 |
√ |
|
null |
|
|
pipe_folder_identification |
varchar |
50 |
√ |
|
null |
|
|
pipe_folder_description |
text |
2147483647 |
√ |
|
null |
|
|
pipe_folder_date_start |
date |
13 |
√ |
|
null |
|
|
pipe_folder_date_end |
date |
13 |
√ |
|
null |
|
|
pipe_node_b_fk_district |
int4 |
10 |
√ |
|
null |
|
|
pipe_node_b_fk_pressurezone |
int4 |
10 |
√ |
|
null |
|
|
pipe_node_b_fk_printmap |
_int4 |
10 |
√ |
|
null |
|
|
pipe_node_b__printmaps |
text |
2147483647 |
√ |
|
null |
|
|
pipe_node_b__geometry_alt1_used |
bool |
1 |
√ |
|
null |
|
|
pipe_node_b__geometry_alt2_used |
bool |
1 |
√ |
|
null |
|
|
pipe_node_b__pipe_node_type |
pipe_connection |
2147483647 |
√ |
|
null |
|
|
pipe_node_b__pipe_orientation |
float8 |
17,17 |
√ |
|
null |
|
|
pipe_node_b__pipe_schema_visible |
bool |
1 |
√ |
|
null |
|
|
pipe_node_b_update_geometry_alt1 |
bool |
1 |
√ |
|
null |
|
|
pipe_node_b_update_geometry_alt2 |
bool |
1 |
√ |
|
null |
|
|
pipe_node_a_fk_district |
int4 |
10 |
√ |
|
null |
|
|
pipe_node_a_fk_pressurezone |
int4 |
10 |
√ |
|
null |
|
|
pipe_node_a_fk_printmap |
_int4 |
10 |
√ |
|
null |
|
|
pipe_node_a__printmaps |
text |
2147483647 |
√ |
|
null |
|
|
pipe_node_a__geometry_alt1_used |
bool |
1 |
√ |
|
null |
|
|
pipe_node_a__geometry_alt2_used |
bool |
1 |
√ |
|
null |
|
|
pipe_node_a__pipe_node_type |
pipe_connection |
2147483647 |
√ |
|
null |
|
|
pipe_node_a__pipe_orientation |
float8 |
17,17 |
√ |
|
null |
|
|
pipe_node_a__pipe_schema_visible |
bool |
1 |
√ |
|
null |
|
|
pipe_node_a_update_geometry_alt1 |
bool |
1 |
√ |
|
null |
|
|
pipe_node_a_update_geometry_alt2 |
bool |
1 |
√ |
|
null |
|
|
cause_vl_active |
bool |
1 |
√ |
|
null |
|
|
cause_short_fr |
varchar |
10 |
√ |
|
null |
|
|
cause_short_en |
varchar |
10 |
√ |
|
null |
|
|
cause_short_ro |
varchar |
10 |
√ |
|
null |
|
|
cause_value_fr |
varchar |
50 |
√ |
|
null |
|
|
cause_value_en |
varchar |
50 |
√ |
|
null |
|
|
cause_value_ro |
varchar |
50 |
√ |
|
null |
|
|
cause_description_fr |
text |
2147483647 |
√ |
|
null |
|
|
cause_description_en |
text |
2147483647 |
√ |
|
null |
|
|
cause_description_ro |
text |
2147483647 |
√ |
|
null |
|
|