Table cxgn.sgn_submit.seqread

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
submit_read_id	serial	10		√	nextval('seqread_submit_read_id_seq'::regclass)
library_id	int4	10			0
facility_id	int4	10			0
trace_name	varchar	80	√		null
clone_name	varchar	80	√		null
direction	bpchar	1	√		null
location	varchar	255	√		null
read_id	int4	10	√		null

Table contained 706,107 rows at Wed May 20 02:04 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
submit_read_id	Primary key	Asc	seqread_pkey
clone_name	Performance	Asc	clone_name_idx
facility_id	Performance	Asc	facility_id_idx
library_id	Performance	Asc	library_id_idx
	Performance		location_idx
read_id	Must be unique	Asc	read_id_key	This unique column is also nullable
trace_name	Performance	Asc	trace_name_idx