Chado Cell Line Module
From GMOD
Introduction
Tables
Table: cell_line
| 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
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
| 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.
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
| 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.
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
| 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:
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
| 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.
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
| 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:
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
| 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.
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
| 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.
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
| 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.
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
| 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.
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
| 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.
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.

