Table Index

Entry


Defines metadata describing a warehouse object.
Every warehouse object (that is, anything with a WID column) must have an associated Entry row.

Columns

Column MySQL Type Oracle Type Nullable Description
OtherWID BIGINT NUMBER No Warehouse ID of the entity
InsertDate DATETIME DATE No Date entity was stored in the warehouse
CreationDate DATETIME DATE Yes Date entity was created in its source dataset
ModifiedDate DATETIME DATE Yes Date that the entry was last modified, either
in the warehouse or in the source dataset
LoadError CHAR(1) CHAR(1) No 'T' if an error (eg. parse error on some field of the entry)
occured during loading of this entry into the warehouse, else 'F'.
LineNumber INT NUMBER Yes Either line number or entry number from dataset source file
ErrorMessage TEXT VARCHAR2(4000) Yes Message describing error, if any
DatasetWID BIGINT NUMBER No The dataset the entity is from

Denormalized References

Column References
OtherWID Chemical : WID
OtherWID Element : WID
OtherWID Reaction : WID
OtherWID Protein : WID
OtherWID Feature : WID
OtherWID Function : WID
OtherWID EnzymaticReaction : WID
OtherWID Gene : WID
OtherWID BioSource : WID
OtherWID Pathway : WID
OtherWID NucleicAcid : WID
OtherWID Term : WID
OtherWID Support : WID
OtherWID Citation : WID
OtherWID Division : WID
OtherWID GeneticCode : WID
OtherWID Taxon : WID

Referenced By

None.

Other Constraints

None.

Indexes

Name Columns
ENTRY_INSERTDATE InsertDate
ENTRY_CREATEDATE CreationDate
ENTRY_MODDATE ModifiedDate
ENTRY_DATASETWID DatasetWID