Schema Version: 1.3 Module: chado

expressionprop


Columns

Column Type Size Foreign Key Nullable Default Comments
expressionprop_id bigserial 19
nextval('expression.expressionprop_expressionprop_id_seq'::regclass)
expression_id int8 19
expression.expression_id expressionprop_expression_id_fkey C
null
type_id int8 19
cvterm.cvterm_id expressionprop_type_id_fkey C
null
value text 2147483647
√ null
rank int4 10
0

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
expressionprop_pkey Primary key Asc expressionprop_id
expressionprop_c1 Must be unique Asc/Asc/Asc expression_id + type_id + rank
expressionprop_idx1 Performance Asc expression_id
expressionprop_idx2 Performance Asc type_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the expressionprop table.

These relationships often cross chado module boundries, in which case the table name will be prefixed with the module it is in. When querying these tables do not include the module name, as all chado tables are contained within the same schema.

Show relationships within degrees of separation