sitedocs_

This table maps documents owned by a site to the docs_ table, where the actual content resides.

Primary key: SiteDocID_

Field Name

Description

Version Added

SiteDocID_

An auto-numbering column to provide a unique identifier for this row. (int, NOT NULL)

IsDefault_

Is this a default document? (bool)

SiteID_

The site that this document is associated with. (int NOT NULL)

DocID_

The ID of the document in the docs_ table. (int NOT NULL)

MessageTypeID_

The type of the document, from the messagetypes_ table. (int, NOT NULL)

TranslateLangID_

The language of this document, from the translatelang_ table. (int, NOT NULL)