Difference between revisions of "Chado Contact Module"

From GMOD
Jump to: navigation, search
m
m
Line 1: Line 1:
==Introduction==
+
=Introduction=
  
  
==Tables==
+
=Tables=
  
 +
== Table: contact ==
  
===contact===
+
Model persons, institutes, groups, organizations, etc.
  
model persons, institutes, groups, organizations, etc
+
{| border="1" cellpadding="3"
Field Name Data Type Size Default Value Other Foreign Key
+
|+ contact Structure
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
+
! F-Key
name varchar 255 UNIQUE, NOT NULL
+
! Name
description varchar 255 NULL
+
! Type
Constraints
+
! 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)
 +
| '' ''
 +
|}
  
Type Fields
+
Tables referencing this one via Foreign Key Constraints:
NOT NULL contact_id
+
FOREIGN KEY type_id
+
NOT NULL name
+
UNIQUE name
+
  
 +
* [[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.
 +
|}
 +
 +
----
  
===contact_relationship===
 
  
model relationships between contacts
 
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
 
  
  
 
[[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.

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.