View qwat.qwat_od.vw_export_leak Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
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

Analyzed at mar. mars 21 17:52 CET 2017