Difference between revisions of "Template:ChadoTable library"

From GMOD
Jump to: navigation, search
(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>{{ChadoTableDesc|Library|library|}}
+
<protect><noinclude>{{ChadoTableTemplateHeader}}</noinclude>
 +
{{ChadoTableDesc|Library|library|}}
 
{{ChadoColumnsHeader|Library|library}}
 
{{ChadoColumnsHeader|Library|library}}
{{ChadoColumnDesc||library_id|serial|''PRIMARY KEY''
+
{{ChadoColumnDesc||library_id|serial|''PRIMARY KEY''<br />
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|Organism|organism}}|organism_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|Organism|organism}}|organism_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
 
{{ChadoColumnDesc||name|character varying(255)|}}
 
{{ChadoColumnDesc||name|character varying(255)|}}
{{ChadoColumnDesc||uniquename|text|''UNIQUE#1''
+
{{ChadoColumnDesc||uniquename|text|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|CV|cvterm}}|type_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|CV|cvterm}}|type_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
The type_id foreign key links
 
The type_id foreign key links
 
to a controlled vocabulary of library types. Examples of this would be: &quot;cDNA_library&quot; or &quot;genomic_library&quot;}}
 
to a controlled vocabulary of library types. Examples of this would be: &quot;cDNA_library&quot; or &quot;genomic_library&quot;}}
{{ChadoColumnDesc||is_obsolete|integer|''NOT NULL''
+
{{ChadoColumnDesc||is_obsolete|integer|''NOT NULL''<br />
 
+
 
}}
 
}}
{{ChadoColumnDesc||timeaccessioned|timestamp without time zone|''NOT NULL''
+
{{ChadoColumnDesc||timeaccessioned|timestamp without time zone|''NOT NULL''<br />
 
+
''DEFAULT ''now()<br />
''DEFAULT ''now()
+
 
+
 
}}
 
}}
{{ChadoColumnDesc||timelastmodified|timestamp without time zone|''NOT NULL''
+
{{ChadoColumnDesc||timelastmodified|timestamp without time zone|''NOT NULL''<br />
 
+
''DEFAULT ''now()<br />
''DEFAULT ''now()
+
 
+
 
}}
 
}}
 
{{ChadoColumnsFooter}}
 
{{ChadoColumnsFooter}}
  
 
{{ChadoTablesReferencingHeader|library}}
 
{{ChadoTablesReferencingHeader|library}}
 
+
{{ChadoReferencingTable|Cell Line|cell_line_library}}
* None.
+
{{ChadoReferencingTable|Library|library_cvterm}}
 +
{{ChadoReferencingTable|Library|library_dbxref}}
 +
{{ChadoReferencingTable|Library|library_feature}}
 +
{{ChadoReferencingTable|Library|library_pub}}
 +
{{ChadoReferencingTable|Library|library_synonym}}
 +
{{ChadoReferencingTable|Library|libraryprop}}
 
</protect>
 
</protect>

Latest revision as of 19:59, 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: library
Module: Library


library columns
FK Name Type Description
library_id serial PRIMARY KEY
organism organism_id integer UNIQUE#1

NOT NULL

name character varying(255)
uniquename text UNIQUE#1

NOT NULL

cvterm type_id integer UNIQUE#1

NOT NULL
The type_id foreign key links to a controlled vocabulary of library types. Examples of this would be: "cDNA_library" or "genomic_library"

is_obsolete integer NOT NULL
timeaccessioned timestamp without time zone NOT NULL

DEFAULT now()

timelastmodified timestamp without time zone NOT NULL

DEFAULT now()


Tables referencing library via foreign key constraints: