Table test_seqware_meta_db.public.processing_samples
Relates steps of a workflow to high-level metadata

 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
processing_samples_id serial 10  √  nextval('processing_samples_processing_samples_id_seq'::regclass)
sample_id int4 10
sample.sample_id processing_samples_sample_id_fkey R
processing_id int4 10
processing.processing_id processing_samples_processing_id_fkey R
description text 2147483647  √  null
label text 2147483647  √  null
url text 2147483647  √  null
sw_accession serial 10  √   √  nextval('sw_accession_seq'::regclass)

Table contained 37 rows at Mon Mar 31 13:20 EDT 2014

Indexes:
Column(s) Type Sort Constraint Name
processing_samples_id Primary key Asc processing_samples_pkey
sample_id + processing_id Must be unique Asc/Asc processing_samples_unique_key
sample_id Performance Asc sample_id_processing_samples

Close relationships  within of separation: