organism_relationship

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
organism_relationship_id serial 10 nextval('organism_relationship_organism_relationship_id_seq'::regclass)
subject_id int4 10 null
organism.organism_id organism_relationship_subject_id_fkey R
object_id int4 10 null
organism.organism_id organism_relationship_object_id_fkey R
type_id int4 10 null
cvterm.cvterm_id organism_relationship_type_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
organism_relationship_pkey Primary key Asc organism_relationship_id
organism_relationship_c1 Must be unique Asc/Asc/Asc subject_id + object_id + type_id
organism_relationship_idx1 Performance Asc subject_id
organism_relationship_idx2 Performance Asc object_id
organism_relationship_idx3 Performance Asc type_id

Relationships