SchemaSpy Analysis of cxgn.annotation_bt - Columns

Generated by SchemaSpy on Wed Sep 13 17:05 EDT 2006

Legend:

Primary key columns

Columns with indexes

Please support this project

cxgn.annotation_bt contains 117 columns:

Column	Table	Type	Size	Nulls	Auto	Default
alignment	seq_relationship	text	-1	√		null
annot_id	annotation	serial	4		√	nextval('annotation_bt.annotation_annot_id_seq'::text)
annot_id	feature_set	int8	8	√		null
ca_id	comp_analysis	serial	4		√	nextval('annotation_bt.comp_analysis_ca_id_seq'::text)
ca_id	result_set	int8	8	√		null
cdna_seq_id	feature_set	int8	8	√		null
cds_seq_id	feature_set	int8	8	√		null
clone_id	seq	int8	8	√		null
comment_id	comment	serial	4		√	nextval('annotation_bt.comment_comment_id_seq'::text)
cxgn_production_visible	annotation	bool	1	√		false
cxgn_production_visible	comment	bool	1	√		false
cxgn_production_visible	comp_analysis	bool	1	√		false
cxgn_production_visible	dblist	bool	1	√		false
cxgn_production_visible	dbxref	bool	1	√		false
cxgn_production_visible	feature_set	bool	1	√		false
cxgn_production_visible	feature_span	bool	1	√		false
cxgn_production_visible	organism	bool	1	√		false
cxgn_production_visible	output	bool	1	√		false
cxgn_production_visible	person	bool	1	√		false
cxgn_production_visible	program	bool	1	√		false
cxgn_production_visible	property	bool	1	√		false
cxgn_production_visible	result_set	bool	1	√		false
cxgn_production_visible	result_span	bool	1	√		false
cxgn_production_visible	seq	bool	1	√		false
cxgn_production_visible	seq_error	bool	1	√		false
cxgn_production_visible	seq_relationship	bool	1	√		false
cxgn_production_visible	synonym	bool	1	√		false
date	annotation	date	4	√		null
date	comment	date	4	√		null
date	comp_analysis	date	4	√		null
date	feature_set	date	4	√		null
db_id	comp_analysis	int8	8	√		null
db_id	dblist	serial	4		√	nextval('annotation_bt.dblist_db_id_seq'::text)
db_id	dbxref	int8	8	√		null
db_key	dbxref	varchar	100	√		null
dbxref_id	dbxref	serial	4		√	nextval('annotation_bt.dbxref_dbxref_id_seq'::text)
description	feature_set	text	-1	√		null
description	seq	text	-1	√		null
end	seq_relationship	int8	8	√		null
f_set_id	feature_set	serial	4		√	nextval('annotation_bt.feature_set_f_set_id_seq'::text)
f_set_id	feature_span	int8	8	√		null
f_span_id	feature_span	serial	4		√	nextval('annotation_bt.feature_span_f_span_id_seq'::text)
genbank_gi	seq	varchar	20	√		null
history_id	annotation	int8	8	√		null
history_id	feature_set	int8	8	√		null
id	annotation	varchar	100	√		null
id	seq	varchar	100	√		null
length	seq	int8	8	√		null
md5checksum	seq	varchar	32	√		null
name	annotation	varchar	100	√		null
name	dblist	varchar	100	√		null
name	feature_set	varchar	100	√		null
name	organism	varchar	100	√		null
name	person	varchar	100	√		null
name	program	varchar	100	√		null
name	result_set	varchar	100	√		null
name	seq	varchar	100	√		null
name	synonym	varchar	100	√		null
organism_id	organism	serial	4		√	nextval('annotation_bt.organism_organism_id_seq'::text)
organism_id	seq	int8	8	√		null
output_id	output	serial	4		√	nextval('annotation_bt.output_output_id_seq'::text)
output_id	result_span	int8	8	√		null
person_id	annotation	int8	8	√		null
person_id	comment	int8	8	√		null
person_id	comp_analysis	int8	8	√		null
person_id	feature_set	int8	8	√		null
person_id	person	serial	4		√	nextval('annotation_bt.person_person_id_seq'::text)
person_id	seq	int8	8	√		null
position	seq_error	int8	8	√		null
program_id	comp_analysis	int8	8	√		null
program_id	program	serial	4		√	nextval('annotation_bt.program_program_id_seq'::text)
property_id	property	serial	4		√	nextval('annotation_bt.property_property_id_seq'::text)
prot_seq_id	feature_set	int8	8	√		null
r_set_id	result_set	serial	4		√	nextval('annotation_bt.result_set_r_set_id_seq'::text)
r_set_id	result_span	int8	8	√		null
r_span_id	output	int8	8	√		null
r_span_id	result_span	serial	4		√	nextval('annotation_bt.result_span_r_span_id_seq'::text)
residues	seq	text	-1	√		null
score	result_span	float8	8	√		null
seq_err_id	seq_error	serial	4		√	nextval('annotation_bt.seq_error_seq_err_id_seq'::text)
seq_id	seq	serial	4		√	nextval('annotation_bt.seq_seq_id_seq'::text)
seq_id	seq_error	int8	8	√		null
seq_id	seq_relationship	int8	8	√		null
seq_rel_id	seq_relationship	serial	4		√	nextval('annotation_bt.seq_relationship_seq_rel_id_seq'::text)
start	seq_relationship	int8	8	√		null
strand	seq_relationship	varchar	1	√		null
synonym_id	synonym	serial	4		√	nextval('annotation_bt.synonym_synonym_id_seq'::text)
table_id	comment	int8	8	√		null
table_id	dbxref	int8	8	√		null
table_id	property	int8	8	√		null
table_id	seq_relationship	int8	8	√		null
table_id	synonym	int8	8	√		null
table_name	comment	varchar	11	√		null
table_name	dbxref	varchar	10	√		null
table_name	property	varchar	13	√		null
table_name	seq_relationship	varchar	12	√		null
table_name	synonym	varchar	11	√		null
text	comment	text	-1	√		null
timestamp	annotation	timestamp	8,6			('now'::text)::timestamp(6) with time zone
timestamp	comp_analysis	timestamp	8,6			('now'::text)::timestamp(6) with time zone
timestamp	feature_set	timestamp	8,6			('now'::text)::timestamp(6) with time zone
timestamp	result_set	timestamp	8,6			('now'::text)::timestamp(6) with time zone
type	annotation	varchar	10	√		null
type	feature_set	varchar	20	√		null
type	feature_span	varchar	13	√		null
type	output	varchar	20	√		null
type	property	varchar	100	√		null
type	result_span	varchar	20	√		null
type	seq	varchar	3	√		null
type	seq_error	varchar	20	√		null
type	seq_relationship	varchar	7	√		null
value	output	varchar	20	√		null
value	property	varchar	100	√		null
version	annotation	int8	8	√		null
version	comp_analysis	int8	8	√		null
version	feature_set	int8	8	√		null
version	seq	int8	8	√		null