Schema Version: 1.3 Module: chado

Columns

Columns

Table Type Column Type Size Nulls Default Comments
feature_expression Table feature_expression_id bigserial 19 nextval('expression.feature_expression_feature_expression_id_seq'::regclass)
expression_cvtermprop Table type_id int8 19 null

The name of the property/slot is a cvterm. The meaning of the property is defined in that cvterm. For example, cvterms may come from the FlyBase miscellaneous cv.
expressionprop Table expression_id int8 19 null
eimage Table image_uri varchar 255 √ null
feature_expressionprop Table feature_expressionprop_id bigserial 19 nextval('expression.feature_expressionprop_feature_expressionprop_id_seq'::regclass)
expression Table expression_id bigserial 19 nextval('expression.expression_expression_id_seq'::regclass)
expression_cvterm Table rank int4 10 0
expression_cvterm Table cvterm_id int8 19 null
feature_expressionprop Table type_id int8 19 null
eimage Table eimage_data text 2147483647 √ null

We expect images in eimage_data (e.g. JPEGs) to be uuencoded.
expression_pub Table pub_id int8 19 null
feature_expressionprop Table feature_expression_id int8 19 null
eimage Table eimage_id bigserial 19 nextval('expression.eimage_eimage_id_seq'::regclass)
expression Table uniquename text 2147483647 null
expression Table description text 2147483647 √ null
eimage Table eimage_type varchar 255 null

Describes the type of data in eimage_data.
feature_expression Table feature_id int8 19 null
expression_image Table expression_image_id bigserial 19 nextval('expression.expression_image_expression_image_id_seq'::regclass)
expression_cvterm Table expression_cvterm_id bigserial 19 nextval('expression.expression_cvterm_expression_cvterm_id_seq'::regclass)
feature_expression Table pub_id int8 19 null
expressionprop Table expressionprop_id bigserial 19 nextval('expression.expressionprop_expressionprop_id_seq'::regclass)
feature_expressionprop Table value text 2147483647 √ null
expression_cvtermprop Table rank int4 10 0

Property-Value ordering. Any expression_cvterm 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.
expressionprop Table rank int4 10 0
expression_cvtermprop Table value text 2147483647 √ null

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.
expressionprop Table value text 2147483647 √ null
expression_cvtermprop Table expression_cvterm_id int8 19 null
feature_expression Table expression_id int8 19 null
expression_cvtermprop Table expression_cvtermprop_id bigserial 19 nextval('expression.expression_cvtermprop_expression_cvtermprop_id_seq'::regclass)
expression_pub Table expression_id int8 19 null
expression_pub Table expression_pub_id bigserial 19 nextval('expression.expression_pub_expression_pub_id_seq'::regclass)
expression Table md5checksum bpchar 32 √ null
expressionprop Table type_id int8 19 null
expression_cvterm Table expression_id int8 19 null
feature_expressionprop Table rank int4 10 0
expression_image Table eimage_id int8 19 null
expression_cvterm Table cvterm_type_id int8 19 null
expression_image Table expression_id int8 19 null