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