SchemaSpy Analysis of cxgn.sgn_submit - Columns

Generated by SchemaSpy on Wed May 20 02:04 EDT 2009

Legend:

Primary key columns

Columns with indexes

Please support this project

cxgn.sgn_submit contains 57 columns:

Column	Table	Type	Size	Nulls	Auto	Default
accession	library	varchar	255	√		null
attribution_display	facility	text	2147483647	√		null
authors	library	varchar	255	√		null
chemistry	facility	varchar	40	√		null
clone_name	seqread	varchar	80	√		null
cloning_host	library	varchar	80	√		null
cloning_kit	library	varchar	255	√		null
comments	library	text	2147483647	√		null
confirm_code	submit_user	varchar	16	√		null
contact_information	library	text	2147483647	√		null
contact_information	submit_user	text	2147483647	√		null
cultivar	library	varchar	255	√		null
development_stage	library	varchar	255	√		null
direction	seqread	bpchar	1	√		null
disabled	submit_user	int8	19	√		null
email_address	submit_user	varchar	255	√		null
facility_address	facility	text	2147483647	√		null
facility_contact	facility	varchar	80	√		null
facility_id	facility	serial	10		√	nextval('facility_facility_id_seq'::regclass)
facility_id	seqread	int4	10			0
facility_moniker	facility	varchar	20	√		null
facility_name	facility	varchar	80	√		null
facility_shortname	facility	varchar	12	√		null
forward_adapter	library	varchar	2147483647	√		null
funding_agency	facility	varchar	80	√		null
funding_comment	facility	text	2147483647	√		null
library_id	library	serial	10		√	nextval('library_library_id_seq'::regclass)
library_id	seqread	int4	10			0
library_name	library	varchar	80	√		null
library_shortname	library	varchar	16	√		null
location	seqread	varchar	255	√		null
machine	facility	varchar	40	√		null
name	submit_user	varchar	80	√		null
order_routing_id	library	int8	19	√		null
organism_id	library	int4	10	√		null
organization	submit_user	varchar	80	√		null
password	submit_user	varchar	20	√		null
phone_number	submit_user	varchar	20	√		null
read_id	seqread	int4	10	√		null
reverse_adapter	library	varchar	2147483647	√		null
rs1	library	varchar	12	√		null
rs2	library	varchar	12	√		null
sequencing_primers	facility	varchar	80	√		null
sp_person_id	facility	int4	10	√		null
sp_person_id	library	int4	10	√		null
sp_person_id	submit_user	int4	10	√		null
submit_code	submit_user	varchar	6	√		null
submit_read_id	seqread	serial	10		√	nextval('seqread_submit_read_id_seq'::regclass)
submit_user_id	facility	int4	10	√		null
submit_user_id	library	int4	10	√		null
submit_user_id	submit_user	serial	10		√	nextval('submit_user_submit_user_id_seq'::regclass)
tissue	library	varchar	255	√		null
trace_name	seqread	varchar	80	√		null
treatment_conditions	library	text	2147483647	√		null
type	library	int8	19	√		null
username	submit_user	varchar	20	√		null
vector	library	varchar	80	√		null