Table test_seqware_meta_db.public.file
Track files used as input for and output from workflow runs (required, created by SeqWare)

 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
file_id serial 10  √  nextval('file_file_id_seq'::regclass)
file_attribute.file_id fk7750ef99bb4f9efd R
processing_files.file_id processing_files_file_id_fkey R
share_file.file_id fk_share_file_file_id R
workflow_run_input_files.file_id file_id R
file_path text 2147483647
md5sum text 2147483647  √  null
url text 2147483647  √  null
url_label text 2147483647  √  null
type text 2147483647  √  null
meta_type text 2147483647  √  null
description text 2147483647  √  null
owner_id int4 10  √  null
registration.registration_id fk_file_owner_id R
sw_accession serial 10  √   √  nextval('sw_accession_seq'::regclass)
file_type_id int4 10  √  null
file_type.file_type_id fk_file_file_type_id R
size int8 19  √  null
skip bool 1  √  false

Table contained 70,986 rows at Mon Mar 31 13:20 EDT 2014

Indexes:
Column(s) Type Sort Constraint Name
file_id Primary key Asc file_pkey
sw_accession Performance Asc sw_accession_file

Close relationships  within of separation: