Relations between acquisitions are stored here, for example the red and green channels of a two channel microarray. Each acquisition is connected by this table to any it is related to. So for example a 2-channel microarray would require two entries, each channel being the acquisition and associated acquisition in turn. A 3-channel array would require six entries. Etc.
|RELATED_ACQUISITION_ID||no||NUMBER(4,0)||primary key Edit|
|ACQUISITION_ID||no||RAD::Acquisition (NUMBER(8,0) )||FK to Acquisition, pointing to the primary acquisition for this entry. Edit|
|ASSOCIATED_ACQUISITION_ID||no||RAD::Acquisition (NUMBER(8,0) )||FK to the acquistion ID of the related acquisition for this entry. Edit|
|NAME||STRING(100)||Each relation can be given a name for user reference. Edit|
|DESIGNATION||STRING(50)||The designation, if any, of the main acquisition. E.g. red dye or green dye, etc.. Edit|
|ASSOCIATED_DESIGNATION||STRING(50)||The designation, if any, of the associated acquisition. E.g. red dye or green die, etc.. Edit|