Table clean.public.thesaurus 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 serial 10  √  nextval('thesaurus_id_seq'::regclass)
study_module_status.id Implied Constraint R
dictionary_id int4 10  √  null
study_id int4 10  √  null
verbatim_term varchar 4000  √  null
code varchar 500  √  null
code_details varchar 2000  √  null
date_updated timestamptz 35,6  √  null
version int4 10  √  null

Table contained 0 rows at Wed Feb 01 09:18 EST 2012

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

Close relationships: