student_help
Purpose: Stores pages for the student online help system.
Joins: users table.
Field | Type | Purpose |
---|---|---|
id | smallint(6) | Primary Key – auto increment. |
title | text | Title of the help page |
body | text | The HTML text of the help page |
body_plain | text | Plain text version of 'body'. Used for searching. |
type | enum('page','pointer') | Type of page. Pointers are used to point to other pages. |
checkout_time | datetime | Datetime when a page is checked out for editing |
checkout_authorID | int(10) unsigned | User ID of the checkout user |
deleted | datetime | Datetime the page was deleted. NULL means the page is still active |
language | char(5) | 6.0: Which language a page is written in. |
articleid | smallint(6) unsigned | 6.0: Master ID for a page regardless of language. |
lastupdated | timestamp | 6.0: When a page was lasted edited. |