Table dvnDb.public.vdcactivity Generated by
SchemaSpy
Legend: SourceForge.net
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
id serial 10  √  nextval('vdcactivity_id_seq'::regclass)
foreignstudylocaldownloadcount int4 10
localstudyforeigndownloadcount int4 10
localstudylocaldownloadcount int4 10
localstudynetworkdownloadcount int4 10
vdc_id int8 19  √  null
vdc.id fk_vdcactivity_vdc_id R

Table contained 7 rows at Fri May 30 15:33 MDT 2014

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc vdcactivity_pkey  
vdc_id Must be unique Asc vdcactivity_vdc_id_key This unique column is also nullable

Close relationships  within of separation: