Chado Cell Line Module

From GMOD
Revision as of 04:32, 18 February 2015 by Hlapp (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Introduction

Tables

Table: cell_line

<protect>

Table: cell_line
Module: Cell Line


cell_line columns
FK Name Type Description
cell_line_id serial PRIMARY KEY
name character varying(255)
uniquename character varying(255) UNIQUE#1

NOT NULL

organism organism_id integer UNIQUE#1

NOT NULL

timeaccessioned timestamp without time zone NOT NULL

DEFAULT now()

timelastmodified timestamp without time zone NOT NULL

DEFAULT now()


Tables referencing cell_line via foreign key constraints:

</protect>

cell_line Additional Comments:

Add your comments here and they will be integrated into the schema documentation as part of the next Chado release.

Table: cell_line_relationship

<protect>

Table: cell_line_relationship
Module: Cell Line


cell_line_relationship columns
FK Name Type Description
cell_line_relationship_id serial PRIMARY KEY
cell_line subject_id integer UNIQUE#1

NOT NULL

cell_line object_id integer UNIQUE#1

NOT NULL

cvterm type_id integer UNIQUE#1

NOT NULL


Tables referencing cell_line_relationship via foreign key constraints:

  • None.</protect>

cell_line_relationship Additional Comments:

Add your comments here and they will be integrated into the schema documentation as part of the next Chado release.

Table: cell_line_synonym

<protect>

Table: cell_line_synonym
Module: Cell Line


cell_line_synonym columns
FK Name Type Description
cell_line_synonym_id serial PRIMARY KEY
cell_line cell_line_id integer UNIQUE#1

NOT NULL

synonym synonym_id integer UNIQUE#1

NOT NULL

pub pub_id integer UNIQUE#1

NOT NULL

is_current boolean NOT NULL

DEFAULT false

is_internal boolean NOT NULL

DEFAULT false


Tables referencing cell_line_synonym via foreign key constraints:

  • None.</protect>

cell_line_synonym Additional Comments:

Add your comments here and they will be integrated into the schema documentation as part of the next Chado release.

Table: cell_line_cvterm

<protect>

Table: cell_line_cvterm
Module: Cell Line


cell_line_cvterm columns
FK Name Type Description
cell_line_cvterm_id serial PRIMARY KEY
cell_line cell_line_id integer UNIQUE#1

NOT NULL

cvterm cvterm_id integer UNIQUE#1

NOT NULL

pub pub_id integer UNIQUE#1

NOT NULL

rank integer UNIQUE#1

NOT NULL


Tables referencing cell_line_cvterm via foreign key constraints:

</protect>

cell_line_cvterm Additional Comments:

Add your comments here and they will be integrated into the schema documentation as part of the next Chado release.

Table: cell_line_dbxref

<protect>

Table: cell_line_dbxref
Module: Cell Line


cell_line_dbxref columns
FK Name Type Description
cell_line_dbxref_id serial PRIMARY KEY
cell_line cell_line_id integer UNIQUE#1

NOT NULL

dbxref dbxref_id integer UNIQUE#1

NOT NULL

is_current boolean NOT NULL

DEFAULT true


Tables referencing cell_line_dbxref via foreign key constraints:

  • None.</protect>

cell_line_dbxref Additional Comments:

Add your comments here and they will be integrated into the schema documentation as part of the next Chado release.

Table: cell_lineprop

<protect>

Table: cell_lineprop
Module: Cell Line


cell_lineprop columns
FK Name Type Description
cell_lineprop_id serial PRIMARY KEY
cell_line cell_line_id integer UNIQUE#1

NOT NULL

cvterm type_id integer UNIQUE#1

NOT NULL

value text
rank integer UNIQUE#1

NOT NULL


Tables referencing cell_lineprop via foreign key constraints:

</protect>

cell_lineprop Additional Comments:

Add your comments here and they will be integrated into the schema documentation as part of the next Chado release.

Table: cell_lineprop_pub

<protect>

Table: cell_lineprop_pub
Module: Cell Line


cell_lineprop_pub columns
FK Name Type Description
cell_lineprop_pub_id serial PRIMARY KEY
cell_lineprop cell_lineprop_id integer UNIQUE#1

NOT NULL

pub pub_id integer UNIQUE#1

NOT NULL


Tables referencing cell_lineprop_pub via foreign key constraints:

  • None.</protect>

cell_lineprop_pub Additional Comments:

Add your comments here and they will be integrated into the schema documentation as part of the next Chado release.

Table: cell_line_feature

<protect>

Table: cell_line_feature
Module: Cell Line


cell_line_feature columns
FK Name Type Description
cell_line_feature_id serial PRIMARY KEY
cell_line cell_line_id integer UNIQUE#1

NOT NULL

feature feature_id integer UNIQUE#1

NOT NULL

pub pub_id integer UNIQUE#1

NOT NULL


Tables referencing cell_line_feature via foreign key constraints:

  • None.</protect>

cell_line_feature Additional Comments:

Add your comments here and they will be integrated into the schema documentation as part of the next Chado release.

Table: cell_line_cvtermprop

<protect>

Table: cell_line_cvtermprop
Module: Cell Line


cell_line_cvtermprop columns
FK Name Type Description
cell_line_cvtermprop_id serial PRIMARY KEY
cell_line_cvterm cell_line_cvterm_id integer UNIQUE#1

NOT NULL

cvterm type_id integer UNIQUE#1

NOT NULL

value text
rank integer UNIQUE#1

NOT NULL


Tables referencing cell_line_cvtermprop via foreign key constraints:

  • None.</protect>

cell_line_cvtermprop Additional Comments:

Add your comments here and they will be integrated into the schema documentation as part of the next Chado release.

Table: cell_line_pub

<protect>

Table: cell_line_pub
Module: Cell Line


cell_line_pub columns
FK Name Type Description
cell_line_pub_id serial PRIMARY KEY
cell_line cell_line_id integer UNIQUE#1

NOT NULL

pub pub_id integer UNIQUE#1

NOT NULL


Tables referencing cell_line_pub via foreign key constraints:

  • None.</protect>

cell_line_pub Additional Comments:

Add your comments here and they will be integrated into the schema documentation as part of the next Chado release.

Table: cell_line_library

<protect>

Table: cell_line_library
Module: Cell Line


cell_line_library columns
FK Name Type Description
cell_line_library_id serial PRIMARY KEY
cell_line cell_line_id integer UNIQUE#1

NOT NULL

library library_id integer UNIQUE#1

NOT NULL

pub pub_id integer UNIQUE#1

NOT NULL


Tables referencing cell_line_library via foreign key constraints:

  • None.</protect>

cell_line_library Additional Comments:

Add your comments here and they will be integrated into the schema documentation as part of the next Chado release.