Table cxgn.sgn_submit.facility

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
facility_id	serial	10		√	nextval('facility_facility_id_seq'::regclass)
submit_user_id	int4	10	√		null
facility_moniker	varchar	20	√		null
facility_shortname	varchar	12	√		null
facility_name	varchar	80	√		null
facility_contact	varchar	80	√		null
facility_address	text	2147483647	√		null
funding_agency	varchar	80	√		null
funding_comment	text	2147483647	√		null
sequencing_primers	varchar	80	√		null
machine	varchar	40	√		null
chemistry	varchar	40	√		null
attribution_display	text	2147483647	√		null
sp_person_id	int4	10	√		null

Table contained 30 rows at Wed May 20 02:04 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name
facility_id	Primary key	Asc	facility_pkey
submit_user_id	Performance	Asc	submit_user_id_idx