Table qwat.qwat_od.pipe
Table for pipes.

 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 serial 10  √  nextval('qwat_od.pipe_id_seq'::regclass)
crossing._pipe1_id crossing_pipe1 R
crossing._pipe2_id crossing_pipe2 R
leak.fk_pipe leak_fk_pipe R
meter.fk_pipe meter_fk_pipe R
part.fk_pipe part_fk_pipe R
pipe.fk_parent pipe_fk_parent R
pump.fk_pipe_in pump_fk_pipe_in R
pump.fk_pipe_out pump_fk_pipe_out R
subscriber.fk_pipe subscriber_fk_pipe R
valve.fk_pipe valve_fk_pipe R
fk_parent int4 10  √  null
pipe.id pipe_fk_parent R
fk_function int4 10
pipe_function.id pipe_fk_function R
fk_installmethod int4 10
pipe_installmethod.id pipe_fk_installmethod R
fk_material int4 10
pipe_material.id pipe_fk_material R
fk_distributor int4 10
distributor.id pipe_fk_distributor R
fk_precision int4 10
precision.id pipe_fk_precision R
fk_bedding int4 10
bedding.id pipe_fk_bedding R
fk_protection int4 10  √  null
pipe_protection.id pipe_fk_protection R
fk_status int4 10
status.id pipe_fk_status R
fk_watertype int4 10
watertype.id pipe_fk_watertype R
fk_locationtype _int4 10  √  null
fk_folder int4 10  √  null
folder.id pipe_fk_folder R
year int2 5  √  null
year_rehabilitation int2 5  √  null
year_end int2 5  √  null
tunnel_or_bridge bool 1  √  false
pressure_nominal int2 5  √  16
remark text 2147483647  √  null
_valve_count int2 5  √  null
_valve_closed bool 1  √  null
schema_force_visible bool 1  √  null
visible.vl_code pipe_schema_force_visible R
label_1_visible int2 5  √  1
visible.vl_code_int pipe_label_1_visible R
label_1_text varchar 120  √  null
label_2_visible int2 5  √  1
visible.vl_code_int pipe_label_2_visible R
label_2_text varchar 120  √  null
fk_node_a int4 10
node.id pipe_fk_node_a R
fk_node_b int4 10
node.id pipe_fk_node_b R
fk_district int4 10  √  null
district.id pipe_fk_district R
fk_pressurezone int4 10  √  null
pressurezone.id pipe_fk_pressurezone R
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
geometry_alt1 geometry 2147483647  √  null
geometry_alt2 geometry 2147483647  √  null

Table contained 4 223 rows at mar. mars 21 17:52 CET 2017

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc pipe_pkey
fk_bedding Performance Asc fki_pipe_fk_bedding
fk_distributor Performance Asc fki_pipe_fk_distributor
fk_district Performance Asc fki_pipe_fk_district
fk_folder Performance Asc fki_pipe_fk_folder
fk_function Performance Asc fki_pipe_fk_function
fk_installmethod Performance Asc fki_pipe_fk_installmethod
fk_material Performance Asc fki_pipe_fk_material
fk_node_a Performance Asc fki_pipe_fk_node_a
fk_node_b Performance Asc fki_pipe_fk_node_b
fk_parent Performance Asc fki_pipe_fk_parent
fk_precision Performance Asc fki_pipe_fk_precision
fk_pressurezone Performance Asc fki_pipe_fk_pressurezone
fk_protection Performance Asc fki_pipe_fk_protection
fk_status Performance Asc fki_pipe_fk_status
fk_watertype Performance Asc fki_pipe_fk_watertype
label_1_visible Performance Asc fki_pipe_label_1_visible
label_2_visible Performance Asc fki_pipe_label_2_visible
schema_force_visible Performance Asc fki_pipe_schema_force_visible
geometry Performance Asc pipe_geoidx
geometry_alt1 Performance Asc pipe_geoidx_alt1
geometry_alt2 Performance Asc pipe_geoidx_alt2

Close relationships  within of separation: