Table cxgn.sgn_bt.manual_annotations

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
manual_annotations_id	bigserial	19		√	nextval('manual_annotations_manual_annotations_id_seq'::regclass)
annotation_target_id	int8	19	√		null
annotation_target_type_id	int8	19	√		null
annotation_text	text	2147483647	√		null
author_id	int8	19	√		null
date_entered	date	13	√		null
last_modified	date	13	√		null
annotation_text_fulltext	tsvector	2147483647	√		null
cxgn_production_visible	bool	1	√		false

Table contained 6,833 rows at Thu Jun 21 23:03 EDT 2007

Indexes:

Column(s)	Type	Sort	Constraint Name
manual_annotations_id	Primary key	Asc	manual_annotations_pkey
annotation_target_id + annotation_target_type_id	Performance	Asc/Asc	annotation_target_id_idx
annotation_text_fulltext	Performance	Asc	manual_annotations_annotation_text_fulltext_index