Table qwat.qwat_vl.value_list_base
Master tables for value lists. It will be inherited by value list tables. This table shall not be filled. Be warned that value list table shal have its own unique index on id since PG does not propagate indexes. Therefore unicity of id cannot be garanteed over all value lists.

 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

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

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