Website Database Structure

The website structure and data is stored in a MySQL database. The database structure is highlighted below.

Node Structure Node Data

This is a snapshot of the database structure which controls how each node (or page, like this one) is organized.

  • nodeID
    • A unique identifier number for the node.
  • dataID
    • The identifier for the data (such as this text and the page title)
  • parentID
    • The identifier for that node's parent. (read the Tree Structure section further down).
  • weight
    • Heavier nodes fall further down on the list.
  • opts
    • Short for options. For instance, a node might not be published and would not show up.

This is a snapshot of the database structure which holds the data of each node

  • dataID
    • A unique identifier number for the data node.
  • addDate
    • The date the node was added (as a Unix timestamp)
  • modDate
    • The date the node was modified (as a Unix timestamp)
  • sTitle
    • The title of a page (for instance, this one's is "Website")
  • bContent
    • The content of the page, stored in the database as xhtml. This is what you are reading now.