Schema Version: 1.3 Module: chado

Columns

Columns

Table Type Column Type Size Nulls Default Comments
contactprop Table contactprop_id bigserial 19 nextval('contact.contactprop_contactprop_id_seq'::regclass)
contactprop Table rank int4 10 0
contact Table name varchar 255 null
contact_relationship Table subject_id int8 19 null

The subject of the subj-predicate-obj sentence. In a DAG, this corresponds to the child node.

contact Table type_id int8 19 null

What type of contact is this? E.g. "person", "lab".

contactprop Table type_id int8 19 null
contactprop Table value text 2147483647 null
contact_relationship Table object_id int8 19 null

The object of the subj-predicate-obj sentence. In a DAG, this corresponds to the parent node.

contact_relationship Table type_id int8 19 null

Relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed.

contactprop Table contact_id int8 19 null
contact Table contact_id bigserial 19 nextval('contact.contact_contact_id_seq'::regclass)
contact_relationship Table contact_relationship_id bigserial 19 nextval('contact.contact_relationship_contact_relationship_id_seq'::regclass)
contact Table description varchar 255 null