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 |
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 |
Type | Fields |
---|---|
NOT NULL | cell_line_id |
NOT NULL | uniquename |
NOT NULL | organism_id |
FOREIGN KEY | organism_id |
NOT NULL | timeaccessioned |
NOT NULL | timelastmodified |
UNIQUE | uniquename, organism_id |
cell_line_relationship | Top |
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 |
Type | Fields |
---|---|
NOT NULL | cell_line_relationship_id |
NOT NULL | subject_id |
FOREIGN KEY | subject_id |
NOT NULL | object_id |
FOREIGN KEY | object_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
UNIQUE | subject_id, object_id, type_id |
cell_line_synonym | Top |
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 |
Type | Fields |
---|---|
NOT NULL | cell_line_synonym_id |
NOT NULL | cell_line_id |
FOREIGN KEY | cell_line_id |
NOT NULL | synonym_id |
FOREIGN KEY | synonym_id |
NOT NULL | pub_id |
FOREIGN KEY | pub_id |
NOT NULL | is_current |
NOT NULL | is_internal |
UNIQUE | synonym_id, cell_line_id, pub_id |
cell_line_cvterm | Top |
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 |
Type | Fields |
---|---|
NOT NULL | cell_line_cvterm_id |
NOT NULL | cell_line_id |
FOREIGN KEY | cell_line_id |
NOT NULL | cvterm_id |
FOREIGN KEY | cvterm_id |
NOT NULL | pub_id |
FOREIGN KEY | pub_id |
NOT NULL | rank |
UNIQUE | cell_line_id, cvterm_id, pub_id, rank |
cell_line_dbxref | Top |
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 |
Type | Fields |
---|---|
NOT NULL | cell_line_dbxref_id |
NOT NULL | cell_line_id |
FOREIGN KEY | cell_line_id |
NOT NULL | dbxref_id |
FOREIGN KEY | dbxref_id |
NOT NULL | is_current |
UNIQUE | cell_line_id, dbxref_id |
cell_lineprop | Top |
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 |
Type | Fields |
---|---|
NOT NULL | cell_lineprop_id |
NOT NULL | cell_line_id |
FOREIGN KEY | cell_line_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
NOT NULL | rank |
UNIQUE | cell_line_id, type_id, rank |
cell_lineprop_pub | Top |
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 |
Type | Fields |
---|---|
NOT NULL | cell_lineprop_pub_id |
NOT NULL | cell_lineprop_id |
FOREIGN KEY | cell_lineprop_id |
NOT NULL | pub_id |
FOREIGN KEY | pub_id |
UNIQUE | cell_lineprop_id, pub_id |
cell_line_feature | Top |
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 |
Type | Fields |
---|---|
NOT NULL | cell_line_feature_id |
NOT NULL | cell_line_id |
FOREIGN KEY | cell_line_id |
NOT NULL | feature_id |
FOREIGN KEY | feature_id |
NOT NULL | pub_id |
FOREIGN KEY | pub_id |
UNIQUE | cell_line_id, feature_id, pub_id |
cell_line_cvtermprop | Top |
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 |
Type | Fields |
---|---|
NOT NULL | cell_line_cvtermprop_id |
NOT NULL | cell_line_cvterm_id |
FOREIGN KEY | cell_line_cvterm_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
NOT NULL | rank |
UNIQUE | cell_line_cvterm_id, type_id, rank |
cell_line_pub | Top |
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 |
Type | Fields |
---|---|
NOT NULL | cell_line_pub_id |
NOT NULL | cell_line_id |
FOREIGN KEY | cell_line_id |
NOT NULL | pub_id |
FOREIGN KEY | pub_id |
UNIQUE | cell_line_id, pub_id |
cell_line_library | Top |
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 |
Type | Fields |
---|---|
NOT NULL | cell_line_library_id |
NOT NULL | cell_line_id |
FOREIGN KEY | cell_line_id |
NOT NULL | library_id |
FOREIGN KEY | library_id |
NOT NULL | pub_id |
FOREIGN KEY | pub_id |
UNIQUE | cell_line_id, library_id, pub_id |