news - OpenPerpetuum/OPDB GitHub Wiki
Description
Contains all data referring to in-game news.
This table contains all the data that is found in the news feed, even though the developers for the past year have been just literally putting in them links to the forums rather than the actual patch notes.
Table Structure
| ID | Type | Name | Description | Properties | Links |
|---|---|---|---|---|---|
| 1 | Number | idx | The index of the news entry. | PRIMARY, UNIQUE | |
| 2 | String | title | What it says on the tin; the header of the news article. | ||
| 3 | String | body | The contents of the news article. | ||
| 4 | DateTime | ntime | The publication time for the article. | ||
| 5 | Number | type | The type of news article. | newscategories.id | |
| 6 | Number | language | The language of the article. |
Notes
body
Not much is known about this, but I presume there would be markdown or some sort of formatting involved.
HTML perhaps?
language
Definitely an enumerator. No clue what numbers mean which language though...
See Also
- newscategories - Categories
- bulletins - Corporation "News"
- bulletinentries - Contents of the "news". Dunno why they split it up.