Schema Version: 1.3 Module: chado

environment_cvterm


Columns

Column Type Size Foreign Key Nullable Default Comments
environment_cvterm_id bigserial 19
nextval('genetic.environment_cvterm_environment_cvterm_id_seq'::regclass)
environment_id int8 19
environment.environment_id environment_cvterm_environment_id_fkey C
null
cvterm_id int8 19
cvterm.cvterm_id environment_cvterm_cvterm_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
environment_cvterm_pkey Primary key Asc environment_cvterm_id
environment_cvterm_c1 Must be unique Asc/Asc environment_id + cvterm_id
environment_cvterm_idx1 Performance Asc environment_id
environment_cvterm_idx2 Performance Asc cvterm_id

Relationships

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