GeneX Development Supported By
|
GeneX-2.0 DB: SampleLink Table
|
GeneX-2.0 DB: SampleLink Table
|
| Table Type | Inherits | Comment |
| LINKING | none | 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 Name | Full Name | Data Type | Not NULL | Comment |
| pba_fk | PhysicalBioAssay | int | true | The PhysicalBioAssay. |
| smp_fk | Sample | int | true | The sample hybridized |
| Primary Key Information |
| Column Name |
| Foreign Key Information |
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| pba_fk | PhysicalBioAssay | pba_pk | LINKING_TABLE |
| smp_fk | Sample | smp_pk | LINKING_TABLE |
| Unique Column Information |
| Column Names |
| smp_fk pba_fk |
| Index Information |
| Name | Column Name |
| pba_fk | samplelink_pba |
| smp_fk | samplelink_smp |
|