organismpath

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
organismpath_id serial 10 nextval('organismpath_organismpath_id_seq'::regclass)
subject_id int4 10 null
organism.organism_id organismpath_subject_id_fkey R
object_id int4 10 null
organism.organism_id organismpath_object_id_fkey R
type_id int4 10 null
cvterm.cvterm_id organismpath_type_id_fkey R
pathdistance int4 10 null

Indexes

Constraint Name Type Sort Column(s)
organismpath_pkey Primary key Asc organismpath_id
organismpath_c1 Must be unique Asc/Asc/Asc/Asc subject_id + object_id + type_id + pathdistance
organismpath_idx1 Performance Asc type_id
organismpath_idx2 Performance Asc subject_id
organismpath_idx3 Performance Asc object_id

Relationships