Toolserver:Database schema/Article text and associated

Page
Each PAGE has an entry here which identifies it by title and contains some essential metadata.

Text

 * This table does not carry any current text (all July 2005 or older).
 * If your tool requires access to current text, please see the WikiProxy page on Meta.

Redirect
+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field       | Type            | Null | Key | Default | Extra |
 * rd_from     | int(8) unsigned | NO   |     | 0       |       |
 * rd_namespace | int(11)        | NO   |     | 0       |       |
 * rd_title    | varchar(255)    | NO   |     |         |       |

Pagelinks
+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field       | Type            | Null | Key | Default | Extra |
 * pl_from     | int(8) unsigned | NO   |     | 0       |       |
 * pl_namespace | int(11)        | NO   |     | 0       |       |
 * pl_title    | varchar(255)    | NO   |     |         |       |

Templatelinks
+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field       | Type            | Null | Key | Default | Extra |
 * tl_from     | int(8) unsigned | NO   |     | 0       |       |
 * tl_namespace | int(11)        | NO   |     | 0       |       |
 * tl_title    | varchar(255)    | NO   |     |         |       |

Categorylinks
+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field       | Type            | Null | Key | Default             | Extra |
 * cl_from     | int(8) unsigned | NO   |     | 0                   |       |
 * cl_to       | varchar(255)    | NO   |     |                     |       |
 * cl_sortkey  | varchar(86)     | NO   |     |                     |       |
 * cl_timestamp | timestamp      | NO   |     | 0000-00-00 00:00:00 |       |

Langlinks
+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field   | Type            | Null | Key | Default | Extra |
 * ll_from | int(8) unsigned | NO   |     | 0       |       |
 * ll_lang | varchar(10)     | NO   |     |         |       |
 * ll_title | varchar(255)   | NO   |     |         |       |