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
Back to top