Table test_seqware_meta_db.public.study
High-level organization of experiments (required for reporting, created by migration)

 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
study_id serial 10  √  nextval('study_study_id_seq'::regclass)
experiment.study_id experiment_study_id_fkey R
processing_studies.study_id processing_studies_study_id_fkey R
share_study.study_id fk_share_study_study_id R
study_attribute.study_id study_attribute_study_id_fkey R
study_link.study_id study_link_study_id_fkey R
title text 2147483647
alias text 2147483647  √  null
description text 2147483647  √  null
accession text 2147483647  √  null
abstract text 2147483647  √  null
existing_type int4 10
study_type.study_type_id study_existing_type_fkey R
new_type text 2147483647  √  null
center_name text 2147483647
center_project_name text 2147483647
project_id int4 10 0
status text 2147483647  √  null
owner_id int4 10  √  null
registration.registration_id study_owner_id_fkey R
sw_accession serial 10  √   √  nextval('sw_accession_seq'::regclass)
create_tstmp timestamp 29,6
update_tstmp timestamp 29,6  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
study_id Primary key Asc study_pkey

Close relationships  within of separation: