GeneX Development Supported By
|
GeneX-2.0 DB: ExperimentSetLink Table
|
GeneX-2.0 DB: ExperimentSetLink Table
|
| Table Type | Inherits | Comment |
| DATA | none | 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 Name | Full Name | Data Type | Not NULL | Comment |
| bioassay_fk | BioAssay | int | true | the foreign key to the BioAssay. |
| es_fk | Experiment Set | int | true | the experiment |
| table_name | BioAssay Table | char32 | false | the name of the table to which the bioassay_fk points, either PhysicalBioAssay, MeasuredBioAssay, or DerivedBioAssay |
| Primary Key Information |
| Column Name |
| Foreign Key Information |
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| es_fk | ExperimentSet | es_pk | LINKING_TABLE |
| Unique Column Information |
| Column Names |
| bioassay_fk es_fk |
| Index Information |
| Name | Column Name |
| bioassay_fk | eslink_bioassay_fk |
| es_fk | eslink_es_fk |
|