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()
|
cell_line columns
Tables referencing cell_line via foreign
key constraints:
cell_line_cvtermcell_line_dbxrefcell_line_featurecell_line_librarycell_line_pubcell_line_relationshipcell_line_synonymcell_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.
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
|
cell_line_relationship columns
Tables referencing cell_line_relationship via foreign
key constraints:
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.
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
|
cell_line_synonym columns
Tables referencing cell_line_synonym via foreign
key constraints:
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.
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
|
cell_line_cvterm columns
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.
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
|
cell_line_dbxref columns
Tables referencing cell_line_dbxref via foreign
key constraints:
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.
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
|
cell_lineprop columns
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.
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
|
cell_lineprop_pub columns
Tables referencing cell_lineprop_pub via foreign
key constraints:
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.
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
|
cell_line_feature columns
Tables referencing cell_line_feature via foreign
key constraints:
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.
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
|
cell_line_cvtermprop columns
Tables referencing cell_line_cvtermprop via foreign
key constraints:
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.
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
|
cell_line_pub columns
Tables referencing cell_line_pub via foreign
key constraints:
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.
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
|
cell_line_library columns
Tables referencing cell_line_library via foreign
key constraints:
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.