Archive:Database tables

This documentation is work in progress; some sections are not finished yet. Has parent page::Database schema

This page documents tables used in SMW(1.8alpha) SQLStore3

Introduction
SMW does a very complex task of retrieving query results from a SQL store so it has a big set of tables.

Table Types
The tables are for various different tasks as listed below

Property Tables
These are tables to store Property-Values in SMW.

Special Properties Tables
SMW has a specific table for each special property it uses internally to speed up frequent lookups An array of the tables for each special property is declared in SMW_SQLStore3.php as follows.

Normal Property Tables
User defined properties are stored in Tables assigned for each datatype. An array of the tables for each special property is declared in SMW_SQLStore3.php as follows These are declared as follows in SMW_SQLStore3.php

Fixed Property Tables
Fixed Properties are properties that are user defined but intensively used in the wiki. Hence these have their own tables created by the SMWAdmin interface. Names of these tables are made using a hash appended on the property name.

General Tables
Besides tables for Properties SMW also has a few other tables for some specific information
 * Table for ids of each page in the wiki named `smw_ids`
 * Table for concepts cache status `smw_conccache`
 * Table for usage statistics of each property `smw_stats`