Table cxgn.physical_bt.bacs

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
bac_id	serial	10		√	nextval('bacs_bac_id_seq'::regclass)
cornell_clone_name	varchar	16			''::character varying
arizona_clone_name	varchar	32			''::character varying
species_id	int8	19			(0)::bigint
sp6_end_seq_id	int8	19	√		null
t7_end_seq_id	int8	19	√		null
genbank_accession	varchar	32	√		null
bad_clone	int2	5			(0)::smallint
estimated_length	int8	19	√		null
library_id	int4	10	√		null
cxgn_production_visible	bool	1	√		false

Table contained 129,024 rows at Thu Jun 21 23:01 EDT 2007

Indexes:

Column(s)	Type	Sort	Constraint Name
bac_id	Primary key	Asc	bacs_pkey
arizona_clone_name	Must be unique	Asc	bacs_arizona_clone_name_key
cornell_clone_name + arizona_clone_name + species_id + genbank_accession + bad_clone + estimated_length	Performance	Asc/Asc/Asc/Asc/Asc/Asc	cornell_clone_name_idx