GeneX-2.0 DB: DerivedBioAssay Table
GeneX-2.0 DB: DerivedBioAssay Table
Table TypeInheritsComment
DATAIdentifiableThe DerivedBioAssay table holds the meta-data associated with a data matrix stored in a dynamic data table

Column Information
Column NameFull NameData TypeNot NULLComment
channelChannelchar128falsecontrolled vocab
data_table_nameDerivedBioAssay Data Tablechar32truethe name of the table that contains the numerical data for this DerivedBioAssay
dba_pkAccession Numberserialfalse
spot_table_nameSpot Table Namechar32trueThe DerivedBioAssyData tables have a 'spot_identifier' column that uniquely identifies each 'spot'. This identifies to which table spot_identifier is a foreign key

Primary Key Information
Column Name
dba_pk

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

Unique Column Information
Column Names

Index Information
NameColumn Name