Table test_seqware_meta_db.public.workflow
Records installed workflows (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
workflow_id serial 10  √  nextval('workflow_workflow_id_seq'::regclass)
workflow_attribute.workflow_id fk2d251a1c685fba9d R
workflow_param.workflow_id fk_workflow_param_workflow_id R
workflow_run.workflow_id workflow_run_workflow_id_fkey R
name text 2147483647  √  null
description text 2147483647  √  null
input_algorithm text 2147483647  √  null
version text 2147483647  √  null
seqware_version text 2147483647  √  null
owner_id int4 10  √  null
registration.registration_id fk_workflow_registration_id R
base_ini_file text 2147483647  √  null
cmd text 2147483647  √  null
current_working_dir text 2147483647  √  null
host text 2147483647  √  null
username text 2147483647  √  null
workflow_template text 2147483647  √  null
create_tstmp timestamp 29,6
update_tstmp timestamp 29,6  √  null
sw_accession serial 10  √   √  nextval('sw_accession_seq'::regclass)
permanent_bundle_location text 2147483647  √  null
workflow_class text 2147483647  √  null
workflow_type text 2147483647  √  null
workflow_engine text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
workflow_id Primary key Asc workflow_pkey

Close relationships  within of separation: