Difference between revisions of "Chado Contact Module"
From GMOD
m |
|||
(5 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | + | =Introduction= | |
+ | The contact module is used to store information about people, groups, and organizations. | ||
− | |||
+ | =Tables= | ||
− | == | + | == Table: contact == |
− | + | Model persons, institutes, groups, organizations, etc. | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | Type | + | {| border="1" cellpadding="3" |
− | + | |+ contact Structure | |
− | + | |- | |
− | + | ! F-Key | |
− | UNIQUE | + | ! Name |
+ | ! Type | ||
+ | ! Description | ||
+ | |- class="tr0" | ||
+ | | | ||
+ | | contact_id | ||
+ | | serial | ||
+ | | '' PRIMARY KEY '' | ||
+ | |- class="tr1" | ||
+ | | | ||
+ | [[Chado_Tables#Table:_cvterm| cvterm]] | ||
+ | | type_id | ||
+ | | integer | ||
+ | | '' ''<br /><br />What type of contact is this? E.g. "person", "lab". | ||
+ | |- class="tr0" | ||
+ | | | ||
+ | | name | ||
+ | | character varying(255) | ||
+ | | '' UNIQUE NOT NULL '' | ||
+ | |- class="tr1" | ||
+ | | | ||
+ | | description | ||
+ | | character varying(255) | ||
+ | | '' '' | ||
+ | |} | ||
+ | Tables referencing this one via Foreign Key Constraints: | ||
− | + | * [[Chado_Tables#Table:_arraydesign| arraydesign]] | |
− | + | * [[Chado_Tables#Table:_assay| assay]] | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
+ | * [[Chado_Tables#Table:_biomaterial| biomaterial]] | ||
− | [[Category:Chado]] | + | * [[Chado_Tables#Table:_contact_relationship| contact_relationship]] |
− | [[Category: | + | |
+ | * [[Chado_Tables#Table:_quantification| quantification]] | ||
+ | |||
+ | * [[Chado_Tables#Table:_stockcollection| stockcollection]] | ||
+ | |||
+ | * [[Chado_Tables#Table:_study| study]] | ||
+ | |||
+ | ---- | ||
+ | |||
+ | |||
+ | |||
+ | == Table: contact_relationship == | ||
+ | |||
+ | Model relationships between contacts | ||
+ | |||
+ | {| border="1" cellpadding="3" | ||
+ | |+ contact_relationship Structure | ||
+ | |- | ||
+ | ! F-Key | ||
+ | ! Name | ||
+ | ! Type | ||
+ | ! Description | ||
+ | |- class="tr0" | ||
+ | | | ||
+ | | contact_relationship_id | ||
+ | | serial | ||
+ | | '' PRIMARY KEY '' | ||
+ | |- class="tr1" | ||
+ | | | ||
+ | [[Chado_Tables#Table:_cvterm| cvterm]] | ||
+ | | type_id | ||
+ | | integer | ||
+ | | '' UNIQUE#1 NOT NULL ''<br /><br />Relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed. | ||
+ | |- class="tr0" | ||
+ | | | ||
+ | [[Chado_Tables#Table:_contact| contact]] | ||
+ | | subject_id | ||
+ | | integer | ||
+ | | '' UNIQUE#1 NOT NULL ''<br /><br />The subject of the subj-predicate-obj sentence. In a DAG, this corresponds to the child node. | ||
+ | |- class="tr1" | ||
+ | | | ||
+ | [[Chado_Tables#Table:_contact| contact]] | ||
+ | | object_id | ||
+ | | integer | ||
+ | | '' UNIQUE#1 NOT NULL ''<br /><br />The object of the subj-predicate-obj sentence. In a DAG, this corresponds to the parent node. | ||
+ | |} | ||
+ | |||
+ | ---- | ||
+ | |||
+ | [[Category:Chado Modules]] | ||
+ | [[Category:!Lacking ERD]] |
Latest revision as of 04:34, 18 February 2015
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. |