In SEDE the PostHistory table holds for PostHistoryTypeId's 33 and 34 the Notice added and Notice removed events.
When inspecting those rows with this query the comment field holds a number.
creationdate | Post Link | posthistorytypeid | comment |
---|---|---|---|
2015-03-29 3:24 | 28687143 | 34 | 82288 |
2015-03-29 2:49 | 27269748 | 34 | 81888 |
2015-03-29 2:49 | 29116980 | 34 | 81892 |
2015-03-29 2:49 | 29134963 | 34 | 81889 |
2015-03-29 2:49 | 29135107 | 34 | 81891 |
2015-03-29 2:49 | 27269748 | 34 | 81888 |
2015-03-29 2:49 | 29116980 | 34 | 81892 |
2015-03-29 2:49 | 29134963 | 34 | 81889 |
2015-03-29 2:49 | 29135107 | 34 | 81891 |
Does that number represents a foreign-key to a table that is missing from SEDE?
If yes, and not a great secret, can that table be added to SEDE?
If no, what does that number represent?
A similar request to add the notice texts in the UI is here
yes, this question was inspired by this bountied question
Votes
, the restrictingWHERE
clause was removed in the query you linked