Difference between revisions of "Chado Contact Module"

From GMOD
Jump to: navigation, search
m (Table: contact_relationship)
 
Line 99: Line 99:
  
 
[[Category:Chado Modules]]
 
[[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.