Control_Sample_2_File_Info
Join table that associates CONTROL_SAMPLE with FILE_INFO table records.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| control_sample_accession | varchar(15) | Foreign key reference to CONTROL_SAMPLE table | control_sample.control_sample_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 | control_sample_accession | BTREE |
| PRIMARY | file_info_id | BTREE |
| idx_control_sample_2_file_info | file_info_id | BTREE |
| idx_control_sample_2_file_info | control_sample_accession | BTREE |
| fk_control_sample_2_file_info_3 | result_schema | BTREE |
Tables that Reference this Table
| Name | Column | Table Reference | Column Reference |
|---|---|---|---|