GeneX Development Supported By
|
GeneX-2.0 DB: Chromosome Table
|
GeneX-2.0 DB: Chromosome Table
|
| Table Type | Inherits | Comment |
| DATA | Identifiable | The Chromosome table gives information about each chromosome in a given species' genome. It is used to generate the view of expression levels on a simple linear representation of the genome. Chromosome does not use a separate security entry, instead it uses the entry for it's corresponding species |
| Column Information |
| Column Name | Full Name | Data Type | Not NULL | Comment |
| chr_pk | Accession Number | serial | false | |
| length | Length | int | true | |
| spc_fk | Species | int | true | |
| Primary Key Information |
| Column Name |
| chr_pk |
| Foreign Key Information |
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| spc_fk | Species | spc_pk | MANY_TO_ONE |
| Unique Column Information |
| Column Names |
| name spc_fk |
| Index Information |
| Name | Column Name |
| spc_fk | chromosome_spc_fk |
|