Edit - Meta Stack Exchange

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Rev

For PostNoticeTypes, there appears to be two classIds other than the mentioned 1, 2, & 4. Stack Overflow additionally as 8 and 0, it seems most (all?) other sites have just the 8. Is there an official name for this class of notices?
– zcoop98
Commented Apr 2, 2021 at 22:42
1

@zcoop98 I've run a check and you're right, only 1 site has 0 as classid. I checked but can't find info on what the name of those classid's is. Feel free to open a question to get that name. Here is the answer meta.stackexchange.com/a/278150 that announces the addition of those tables. Surprisingly enough I was the requestor to get those tables added in the first place.
– rene
Commented Apr 22, 2021 at 16:51
Why is there UserName in Post and Comment? Is it to avoid a join? Are the username entries in posts and comments updated if user updates the username?
– chaosifier
Commented Jun 1, 2021 at 8:09
1

@chaosifier Username is populated when a User is deleted. So once the Userid or OwnerUserId would be set to null the Usename field gets populated with the last known name (although most of the time the username is reset to default first)
– rene
Commented Jun 1, 2021 at 8:17
How can you tell if a vote is for a comment or for a post? It seems like the schema only handles votes for posts.
– Alex J
Commented Jun 10, 2021 at 19:23
2

@AlexJ Comments only have upvotes and those are kept in the field ` Score` . There is no separate table for CommentVotes. So the votes(votetypeid in (2,3)) table has the rows for up and downvotes of posts alone.
– rene
Commented Jun 10, 2021 at 19:41
@rene Interesting, what keeps a user from making multiple upvotes on a given comment? How is the vote on a comment related back to the user that makes it?
– Alex J
Commented Jun 10, 2021 at 20:05
1

@AlexJ the schema of the production database is more extensive
– rene
Commented Jun 10, 2021 at 20:09
I'm looking for Users.Title. Where is it?!
– Benyamin Jafari
Commented Apr 27, 2022 at 9:25
1

@BenyaminJafari see How can I query users with a specific Job title?
– rene
Commented Apr 27, 2022 at 9:28
What does AcceptedAnswerId mean? I wish there was documentation specifically telling about it.
– desert_ranger
Commented Nov 20, 2022 at 15:59
1

@desert_ranger see Which Stack Overflow table saves the data for accepted answers?
– rene
Commented Nov 20, 2022 at 19:11
Is there an access to Twitter / Github usernames? I don't see such columns but it's a public information...
– Ivan Kleshnin
Commented Oct 25, 2023 at 8:13
1

@IvanKleshnin please see meta.stackexchange.com/a/335060/158100 tl;dr: they are not in the schema.
– rene
Commented Oct 25, 2023 at 17:32

Add a comment |

Correct minor typos or mistakes
Clarify meaning without changing it
Add related resources or links
Always respect the author’s intent
Don’t use edits to reply to the author

create code fences with backticks ` or tildes ~
```
like so
```
add language identifier to highlight code
```python
def function(foo):
print(foo)
```
put returns between paragraphs
for linebreak add 2 spaces at end
_italic_ or **bold**
indent code by 4 spaces
backtick escapes `like _so_`
quote by placing > at start of line
to make links (use https whenever possible)
<https://example.com>
[example](https://example.com)
<a href="https://example.com">example</a>

formatting help »
answering help »