User:Nischayn22/Table Structure

From semantic-mediawiki.org
Jump to: navigation, search
Nischayn22User:Nischayn22/Table Structure

Table:smw_ids

This table is normally used to map page names (and other "names") to integer ids(smw_id).

smw_id

These ids are referenced in all other SMW Tables.

smw_iw

is used to store interwiki names.

  • Rows with iw SMW_SQL2_SMWREDIIW are similar to normal entries for (internal) wiki pages, but the iw indicates that the page is a redirect, the target of which should be sought using the smw_redi2 table.
  • The (unique) row with iw SMW_SQL2_SMWBORDERIW just marks the border between predefined ids (rows that are reserved for hardcoded ids built into SMW) and normal entries. It is no object, but makes sure that SQL's auto increment counter is high enough to not add any objects before that marked "border".

smw_title

The title of the page as in table page(column: page_id)

smw_namespace

The namespace id of the page as in table page(column: page_namespace)

smw_subobject

smw_sortkey

Table:smw_atts2

s_id

p_id