cvtermpath

2435 rows


Description

The reflexive transitive closure of the cvterm_relationship relation. For a full discussion, see the file populating-cvtermpath.txt in this directory

Columns

Column Type Size Nulls Auto Default Children Parents Comments
cvtermpath_id serial 10 √ nextval('cvtermpath_cvtermpath_id_seq'::regclass)
type_id int4 10 √ null
cvterm.cvterm_id cvtermpath_type_id_fkey N

The relationship type that this is a closure over. If null, then this is a closure over ALL relationship types. If non-null, then this references a relationship cvterm - note that the closure will apply to both this relationship AND the OBO_REL:is_a (subclass) relationship
subject_id int4 10 null
cvterm.cvterm_id cvtermpath_subject_id_fkey C
object_id int4 10 null
cvterm.cvterm_id cvtermpath_object_id_fkey C
cv_id int4 10 null
cv.cv_id cvtermpath_cv_id_fkey C

Closures will mostly be within one cv. If the closure of a relationship traverses a cv, then this refers to the cv of the object_id cvterm
pathdistance int4 10 √ null

The number of steps required to get from the subject cvterm to the object cvterm, counting from zero (reflexive relationship)

Indexes

Constraint Name Type Sort Column(s)
cvtermpath_pkey Primary key Asc cvtermpath_id
cvtermpath_c1 Must be unique Asc/Asc/Asc/Asc subject_id + object_id + type_id + pathdistance
cvtermpath_idx1 Performance Asc type_id
cvtermpath_idx2 Performance Asc subject_id
cvtermpath_idx3 Performance Asc object_id
cvtermpath_idx4 Performance Asc cv_id

Relationships

Close relationships within degrees of separation