Template:ChadoTable library

From GMOD

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:

• cell_line_library
• library_cvterm
• library_dbxref
• library_feature
• library_pub
• library_synonym
• libraryprop