GUS Schema >> RAD::RelatedAcquisition

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.

column nulls? type description
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
MODIFICATION_DATE no DATE Edit
USER_READ no NUMBER(1,0) Edit
USER_WRITE no NUMBER(1,0) Edit
GROUP_READ no NUMBER(1,0) Edit
GROUP_WRITE no NUMBER(1,0) Edit
OTHER_READ no NUMBER(1,0) Edit
OTHER_WRITE no NUMBER(1,0) Edit
ROW_USER_ID no NUMBER(12,0) Edit
ROW_GROUP_ID no NUMBER(4,0) Edit
ROW_PROJECT_ID no NUMBER(4,0) Edit
ROW_ALG_INVOCATION_ID no NUMBER(12,0) Edit

Child tables:

Subclasses: