Difference between revisions of "Template:ChadoTable db"
From GMOD
(Table definition, first upload on 2010/11/22.) |
(Table definition for Chado on 2010/11/24) |
||
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
− | <noinclude>{{ChadoTableTemplateHeader}}</noinclude> | + | <protect><noinclude>{{ChadoTableTemplateHeader}}</noinclude> |
+ | {{ChadoTableDesc|General|db|A database authority. Typical databases in | ||
bioinformatics are FlyBase, GO, UniProt, NCBI, MGI, etc. The authority | bioinformatics are FlyBase, GO, UniProt, NCBI, MGI, etc. The authority | ||
is generally known by this shortened form, which is unique within the | is generally known by this shortened form, which is unique within the | ||
Line 7: | Line 8: | ||
decided.}} | decided.}} | ||
{{ChadoColumnsHeader|General|db}} | {{ChadoColumnsHeader|General|db}} | ||
− | {{ChadoColumnDesc||db_id|serial|''PRIMARY KEY'' | + | {{ChadoColumnDesc||db_id|serial|''PRIMARY KEY''<br /> |
− | + | ||
}} | }} | ||
− | {{ChadoColumnDesc||name|character varying(255)|''UNIQUE'' | + | {{ChadoColumnDesc||name|character varying(255)|''UNIQUE''<br /> |
− | + | ''NOT NULL''<br /> | |
− | ''NOT NULL'' | + | |
− | + | ||
}} | }} | ||
{{ChadoColumnDesc||description|character varying(255)|}} | {{ChadoColumnDesc||description|character varying(255)|}} | ||
Line 21: | Line 19: | ||
{{ChadoTablesReferencingHeader|db}} | {{ChadoTablesReferencingHeader|db}} | ||
− | + | {{ChadoReferencingTable|General|dbxref}} | |
− | + | ||
</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: | db |
Module: | General |
A database authority. Typical databases in bioinformatics are FlyBase, GO, UniProt, NCBI, MGI, etc. The authority is generally known by this shortened form, which is unique within the bioinformatics and biomedical realm. To Do - add support for URIs, URNs (e.g. LSIDs). We can do this by treating the URL as a URI - however, some applications may expect this to be resolvable - to be decided.
FK | Name | Type | Description |
---|---|---|---|
db_id | serial | PRIMARY KEY | |
name | character varying(255) | UNIQUE NOT NULL | |
description | character varying(255) | ||
urlprefix | character varying(255) | ||
url | character varying(255) |
Tables referencing db via foreign key constraints: