Schema Version: 1.3 Module: chado

projectprop


Columns

Column Type Size Foreign Key Nullable Default Comments
projectprop_id bigserial 19
nextval('project.projectprop_projectprop_id_seq'::regclass)
project_id int8 19
project.project_id projectprop_project_id_fkey C
null
type_id int8 19
cvterm.cvterm_id projectprop_type_id_fkey C
null
value text 2147483647
√ null
rank int4 10
0

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
projectprop_pkey Primary key Asc projectprop_id
projectprop_c1 Must be unique Asc/Asc/Asc project_id + type_id + rank

Relationships

The following entity relationship (ER) diagram shows the relationships involving the projectprop 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