Table qwat.qwat_vl.status
Status table, with SIRE id.

 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
network_element.fk_status element_fk_status R
pipe.fk_status pipe_fk_status R
remote.fk_status remote_fk_status R
valve.fk_status valve_fk_status R
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
active bool 1  √  true
functional bool 1  √  true
code_sire int2 5  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc vl_status_pk

Close relationships  within of separation: