This space is archived
For current information please use the current ExamSys documentation
student_help
- Joseph Baxter
Owned by Joseph Baxter
Mar 20, 2015
Loading data...
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. |