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 – Tim Stone Apr 3 '15 at 2:13