Table oc312.public.filter 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
filter_id serial 10  √  nextval('filter_filter_id_seq'::regclass)
dataset_filter_map.filter_id fk_dataset_reference_filter R
filter_crf_version_map.filter_id fk_filter_c_reference_filter R
name varchar 255  √  null
description varchar 2000  √  null
sql_statement varchar 4000  √  null
status_id int4 10  √  null
status.status_id fk_filter_fk_query__status R
date_created date 13  √  null
date_updated date 13  √  null
owner_id int4 10
user_account.user_id fk_filter_fk_query__user_acc R
update_id int4 10  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
filter_id Primary key Asc pk_filter

Close relationships  within of separation: