Expsample_Public_Repository
EXPSAMPLE_PUBLIC_REPOSITORY stores the public repository accessions linked to an EXPSAMPLE.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| result_id | int(11) | Primary key | |
| expsample_accession | varchar(15) | Foreign Key to the expsample table | expsample.expsample_accession |
| repository_accession | varchar(20) | Foreign key reference to a public repository | |
| repository_name | varchar(50) | Name or identifier | lk_public_repository.name |
Indexes
| Name | Column | Description |
|---|---|---|
| PRIMARY | result_id | BTREE |
| idx_exp_public_repository | expsample_accession | BTREE |
| idx_exp_public_repository | repository_accession | BTREE |
| fk_expsample_public_2 | repository_name | BTREE |
Tables that Reference this Table
| Name | Column | Table Reference | Column Reference |
|---|---|---|---|