Difference between revisions of "Chado Contact Module"
From GMOD
m |
m |
||
Line 1: | Line 1: | ||
− | + | =Introduction= | |
− | + | =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]] | ||
+ | |||
+ | * [[Chado_Tables#Table:_contact_relationship| contact_relationship]] | ||
+ | |||
+ | * [[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]] | [[Category:Chado]] | ||
[[Category:To Do]] | [[Category:To Do]] |
Revision as of 20:25, 28 February 2007
Introduction
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. |