SchemaSpy Analysis of cxgn.annotation - 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 contains 99 columns:

Column	Table	Type	Size	Nulls	Default
alignment	seq_relationship	text	-1	√	null
annot_id	annotation	int4	4	√	null
annot_id	feature_set	int8	8	√	null
ca_id	comp_analysis	int4	4	√	null
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	int4	4	√	null
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	int4	4	√	null
db_id	dbxref	int8	8	√	null
db_key	dbxref	varchar	100	√	null
dbxref_id	dbxref	int4	4	√	null
description	feature_set	text	-1	√	null
description	seq	text	-1	√	null
end	seq_relationship	int8	8	√	null
f_set_id	feature_set	int4	4	√	null
f_set_id	feature_span	int8	8	√	null
f_span_id	feature_span	int4	4	√	null
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	int4	4	√	null
organism_id	seq	int8	8	√	null
output_id	output	int4	4	√	null
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	int4	4	√	null
person_id	seq	int8	8	√	null
position	seq_error	int8	8	√	null
program_id	comp_analysis	int8	8	√	null
program_id	program	int4	4	√	null
property_id	property	int4	4	√	null
prot_seq_id	feature_set	int8	8	√	null
r_set_id	result_set	int4	4	√	null
r_set_id	result_span	int8	8	√	null
r_span_id	output	int8	8	√	null
r_span_id	result_span	int4	4	√	null
residues	seq	text	-1	√	null
score	result_span	float8	8	√	null
seq_err_id	seq_error	int4	4	√	null
seq_id	seq	int4	4	√	null
seq_id	seq_error	int8	8	√	null
seq_id	seq_relationship	int8	8	√	null
seq_rel_id	seq_relationship	int4	4	√	null
start	seq_relationship	int8	8	√	null
strand	seq_relationship	varchar	1	√	null
synonym_id	synonym	int4	4	√	null
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	√	null
timestamp	comp_analysis	timestamp	8,6	√	null
timestamp	feature_set	timestamp	8,6	√	null
timestamp	result_set	timestamp	8,6	√	null
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