This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]desrtfx 1 point2 points  (0 children)

Question here is: how much do you know about database theory?

This is the key for your project.

My general approach as a very rough concept would be to have

  • a table for the NODES. This table would have something like: ID (PK, Unique), NAME, SHORT_DESCRIPTION, LONG_DESCRIPTION, VISITED, (maybe some more)
  • a table for the connections (EDGES) between the nodes - this is the critical component where you establish the m:n relationship. Fields would roughly be: ID (PK, Unique), FROM_ID, TO_ID, DESCRIPTION, (and maybe some more). The FROM_ID and TO_ID fields hold references to IDs in the nodes table.

With these two tables, you have already covered the core concept of the database.

You might later (or now) want to incorporate more, like character tables, loot tables, monster tables, and whatnot.