Template:ChadoTable featureprop

From GMOD

This template is a Chado Table Template. It defines a single table from the Chado schema, and every Chado table has a template like this one. This template is automatically included in two places:

1. The module page for the module the table is a part of. This is where updates and comments should be posted.
2. The Chado Tables page, which lists all tables.

You can include this template anywhere you want to show the table description.

---

Table:	featureprop
Module:	Sequence

A feature can have any number of slot-value property tags attached to it. This is an alternative to hardcoding a list of columns in the relational schema, and is completely extensible.

featureprop columns

FK	Name	Type	Description
	featureprop_id	serial	PRIMARY KEY
feature	feature_id	integer	UNIQUE#1 NOT NULL
cvterm	type_id	integer	UNIQUE#1 NOT NULL The name of the property/slot is a cvterm. The meaning of the property is defined in that cvterm. Certain property types will only apply to certain feature types (e.g. the anticodon property will only apply to tRNA features) ; the types here come from the sequence feature property ontology.
	value	text	The value of the property, represented as text. Numeric values are converted to their text representation. This is less efficient than using native database types, but is easier to query.
	rank	integer	UNIQUE#1 NOT NULL Property-Value ordering. Any feature can have multiple values for any particular property type - these are ordered in a list using rank, counting from zero. For properties that are single-valued rather than multi-valued, the default 0 value should be used

Tables referencing featureprop via foreign key constraints:

• featureprop_pub