Child pages
  • DOCUMENT_KEYWORDS

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

his table does not contain actual keyword data. Rather, it is a relationship table between DOCUMENT and KEYWORD. Each record in this table describes a "Document was tagged with Keyword" relationship.

This table contains the following fields:

  • DOCUMENT_KEYWORDS_DOCUMENT_FK: The foreign key into the DOCUMENT table.
  • DOCUMENT_KEYWORDS_KEYWORD_FK: The foreign key into the KEYWORD table.
  • ORDER_LISTED: The order in which this author was listed in the "ID"/"DE"/etc. fields. Currently is 0-based (so the first is 0, the second 1, etc.), though that is likely to change soon.

See DOCUMENT_KEYWORDS and KEYWORD for additional details.