The contact module is used to store information about people, groups, and organizations.
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) |
contact Structure
Tables referencing this one via Foreign Key Constraints:
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. |
contact_relationship Structure