User:Nischayn22/Table Structure

From semantic-mediawiki.org
< Nischay Nahata
Nischay NahataUser:Nischayn22/Table Structure

Table:smw_ids[edit]

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

smw_id[edit]

These ids are referenced in all other SMW Tables.

smw_iw[edit]

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[edit]

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

smw_namespace[edit]

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

smw_subobject[edit]

smw_sortkey[edit]

Table:smw_atts2[edit]

s_id[edit]

p_id[edit]