Chado Contact Module
Introduction
Tables
contact
model persons, institutes, groups, organizations, etc Field Name Data Type Size Default Value Other Foreign Key contact_id integer 11 PRIMARY KEY, NOT NULL type_id integer 10 NULL what type of contact is this? e.g. "person", "lab", etc. cvterm.cvterm_id name varchar 255 UNIQUE, NOT NULL description varchar 255 NULL Constraints
Type Fields NOT NULL contact_id FOREIGN KEY type_id NOT NULL name UNIQUE name
contact_relationship
model relationships between contacts Field Name Data Type Size Default Value Other Foreign Key contact_relationship_id integer 11 PRIMARY KEY, NOT NULL type_id integer 10 UNIQUE, NOT NULL, relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed cvterm.cvterm_id subject_id integer 10 UNIQUE, NOT NULL, the subject of the subj-predicate-obj sentence. In a DAG, this corresponds to the child node contact.contact_id object_id integer 10 UNIQUE, NOT NULL, the object of the subj-predicate-obj sentence. In a DAG, this corresponds to the parent node contact.contact_id Indices
