Table oc312.public.configuration Generated by
SchemaSpy
Legend:
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('configuration_id_seq'::regclass)
study_module_status.id Implied Constraint R
key varchar 255  √  null
value varchar 255  √  null
description varchar 512  √  null
version int4 10  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc pk_configuration  
key Must be unique Asc configuration_key_key This unique column is also nullable
key Performance Asc i_key_index  

Close relationships: