GeneX-2.0 DB: SampleLink Table
GeneX-2.0 DB: SampleLink Table
Table TypeInheritsComment
LINKINGnone The SampleLink table creates a many-to-many relationship between Sample and PhysicalBioAssay. A PhysicalBioAssay may be hybridized with any number of samples.

Column Information
Column NameFull NameData TypeNot NULLComment
pba_fkPhysicalBioAssayinttrueThe PhysicalBioAssay.
smp_fkSampleinttrueThe sample hybridized

Primary Key Information
Column Name

Foreign Key Information
Column NameForeign TablePrimary Key in Foreign TableForeign Key Type
pba_fkPhysicalBioAssaypba_pkLINKING_TABLE
smp_fkSamplesmp_pkLINKING_TABLE

Unique Column Information
Column Names
smp_fk pba_fk

Index Information
NameColumn Name
pba_fksamplelink_pba
smp_fksamplelink_smp