Difference between revisions of "Template:ChadoTable contact"
From GMOD
(Table definition for Chado on 2010/11/24) |
(Table definition for Chado on 2010/11/24) |
||
| Line 12: | Line 12: | ||
{{ChadoTablesReferencingHeader|contact}} | {{ChadoTablesReferencingHeader|contact}} | ||
| − | + | {{ChadoReferencingTable|Mage|arraydesign}} | |
| − | + | {{ChadoReferencingTable|Mage|assay}} | |
| − | + | {{ChadoReferencingTable|Mage|biomaterial}} | |
| − | + | {{ChadoReferencingTable|Contact|contact_relationship}} | |
| − | + | {{ChadoReferencingTable|Natural Diversity|nd_experiment_contact}} | |
| − | + | {{ChadoReferencingTable|Project|project_contact}} | |
| − | + | {{ChadoReferencingTable|Mage|quantification}} | |
| − | + | {{ChadoReferencingTable|Stock|stockcollection}} | |
| − | + | {{ChadoReferencingTable|Mage|study}} | |
</protect> | </protect> | ||
Latest revision as of 19:58, 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:
- The module page for the module the table is a part of. This is where updates and comments should be posted.
- The Chado Tables page, which lists all tables.
You can include this template anywhere you want to show the table description.
| Table: | contact |
| Module: | Contact |
Model persons, institutes, groups, organizations, etc.
| FK | 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 contact via foreign key constraints:
- arraydesign
- assay
- biomaterial
- contact_relationship
- nd_experiment_contact
- project_contact
- quantification
- stockcollection
- study
