Table Index

Computation

Defines a parameterized computation that has been performed on objects in the warehouse.
TODO: Parameters are specified in the Parameter table.

Columns

Column MySQL Type Oracle Type Nullable Description
WID BIGINT NUMBER No WID of this computation
Name VARCHAR VARCHAR2(50) No Name of the algorithm, procedure, or program, e.g. 'BLAST'
Description TEXT CLOB Yes Description of the computation performed
DataSetWID BIGINT NUMBER No WID of the dataset the computation is from

Referenced By

Table Column
SequenceMatch ComputationWID
RelatedTerm OtherWID
CitationWIDOtherWID OtherWID
CommentTable OtherWID
CrossReference OtherWID
CrossReference CrossWID
Description OtherWID
DBID OtherWID
SynonymTable OtherWID
ToolAdvice OtherWID

Other Constraints

None.

Indexes

Name Columns
COMPUTATION_NAME NAME
COMPUTATION_DATASETWID DataSetWID