Table cxgn.sgn_submit.library

Generated by
SchemaSpy

Legend:

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
library_id	serial	10		√	nextval('library_library_id_seq'::regclass)
type	int8	19	√		null
submit_user_id	int4	10	√		null
library_name	varchar	80	√		null
library_shortname	varchar	16	√		null
authors	varchar	255	√		null
organism_id	int4	10	√		null
cultivar	varchar	255	√		null
accession	varchar	255	√		null
tissue	varchar	255	√		null
development_stage	varchar	255	√		null
treatment_conditions	text	2147483647	√		null
cloning_host	varchar	80	√		null
vector	varchar	80	√		null
rs1	varchar	12	√		null
rs2	varchar	12	√		null
cloning_kit	varchar	255	√		null
comments	text	2147483647	√		null
contact_information	text	2147483647	√		null
order_routing_id	int8	19	√		null
sp_person_id	int4	10	√		null
forward_adapter	varchar	2147483647	√		null
reverse_adapter	varchar	2147483647	√		null

Table contained 125 rows at Mon Oct 06 01:38 EDT 2008

Indexes:

Column(s)	Type	Sort	Constraint Name
library_id	Primary key	Asc	library_pkey
organism_id	Performance	Asc	organism_id_idx
submit_user_id	Performance	Asc	submit_user_id_idx2