Table qwat.qwat_vl.visible
Table for editing in qgis tri state boolean (NULL/True/False) by using value relation.

 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
vl_active bool 1  √  true
short_fr varchar 10  √  null
short_en varchar 10  √  null
short_ro varchar 10  √  null
value_fr varchar 50  √  null
value_en varchar 50  √  null
value_ro varchar 50  √  null
description_fr text 2147483647  √  null
description_en text 2147483647  √  null
description_ro text 2147483647  √  null
vl_code bool 1  √  null
network_element.schema_force_visible network_element_schema_force_visible R
pipe.schema_force_visible pipe_schema_force_visible R
valve.schema_force_visible valve_schema_force_visible R
vl_code_int int2 5  √  null
cover.label_1_visible cover_label_1_visible R
cover.label_2_visible cover_label_2_visible R
district.label_1_visible district_label_1_visible R
district.label_2_visible district_label_2_visible R
leak.label_1_visible leak_label_1_visible R
leak.label_2_visible leak_label_2_visible R
network_element.label_1_visible network_element_label_1_visible R
network_element.label_2_visible network_element_label_2_visible R
pipe.label_1_visible pipe_label_1_visible R
pipe.label_2_visible pipe_label_2_visible R
pressurezone.label_1_visible pressurezone_label_1_visible R
pressurezone.label_2_visible pressurezone_label_2_visible R
printmap.label_1_visible printmap_label_1_visible R
printmap.label_2_visible printmap_label_2_visible R
remote.label_1_visible remote_label_1_visible R
remote.label_2_visible remote_label_2_visible R
valve.label_1_visible valve_label_1_visible R
valve.label_2_visible valve_label_2_visible R

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc vl_visible_pk  
vl_code Must be unique Asc visible_code This unique column is also nullable
vl_code_int Must be unique Asc visible_code_int This unique column is also nullable

Close relationships  within of separation: