Chado Cell Line Module
Contents
- 1 Introduction
- 2 Tables
- 2.1 Table: cell_line
- 2.2 Table: cell_line_relationship
- 2.3 Table: cell_line_synonym
- 2.4 Table: cell_line_cvterm
- 2.5 Table: cell_line_dbxref
- 2.6 Table: cell_lineprop
- 2.7 Table: cell_lineprop_pub
- 2.8 Table: cell_line_feature
- 2.9 Table: cell_line_cvtermprop
- 2.10 Table: cell_line_pub
- 2.11 Table: cell_line_library
Introduction
Tables
Table: cell_line
<protect>
Table: | cell_line |
Module: | Cell Line |
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:
- cell_line_cvterm
- cell_line_dbxref
- cell_line_feature
- cell_line_library
- cell_line_pub
- cell_line_relationship
- cell_line_synonym
- cell_lineprop
</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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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.