Table cxgn.genomic.library

 Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
library_id serial 10  √  nextval('library_library_id_seq'::regclass)
clone.library_id clone_library_id_fkey
library_shortname_abbreviation.library_id library_shortname_abbreviation_library_id_fkey
clone_type_id int8 19 (0)::bigint
clone_type.clone_type_id library_clone_type_id_fkey
name varchar 80  √  null
shortname varchar 16 ''::character varying
library_detail_id int8 19  √  null
library_detail.library_detail_id library_library_detail_id_fkey
accession_id int8 19  √  null
subclone_of int8 19  √  null
cloning_host varchar 80  √  'E. coli'::character varying
rs1 varchar 12  √  null
rs2 varchar 12  √  null
vector_ligation_1 int4 10  √  null
vector_ligation_2 int4 10  √  null
vector varchar 80
left_primer_id int8 19  √  null
sequencing_primer.sequencing_primer_id library_left_primer_id_fkey
right_primer_id int8 19  √  null
sequencing_primer.sequencing_primer_id library_right_primer_id_fkey

Table contained 6 rows at Wed May 20 01:31 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name
library_id Primary key Asc library_pkey
accession_id Performance Asc accession_id_idx

Close relationships  within one two degrees of separation :