![]() ![]() Other columns and tables may be needed to hold information not specific to the data hierarchy (like information about the stats of items, environment conditions at nodes, etc.).Īnd that's just a very basic data structure for the maze.įor the lore story, you'd at the very least need tables with texts, chapters, conditions under which each chapter is launched, etc. To speed up lookup operations, you might want a link table MAZE_NODE containing just MAZE_ID and NODE_ID with foreign keys to both tables, and a NODE_ITEM table with similarly NODE_ID and ITEM_ID fields. ID, NAME, COORDINATES, and MAZE_IDģrd ITEM, with ID, ITEM_NAME, NODE_ID, ITEM_TYPE, and maybe other things. Then there's a table NODE, containing data about the node. ![]() That suggests a table MAZE, containing basic data about the maze like its ID, NAME, DESCRIPTION, etc. So a maze is a grid, with each node containing data.Ģ) a list of items available at that nodeĮverything else can be expressed as those. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |