Table qwat.qwat_vl.watertype
Water type table, with SIRE code.

 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
installation.fk_watertype installation_fk_watertype R
pipe.fk_watertype pipe_fk_watertype 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
code_sire int2 5  √  null

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

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

Close relationships  within of separation: