Difference between revisions of "Chado Contact Module"

From GMOD
Jump to: navigation, search
m
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Introduction==
+
=Introduction=
  
 +
The contact module is used to store information about people, groups, and organizations.
  
==Tables==
 
  
 +
=Tables=
  
===contact===
+
== Table: contact ==
  
model persons, institutes, groups, organizations, etc
+
Model persons, institutes, groups, organizations, etc.
Field Name Data Type Size Default Value Other Foreign Key
+
contact_id integer 11 PRIMARY KEY, NOT NULL
+
type_id integer 10 NULL what type of contact is this? e.g. "person", "lab", etc. cvterm.cvterm_id
+
name varchar 255 UNIQUE, NOT NULL
+
description varchar 255 NULL
+
Constraints
+
  
Type Fields
+
{| border="1" cellpadding="3"
NOT NULL contact_id
+
|+ contact Structure
FOREIGN KEY type_id
+
|-
NOT NULL name
+
! F-Key
UNIQUE name
+
! 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:
  
===contact_relationship===
+
* [[Chado_Tables#Table:_arraydesign| arraydesign]]
  
model relationships between contacts
+
* [[Chado_Tables#Table:_assay| assay]]
Field Name Data Type Size Default Value Other Foreign Key
+
contact_relationship_id integer 11 PRIMARY KEY, NOT NULL
+
type_id integer 10 UNIQUE, NOT NULL, relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed cvterm.cvterm_id
+
subject_id integer 10 UNIQUE, NOT NULL, the subject of the subj-predicate-obj sentence. In a DAG, this corresponds to the child node contact.contact_id
+
object_id integer 10 UNIQUE, NOT NULL, the object of the subj-predicate-obj sentence. In a DAG, this corresponds to the parent node contact.contact_id
+
Indices
+
  
 +
* [[Chado_Tables#Table:_biomaterial| biomaterial]]
  
[[Category:Chado]]
+
* [[Chado_Tables#Table:_contact_relationship| contact_relationship]]
[[Category:To Do]]
+
 
 +
* [[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.

contact Structure
F-Key Name Type Description
contact_id serial PRIMARY KEY

cvterm

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

contact_relationship Structure
F-Key Name Type Description
contact_relationship_id serial PRIMARY KEY

cvterm

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.

contact

subject_id integer UNIQUE#1 NOT NULL

The subject of the subj-predicate-obj sentence. In a DAG, this corresponds to the child node.

contact

object_id integer UNIQUE#1 NOT NULL

The object of the subj-predicate-obj sentence. In a DAG, this corresponds to the parent node.