Table Index

Citation


Defines a literature citation.
Typically a citation is associated with one or more Warehouse objects via the CitationWIDOtherWID table.

Columns

Column MySQL Type Oracle Type Nullable Description
WID BIGINT NUMBER No WID of this citation
Citation TEXT VARCHAR2(4000) Yes Line of text containing the citation
PMID DECIMAL NUMBER Yes Pubmed ID of the citation, if known
Title VARCHAR VARCHAR2(255) Yes Title of the article
Authors VARCHAR VARCHAR2(255) Yes Author name(s)
Publication VARCHAR VARCHAR2(255) Yes Publication title
Publisher VARCHAR VARCHAR2(255) Yes Publisher's name
Editor VARCHAR VARCHAR2(255) Yes Editor's name
Year VARCHAR VARCHAR2(255) Yes Year of publication
Volume VARCHAR VARCHAR2(255) Yes Volume of publication
Issue VARCHAR VARCHAR2(255) Yes Issue number
Pages VARCHAR VARCHAR2(255) Yes Page number(s)
URI VARCHAR VARCHAR2(255) Yes Publication URI
DataSetWID BIGINT NUMBER No WID of the dataset the Citation is from

Referenced By

Table Column
CitationWIDOtherWID CitationWID
Entry OtherWID
Support OtherWID
RelatedTerm OtherWID
CitationWIDOtherWID OtherWID
CommentTable OtherWID
CrossReference OtherWID
CrossReference CrossWID
Description OtherWID
DBID OtherWID
SynonymTable OtherWID
ToolAdvice OtherWID

Other Constraints

None.

Indexes

Name Columns
CITATION_PMID PMID
CITATION_CITATION
CITATION_DATASETWID DataSetWID