Description of Schema


Tables

cell_line
cell_line_relationship
cell_line_synonym
cell_line_cvterm
cell_line_dbxref
cell_lineprop
cell_lineprop_pub
cell_line_feature
cell_line_cvtermprop
cell_line_pub
cell_line_library

cell_line

Top
Comments:

==========================================
Chado cell line module
============
DEPENDENCIES
============
:import feature from sequence
:import synonym from sequence
:import library from library
:import cvterm from cv
:import dbxref from db
:import pub from pub
:import organism from organism
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
================================================
TABLE: cell_line
================================================
Field Name Data Type Size Default Value Other Foreign Key
cell_line_id integer 20 PRIMARY KEY, NOT NULL
name varchar 255 NULL
uniquename varchar 255 UNIQUE, NOT NULL
organism_id integer 20 UNIQUE, NOT NULL organism.organism_id
timeaccessioned timestamp 0 current_timestamp NOT NULL
timelastmodified timestamp 0 current_timestamp NOT NULL

Constraints

Type Fields
NOT NULLcell_line_id
NOT NULLuniquename
NOT NULLorganism_id
FOREIGN KEYorganism_id
NOT NULLtimeaccessioned
NOT NULLtimelastmodified
UNIQUEuniquename, organism_id

cell_line_relationship

Top
Comments:

================================================
TABLE: cell_line_relationship
================================================
Field Name Data Type Size Default Value Other Foreign Key
cell_line_relationship_id integer 20 PRIMARY KEY, NOT NULL
subject_id integer 20 UNIQUE, NOT NULL cell_line.cell_line_id
object_id integer 20 UNIQUE, NOT NULL cell_line.cell_line_id
type_id integer 20 UNIQUE, NOT NULL cvterm.cvterm_id

Constraints

Type Fields
NOT NULLcell_line_relationship_id
NOT NULLsubject_id
FOREIGN KEYsubject_id
NOT NULLobject_id
FOREIGN KEYobject_id
NOT NULLtype_id
FOREIGN KEYtype_id
UNIQUEsubject_id, object_id, type_id

cell_line_synonym

Top
Comments:

================================================
TABLE: cell_line_synonym
================================================
Field Name Data Type Size Default Value Other Foreign Key
cell_line_synonym_id integer 20 PRIMARY KEY, NOT NULL
cell_line_id integer 20 UNIQUE, NOT NULL cell_line.cell_line_id
synonym_id integer 20 UNIQUE, NOT NULL synonym.synonym_id
pub_id integer 20 UNIQUE, NOT NULL pub.pub_id
is_current boolean 0 false NOT NULL
is_internal boolean 0 false NOT NULL

Constraints

Type Fields
NOT NULLcell_line_synonym_id
NOT NULLcell_line_id
FOREIGN KEYcell_line_id
NOT NULLsynonym_id
FOREIGN KEYsynonym_id
NOT NULLpub_id
FOREIGN KEYpub_id
NOT NULLis_current
NOT NULLis_internal
UNIQUEsynonym_id, cell_line_id, pub_id

cell_line_cvterm

Top
Comments:

================================================
TABLE: cell_line_cvterm
================================================
Field Name Data Type Size Default Value Other Foreign Key
cell_line_cvterm_id integer 20 PRIMARY KEY, NOT NULL
cell_line_id integer 20 UNIQUE, NOT NULL cell_line.cell_line_id
cvterm_id integer 20 UNIQUE, NOT NULL cvterm.cvterm_id
pub_id integer 20 UNIQUE, NOT NULL pub.pub_id
rank integer 10 0 UNIQUE, NOT NULL

Constraints

Type Fields
NOT NULLcell_line_cvterm_id
NOT NULLcell_line_id
FOREIGN KEYcell_line_id
NOT NULLcvterm_id
FOREIGN KEYcvterm_id
NOT NULLpub_id
FOREIGN KEYpub_id
NOT NULLrank
UNIQUEcell_line_id, cvterm_id, pub_id, rank

cell_line_dbxref

Top
Comments:

================================================
TABLE: cell_line_dbxref
================================================
Field Name Data Type Size Default Value Other Foreign Key
cell_line_dbxref_id integer 20 PRIMARY KEY, NOT NULL
cell_line_id integer 20 UNIQUE, NOT NULL cell_line.cell_line_id
dbxref_id integer 20 UNIQUE, NOT NULL dbxref.dbxref_id
is_current boolean 0 true NOT NULL

Constraints

Type Fields
NOT NULLcell_line_dbxref_id
NOT NULLcell_line_id
FOREIGN KEYcell_line_id
NOT NULLdbxref_id
FOREIGN KEYdbxref_id
NOT NULLis_current
UNIQUEcell_line_id, dbxref_id

cell_lineprop

Top
Comments:

================================================
TABLE: cell_lineprop
================================================
Field Name Data Type Size Default Value Other Foreign Key
cell_lineprop_id integer 20 PRIMARY KEY, NOT NULL
cell_line_id integer 20 UNIQUE, NOT NULL cell_line.cell_line_id
type_id integer 20 UNIQUE, NOT NULL cvterm.cvterm_id
value text 64000 NULL
rank integer 10 0 UNIQUE, NOT NULL

Constraints

Type Fields
NOT NULLcell_lineprop_id
NOT NULLcell_line_id
FOREIGN KEYcell_line_id
NOT NULLtype_id
FOREIGN KEYtype_id
NOT NULLrank
UNIQUEcell_line_id, type_id, rank

cell_lineprop_pub

Top
Comments:

================================================
TABLE: cell_lineprop_pub
================================================
Field Name Data Type Size Default Value Other Foreign Key
cell_lineprop_pub_id integer 20 PRIMARY KEY, NOT NULL
cell_lineprop_id integer 20 UNIQUE, NOT NULL cell_lineprop.cell_lineprop_id
pub_id integer 20 UNIQUE, NOT NULL pub.pub_id

Constraints

Type Fields
NOT NULLcell_lineprop_pub_id
NOT NULLcell_lineprop_id
FOREIGN KEYcell_lineprop_id
NOT NULLpub_id
FOREIGN KEYpub_id
UNIQUEcell_lineprop_id, pub_id

cell_line_feature

Top
Comments:

================================================
TABLE: cell_line_feature
================================================
Field Name Data Type Size Default Value Other Foreign Key
cell_line_feature_id integer 20 PRIMARY KEY, NOT NULL
cell_line_id integer 20 UNIQUE, NOT NULL cell_line.cell_line_id
feature_id integer 20 UNIQUE, NOT NULL feature.feature_id
pub_id integer 20 UNIQUE, NOT NULL pub.pub_id

Constraints

Type Fields
NOT NULLcell_line_feature_id
NOT NULLcell_line_id
FOREIGN KEYcell_line_id
NOT NULLfeature_id
FOREIGN KEYfeature_id
NOT NULLpub_id
FOREIGN KEYpub_id
UNIQUEcell_line_id, feature_id, pub_id

cell_line_cvtermprop

Top
Comments:

================================================
TABLE: cell_line_cvtermprop
================================================
Field Name Data Type Size Default Value Other Foreign Key
cell_line_cvtermprop_id integer 20 PRIMARY KEY, NOT NULL
cell_line_cvterm_id integer 20 UNIQUE, NOT NULL cell_line_cvterm.cell_line_cvterm_id
type_id integer 20 UNIQUE, NOT NULL cvterm.cvterm_id
value text 64000 NULL
rank integer 10 0 UNIQUE, NOT NULL

Constraints

Type Fields
NOT NULLcell_line_cvtermprop_id
NOT NULLcell_line_cvterm_id
FOREIGN KEYcell_line_cvterm_id
NOT NULLtype_id
FOREIGN KEYtype_id
NOT NULLrank
UNIQUEcell_line_cvterm_id, type_id, rank

cell_line_pub

Top
Comments:

================================================
TABLE: cell_line_pub
================================================
Field Name Data Type Size Default Value Other Foreign Key
cell_line_pub_id integer 20 PRIMARY KEY, NOT NULL
cell_line_id integer 20 UNIQUE, NOT NULL cell_line.cell_line_id
pub_id integer 20 UNIQUE, NOT NULL pub.pub_id

Constraints

Type Fields
NOT NULLcell_line_pub_id
NOT NULLcell_line_id
FOREIGN KEYcell_line_id
NOT NULLpub_id
FOREIGN KEYpub_id
UNIQUEcell_line_id, pub_id

cell_line_library

Top
Comments:

================================================
TABLE: cell_line_library
================================================
Field Name Data Type Size Default Value Other Foreign Key
cell_line_library_id integer 20 PRIMARY KEY, NOT NULL
cell_line_id integer 20 UNIQUE, NOT NULL cell_line.cell_line_id
library_id integer 20 UNIQUE, NOT NULL library.library_id
pub_id integer 20 UNIQUE, NOT NULL pub.pub_id

Constraints

Type Fields
NOT NULLcell_line_library_id
NOT NULLcell_line_id
FOREIGN KEYcell_line_id
NOT NULLlibrary_id
FOREIGN KEYlibrary_id
NOT NULLpub_id
FOREIGN KEYpub_id
UNIQUEcell_line_id, library_id, pub_id

Created by
SQL::Translator 0.11020