Table cxgn.sgn_bt.facility

 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
facility_id serial 10  √  nextval('facility_facility_id_seq'::regclass)
seqread.facility_id facility_id_fk
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
cxgn_production_visible bool 1  √  false
sp_person_id int4 10  √  null

Table contained 27 rows at Thu Jun 21 23:03 EDT 2007

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

Close relationships  within one two degrees of separation :