GeneX-2.0 DB: ExperimentSetLink Table
GeneX-2.0 DB: ExperimentSetLink Table
Table TypeInheritsComment
DATAnone The ExperimentSetLink table allows many BioAssay's (Physical, Measured or Derived) to belong to a given ExperimentSet, and it enables each BioAssay to belong to multiple ExperimentSet's.

Column Information
Column NameFull NameData TypeNot NULLComment
bioassay_fkBioAssayinttruethe foreign key to the BioAssay.
es_fkExperiment Setinttruethe experiment
table_nameBioAssay Tablechar32falsethe name of the table to which the bioassay_fk points, either PhysicalBioAssay, MeasuredBioAssay, or DerivedBioAssay

Primary Key Information
Column Name

Foreign Key Information
Column NameForeign TablePrimary Key in Foreign TableForeign Key Type
es_fkExperimentSetes_pkLINKING_TABLE

Unique Column Information
Column Names
bioassay_fk es_fk

Index Information
NameColumn Name
bioassay_fkeslink_bioassay_fk
es_fkeslink_es_fk