Table Index

CommentTable


This table allows for arbitrary association of (possibly lengthy) comments
with any object in the warehouse.
See the Description table for a more specific type of comment.

Columns

Column MySQL Type Oracle Type Nullable Description
OtherWID BIGINT NUMBER No Warehouse id of an object
Comm LONGTEXT CLOB Yes Comment about the object

Denormalized References

Column References
OtherWID Chemical : WID
OtherWID Reaction : WID
OtherWID Protein : WID
OtherWID Feature : WID
OtherWID Function : WID
OtherWID EnzymaticReaction : WID
OtherWID GeneticCode : WID
OtherWID Division : WID
OtherWID Taxon : WID
OtherWID BioSource : WID
OtherWID BioSubtype : WID
OtherWID NucleicAcid : WID
OtherWID Subsequence : WID
OtherWID Gene : WID
OtherWID Pathway : WID
OtherWID Term : WID
OtherWID Computation : WID
OtherWID Citation : WID
OtherWID Contact : WID
OtherWID Archive : WID
OtherWID Experiment : WID
OtherWID ExperimentData : WID
OtherWID Support : WID

Referenced By

None.

Other Constraints

None.

Indexes

Name Columns
COMMENT_OTHERWID OTHERWID