Table qwat.qwat_od.valve
Table for valve.

 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.valve_id_seq'::regclass)
fk_valve_type int4 10
valve_type.id valve_fk_type R
fk_valve_function int4 10
valve_function.id valve_fk_function R
fk_valve_actuation int4 10
valve_actuation.id valve_fk_valve_actuation R
fk_pipe int4 10  √  null
pipe.id valve_fk_pipe R
fk_handle_precision int4 10  √  null
precision.id valve_fk_handle_precision R
fk_handle_precisionalti int4 10  √  null
precisionalti.id valve_fk_handle_precisionalti R
fk_maintenance _int4 10  √  null
diameter_nominal varchar 10  √  null
closed bool 1  √  false
networkseparation bool 1  √  false
handle_altitude numeric 10,3  √  null
handle_geometry geometry 2147483647  √  null
fk_district int4 10  √  null
district.id valve_fk_district R
fk_pressurezone int4 10  √  null
pressurezone.id valve_fk_pressurezone R
fk_distributor int4 10
distributor.id valve_fk_distributor R
fk_precision int4 10
precision.id valve_fk_precision R
fk_precisionalti int4 10  √  null
precisionalti.id valve_fk_precisionalti R
fk_status int4 10
status.id valve_fk_status R
fk_object_reference int4 10  √  null
object_reference.id valve_fk_object_reference R
fk_folder int4 10  √  null
folder.id valve_fk_folder R
year int2 5  √  null
year_end int2 5  √  null
altitude numeric 10,3  √  NULL::numeric
orientation float8 17,17  √  null
fk_locationtype _int4 10  √  null
identification varchar 50  √  null
remark text 2147483647  √  null
fk_printmap _int4 10  √  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  √  0
_pipe_schema_visible bool 1  √  false
_printmaps text 2147483647  √  null
geometry geometry 2147483647
geometry_alt1 geometry 2147483647  √  null
geometry_alt2 geometry 2147483647  √  null
update_geometry_alt1 bool 1  √  null
update_geometry_alt2 bool 1  √  null
schema_force_visible bool 1  √  null
visible.vl_code valve_schema_force_visible R
label_1_visible int2 5  √  1
visible.vl_code_int valve_label_1_visible R
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  √  1
visible.vl_code_int valve_label_2_visible R
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

Table contained 2 312 rows at mar. mars 21 17:52 CET 2017

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc valve_pkey
fk_distributor Performance Asc fki_valve_fk_distributor
fk_district Performance Asc fki_valve_fk_district
fk_folder Performance Asc fki_valve_fk_folder
fk_valve_function Performance Asc fki_valve_fk_function
fk_handle_precision Performance Asc fki_valve_fk_handle_precision
fk_handle_precisionalti Performance Asc fki_valve_fk_handle_precisionalti
fk_object_reference Performance Asc fki_valve_fk_object_reference
fk_pipe Performance Asc fki_valve_fk_pipe
fk_precision Performance Asc fki_valve_fk_precision
fk_precisionalti Performance Asc fki_valve_fk_precisionalti
fk_pressurezone Performance Asc fki_valve_fk_pressurezone
fk_status Performance Asc fki_valve_fk_status
fk_valve_type Performance Asc fki_valve_fk_type
fk_valve_actuation Performance Asc fki_valve_fk_valve_actuation
label_1_visible Performance Asc fki_valve_label_1_visible
label_2_visible Performance Asc fki_valve_label_2_visible
schema_force_visible Performance Asc fki_valve_schema_force_visible
geometry Performance Asc valve_geoidx
geometry_alt1 Performance Asc valve_geoidx_alt1
geometry_alt2 Performance Asc valve_geoidx_alt2

Close relationships  within of separation: