SchemaSpy Analysis of cxgn.annotation - Columns

Generated by SchemaSpy on Wed May 20 01:30 EDT 2009

Legend:

Primary key columns

Columns with indexes

Please support this project

cxgn.annotation contains 99 columns:

Column	Table	Type	Size	Nulls	Auto	Default
alignment	seq_relationship	text	2147483647	√		null
annot_id	annotation	serial	10		√	nextval('annotation_annot_id_seq'::regclass)
annot_id	feature_set	int8	19	√		null
ca_id	comp_analysis	serial	10		√	nextval('comp_analysis_ca_id_seq'::regclass)
ca_id	result_set	int8	19	√		null
cdna_seq_id	feature_set	int8	19	√		null
cds_seq_id	feature_set	int8	19	√		null
clone_id	seq	int8	19	√		null
comment_id	comment	serial	10		√	nextval('comment_comment_id_seq'::regclass)
date	annotation	date	13	√		null
date	comment	date	13	√		null
date	comp_analysis	date	13	√		null
date	feature_set	date	13	√		null
db_id	comp_analysis	int8	19	√		null
db_id	dblist	serial	10		√	nextval('dblist_db_id_seq'::regclass)
db_id	dbxref	int8	19	√		null
db_key	dbxref	varchar	100	√		null
dbxref_id	dbxref	serial	10		√	nextval('dbxref_dbxref_id_seq'::regclass)
description	feature_set	text	2147483647	√		null
description	seq	text	2147483647	√		null
end	seq_relationship	int8	19	√		null
f_set_id	feature_set	serial	10		√	nextval('feature_set_f_set_id_seq'::regclass)
f_set_id	feature_span	int8	19	√		null
f_span_id	feature_span	serial	10		√	nextval('feature_span_f_span_id_seq'::regclass)
genbank_gi	seq	varchar	20	√		null
history_id	annotation	int8	19	√		null
history_id	feature_set	int8	19	√		null
id	annotation	varchar	100	√		null
id	seq	varchar	100	√		null
length	seq	int8	19	√		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	10		√	nextval('organism_organism_id_seq'::regclass)
organism_id	seq	int8	19	√		null
output_id	output	serial	10		√	nextval('output_output_id_seq'::regclass)
output_id	result_span	int8	19	√		null
person_id	annotation	int8	19	√		null
person_id	comment	int8	19	√		null
person_id	comp_analysis	int8	19	√		null
person_id	feature_set	int8	19	√		null
person_id	person	serial	10		√	nextval('person_person_id_seq'::regclass)
person_id	seq	int8	19	√		null
position	seq_error	int8	19	√		null
program_id	comp_analysis	int8	19	√		null
program_id	program	serial	10		√	nextval('program_program_id_seq'::regclass)
property_id	property	serial	10		√	nextval('property_property_id_seq'::regclass)
prot_seq_id	feature_set	int8	19	√		null
r_set_id	result_set	serial	10		√	nextval('result_set_r_set_id_seq'::regclass)
r_set_id	result_span	int8	19	√		null
r_span_id	output	int8	19	√		null
r_span_id	result_span	serial	10		√	nextval('result_span_r_span_id_seq'::regclass)
residues	seq	text	2147483647	√		null
score	result_span	float8	17,17	√		null
seq_err_id	seq_error	serial	10		√	nextval('seq_error_seq_err_id_seq'::regclass)
seq_id	seq	serial	10		√	nextval('seq_seq_id_seq'::regclass)
seq_id	seq_error	int8	19	√		null
seq_id	seq_relationship	int8	19	√		null
seq_rel_id	seq_relationship	serial	10		√	nextval('seq_relationship_seq_rel_id_seq'::regclass)
start	seq_relationship	int8	19	√		null
strand	seq_relationship	varchar	1	√		null
synonym_id	synonym	serial	10		√	nextval('synonym_synonym_id_seq'::regclass)
table_id	comment	int8	19	√		null
table_id	dbxref	int8	19	√		null
table_id	property	int8	19	√		null
table_id	seq_relationship	int8	19	√		null
table_id	synonym	int8	19	√		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	2147483647	√		null
timestamp	annotation	timestamp	29,6			('now'::text)::timestamp(6) with time zone
timestamp	comp_analysis	timestamp	29,6			('now'::text)::timestamp(6) with time zone
timestamp	feature_set	timestamp	29,6			('now'::text)::timestamp(6) with time zone
timestamp	result_set	timestamp	29,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	19	√		null
version	comp_analysis	int8	19	√		null
version	feature_set	int8	19	√		null
version	seq	int8	19	√		null