Expsample_2_File_Info
Join table that associates EXPSAMPLE with FILE_INFO table records.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| expsample_accession | varchar(15) | Foreign key reference to EXPSAMPLE table | expsample.expsample_accession |
| file_info_id | int(11) | Foreign key reference to FILE_INFO table | file_info.file_info_id |
| result_schema | varchar(50) | Standardized value in LK_RESULT_SCHEMA | lk_expsample_result_schema.name |
Indexes
| Name | Column | Description |
|---|---|---|
| PRIMARY | expsample_accession | BTREE |
| PRIMARY | file_info_id | BTREE |
| idx_expsample_2_file_info | file_info_id | BTREE |
| idx_expsample_2_file_info | expsample_accession | BTREE |
| fk_expsample_2_file_info_3 | result_schema | BTREE |
Tables that Reference this Table
| Name | Column | Table Reference | Column Reference |
|---|---|---|---|