Table cxgn.physical_bt.bac_consensus_sequences

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
consensus_seq_id	serial	10		√	nextval('bac_consensus_sequences_consensus_seq_id_seq'::regclass)
fasta_sequence	text	2147483647
bac_id	int8	19			(0)::bigint
tracefile	varchar	64			''::character varying
consensus_seq_name	varchar	32	√		null
length	int8	19			(0)::bigint
includes_sp6_end	int2	5	√		null
includes_t7_end	int2	5	√		null
cxgn_production_visible	bool	1	√		false

Table contained 0 rows at Thu Jun 21 23:01 EDT 2007

Indexes:

Column(s)	Type	Sort	Constraint Name
consensus_seq_id	Primary key	Asc	bac_consensus_sequences_pkey
bac_id + consensus_seq_name + length + includes_sp6_end + includes_t7_end	Performance	Asc/Asc/Asc/Asc/Asc	bac_id_idx2