Table oc312.public.discrepancy_note 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
discrepancy_note_id serial 10  √  nextval('discrepancy_note_discrepancy_note_id_seq'::regclass)
dn_event_crf_map.discrepancy_note_id dn_event_crf_map_dn_id_fkey R
dn_item_data_map.discrepancy_note_id dn_item_data_map_dn_id_fkey R
dn_study_event_map.discrepancy_note_id dn_study_event_map_dn_id_fkey R
dn_study_subject_map.discrepancy_note_id dn_study_subject_map_dn_id_fk R
dn_subject_map.discrepancy_note_id dn_subject_map_dn_id_fkey R
description varchar 255  √  null
discrepancy_note_type_id int4 10  √  null
discrepancy_note_type.discrepancy_note_type_id dn_discrepancy_note_type_id_fk R
resolution_status_id int4 10  √  null
resolution_status.resolution_status_id dn_resolution_status_id_fkey R
detailed_notes varchar 1000  √  null
date_created date 13  √  null
owner_id int4 10  √  null
user_account.user_id discrepancy_note_owner_id_fkey R
parent_dn_id int4 10  √  null
entity_type varchar 30  √  null
study_id int4 10  √  null
study.study_id discrepancy_note_study_id_fkey R
assigned_user_id int4 10  √  null
user_account.user_id discrepancy_note_asn_u_id_fkey R

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
discrepancy_note_id Primary key Asc pk_discrepancy_note
discrepancy_note_type_id Performance Asc i_discrepancy_note_discrepancy_note_type_id
entity_type Performance Asc i_discrepancy_note_entity_type
owner_id Performance Asc i_discrepancy_note_owner_id
parent_dn_id Performance Asc i_discrepancy_note_parent_dn_id
resolution_status_id Performance Asc i_discrepancy_note_resolution_status_id
study_id Performance Asc i_discrepancy_note_study_id

Close relationships  within of separation: