Difference between revisions of "Template:ChadoTable contact relationship"

From GMOD
Jump to: navigation, search
(Table definition, first upload on 2010/11/22.)
 
(Table definition for Chado on 2010/11/24)
 
Line 1: Line 1:
<noinclude>{{ChadoTableTemplateHeader}}</noinclude><protect>{{ChadoTableDesc|Contact|contact_relationship|Model relationships between contacts}}
+
<protect><noinclude>{{ChadoTableTemplateHeader}}</noinclude>
 +
{{ChadoTableDesc|Contact|contact_relationship|Model relationships between contacts}}
 
{{ChadoColumnsHeader|Contact|contact_relationship}}
 
{{ChadoColumnsHeader|Contact|contact_relationship}}
{{ChadoColumnDesc||contact_relationship_id|serial|''PRIMARY KEY''
+
{{ChadoColumnDesc||contact_relationship_id|serial|''PRIMARY KEY''<br />
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|CV|cvterm}}|type_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|CV|cvterm}}|type_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
Relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed.}}
 
Relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed.}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|Contact|contact}}|subject_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|Contact|contact}}|subject_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
The subject of the subj-predicate-obj sentence. In a DAG, this corresponds to the child node.}}
 
The subject of the subj-predicate-obj sentence. In a DAG, this corresponds to the child node.}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|Contact|contact}}|object_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|Contact|contact}}|object_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
The object of the subj-predicate-obj sentence. In a DAG, this corresponds to the parent node.}}
 
The object of the subj-predicate-obj sentence. In a DAG, this corresponds to the parent node.}}
 
{{ChadoColumnsFooter}}
 
{{ChadoColumnsFooter}}
  
 
{{ChadoTablesReferencingHeader|contact_relationship}}
 
{{ChadoTablesReferencingHeader|contact_relationship}}
 
+
* None.</protect>
* None.
+
</protect>
+

Latest revision as of 19:23, 24 November 2010

This template is a Chado Table Template. It defines a single table from the Chado schema, and every Chado table has a template like this one. This template is automatically included in two places:

  1. The module page for the module the table is a part of. This is where updates and comments should be posted.
  2. The Chado Tables page, which lists all tables.

You can include this template anywhere you want to show the table description.


Table: contact_relationship
Module: Contact

Model relationships between contacts

contact_relationship columns
FK 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.

Tables referencing contact_relationship via foreign key constraints:

  • None.