Table oc312.public.item 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
item_id serial 10  √  nextval('item_item_id_seq'::regclass)
dc_primitive.dynamic_value_item_id fk_dc_primi_fk_dc_pri_item R
dc_primitive.item_id fk_dc_primi_fk_item_i_item R
dc_substitution_event.item_id fk_dc_subst_fk_dc_sub_item R
dc_summary_item_map.item_id fk_dc_summa_fk_dc_sum_item R
item_data.item_id fk_answer_reference_item R
item_form_metadata.item_id fk_item_id R
item_group_metadata.item_id fk_item R
versioning_map.item_id fk_versioni_fk_versio_item R
name varchar 255  √  null
description varchar 4000  √  null
units varchar 64  √  null
phi_status bool 1  √  null
item_data_type_id int4 10  √  null
item_data_type.item_data_type_id fk_item_fk_item_i_item_dat R
item_reference_type_id int4 10  √  null
item_reference_type.item_reference_type_id fk_item_fk_item_f_item_ref R
status_id int4 10  √  null
status.status_id fk_item_fk_item_s_status R
owner_id int4 10  √  null
user_account.user_id fk_item_fk_item_u_user_acc R
date_created date 13  √  null
date_updated date 13  √  null
update_id int4 10  √  null
oc_oid varchar 40

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
item_id Primary key Asc pk_item
item_data_type_id Performance Asc i_item_item_data_type_id
item_reference_type_id Performance Asc i_item_item_reference_type_id
name Performance Asc i_item_name
oc_oid Performance Asc i_item_oc_oid
units Performance Asc i_item_units
oc_oid Must be unique Asc uniq_item_oc_oid

Close relationships  within of separation: