Difference between revisions of "Chado Contact Module"
From GMOD
m |
m (→Table: contact_relationship) |
||
Line 98: | Line 98: | ||
---- | ---- | ||
− | + | [[Category:Chado Modules]] | |
− | + | ||
− | + | ||
− | [[Category:Chado]] | + |
Revision as of 22:30, 25 January 2008
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. |