Table oc312.public.section 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
section_id serial 10  √  nextval('section_section_id_seq'::regclass)
item_form_metadata.section_id fk_sec_id R
crf_version_id int4 10
crf_version.crf_version_id fk_section_version R
status_id int4 10  √  null
status.status_id fk_section_fk_sectio_status R
label varchar 2000  √  null
title varchar 2000  √  null
subtitle varchar 2000  √  null
instructions varchar 2000  √  null
page_number_label varchar 5  √  null
ordinal int4 10  √  null
parent_id int4 10  √  null
date_created date 13  √  null
date_updated date 13  √  null
owner_id int4 10
user_account.user_id fk_section_fk_sectio_user_acc R
update_id int4 10  √  null
borders int4 10  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
section_id Primary key Asc pk_section
ordinal Performance Asc i_section_ordinal
parent_id Performance Asc i_section_parent_id
status_id Performance Asc i_section_status_id

Close relationships  within of separation: