Table clean.public.item Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
item_id serial 10  √  nextval('item_item_id_seq'::regclass)
dc_primitive
dc_primitive
dc_substitution_event
dc_summary_item_map
item_data
item_form_metadata
item_group_metadata
versioning_map
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_reference_type_id int4 10  √  null
item_reference_type
status_id int4 10  √  null
status
owner_id int4 10  √  null
user_account
date_created date 13  √  null
date_updated date 13  √  null
update_id int4 10  √  null
oc_oid varchar 40

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

Indexes:
Column(s) Type Sort
item_id Primary key Asc
item_data_type_id Performance Asc
item_reference_type_id Performance Asc
name Performance Asc
oc_oid Performance Asc
units Performance Asc
oc_oid Must be unique Asc

Close relationships  within of separation: