3
$\begingroup$

The main page of the site says that there are (currently) 207 Questions. When I hover on the links though, there is a number, which I am guessing is assigned sequentially. Many recent questions are in the 1300 range. One is 872, there is a 211 and a 14. If "question sequence numbers" are over 1300 and yet there are only "207 Questions", did 1100 meet an untimely end?

| |
$\endgroup$
  • $\begingroup$ For example, on this meta site it says there are 58 Questions, but the number in the link of this very Question is 200. (Qapla'!) $\endgroup$ – user737 Jul 3 '17 at 18:16
3
$\begingroup$

All "posts" are stored in one database table internally; there isn't a separate table for questions and answers.

A "post" is one of the following:

  • Question
  • Answer
  • Wiki
  • Tag wiki excerpt
  • Tag wiki
  • Moderator nomination
  • Wiki placeholder
  • Privilege wiki

There may be gaps in the numbers if the SQL server does something funky, but in theory, if you account for all of the above, the IDs should be sequential.

It also has the interesting side effect of allowing you to link to a question as if it was an answer—https://cseducators.meta.stackexchange.com/a/200 does link to this question, but /a/ is really for answers.

But it would be unlikely that questions alone would have sequential IDs... unless no-one's answering 'em!

| |
$\endgroup$
  • $\begingroup$ Thank you. It would be interesting to see a schema or diagram of the basic SE database structure. $\endgroup$ – user737 Jul 3 '17 at 19:39
  • 1
    $\begingroup$ @nocomprende The schema is available here, or in the right sidebar on SEDE. $\endgroup$ – Aurora0001 Jul 3 '17 at 19:41
  • $\begingroup$ @nocomprende The reverse side effect it true as well. You can link to a tag wiki, answer, or other post with the https://cseducators.stackexchange.com/q/314 syntax. That's actually a tag wiki entry. And, in fact, the /q/ version is used extensively in SE to create links $\endgroup$ – Gypsy Spellweaver Jul 4 '17 at 6:14
  • $\begingroup$ @GypsySpellweaver I always feel confused when something specific like a file path syntax is used in an amorphous way. Couldn't they use something else? It would be like having three sets of driving directions that all mysteriously go to the same place. Creepy. $\endgroup$ – user737 Jul 4 '17 at 13:06
  • $\begingroup$ @nocomprende If you're on Windows, think "shortcut", and if you use *nix, think "link." Either one can create file paths where multiple roads lead to Rome. Web sites do that for many reasons; SEO, user convenience, and developer convenience among them. $\endgroup$ – Gypsy Spellweaver Jul 4 '17 at 13:59

You must log in to answer this question.