staff_help
- Neill Magill
Owned by Neill Magill
Oct 25, 2022
1 min read
Loading data...
Purpose: Stores pages for the staff 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 |
| roles | enum('SysAdmin','Admin','Staff') | Type of staff who can view the page. |
| 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. |