Difference between revisions of "Chado Contact Module"
From GMOD
m (New page: ==Introduction== ==Tables== ===contact=== model persons, institutes, groups, organizations, etc Field Name Data Type Size Default Value Other Foreign Key contact_id integer 11 ...) |
|||
(6 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. | |
− | + | {| border="1" cellpadding="3" | |
− | + | |+ contact Structure | |
− | contact_id | + | |- |
− | type_id integer | + | ! F-Key |
− | name | + | ! Name |
− | description | + | ! 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]] | |
− | + | ||
− | contact_relationship_id | + | * [[Chado_Tables#Table:_contact_relationship| contact_relationship]] |
− | type_id integer | + | |
− | subject_id integer | + | * [[Chado_Tables#Table:_quantification| quantification]] |
− | object_id integer | + | |
− | + | * [[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. |