NOTE: We are working on migrating this site away from MediaWiki, so editing pages will be disabled for now.
Chado Contact Module
From GMOD
Introduction
The contact module is used to store information about people, groups, and organizations.
Tables
Table: contact
Model persons, institutes, groups, organizations, etc.
F-Key | Name | Type | Description |
---|---|---|---|
contact_id | serial | PRIMARY KEY | |
type_id | integer | What type of contact is this? E.g. "person", "lab". | |
name | character varying(255) | UNIQUE NOT NULL | |
description | character varying(255) |
Tables referencing this one via Foreign Key Constraints:
Table: contact_relationship
Model relationships between contacts
F-Key | Name | Type | Description |
---|---|---|---|
contact_relationship_id | serial | PRIMARY KEY | |
type_id | integer | UNIQUE#1 NOT NULL Relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed. | |
subject_id | integer | UNIQUE#1 NOT NULL The subject of the subj-predicate-obj sentence. In a DAG, this corresponds to the child node. | |
object_id | integer | UNIQUE#1 NOT NULL The object of the subj-predicate-obj sentence. In a DAG, this corresponds to the parent node. |