User: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_sortkey
=Table:smw_atts2=