# 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 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

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 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

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 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

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 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

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 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

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 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

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 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

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 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

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 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

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 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

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 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

Created by SQL::Translator 0.11020