Archive

Defines an association between a warehouse entity and an external representation or depiction
of that entity in a well-defined format.
Can be used to store the contents itself, or to indicate that an archive is present at a URL.

Columns

Column	MySQL Type	Oracle Type	Nullable	Description
WID	BIGINT	NUMBER	No	Warehouse identifier for this entity
OtherWID	BIGINT	NUMBER	No	WID of entity archive is associated with
Format	VARCHAR	VARCHAR2(10)	No	Storage/compression format used eg. 'zip' 'tar' 'tgz' 'jpeg'
Contents	LONGBLOB	BLOB	Yes	Archive contents
URL	TEXT	VARCHAR2(4000)	Yes	Web address the archive is found at, ideally a specific file
ToolName	VARCHAR	VARCHAR2(50)	Yes	The name of the tool or software kit the archive is used by eg. 'MIAMExpress'
DataSetWID	BIGINT	NUMBER	No	DataSet.WID this entity is associated with

Referenced By

Table	Column
Experiment	ArchiveWID
RelatedTerm	OtherWID
CitationWIDOtherWID	OtherWID
CommentTable	OtherWID
CrossReference	OtherWID
CrossReference	CrossWID
Description	OtherWID
DBID	OtherWID
SynonymTable	OtherWID
ToolAdvice	OtherWID

Other Constraints

None.

Indexes

Name	Columns
ARCHIVE_OTHERWID	OTHERWID
ARCHIVE_TOOL	TOOLNAME
ARCHIVE_DATASETWID	DataSetWID