User:Woozle/PostFerret/sql

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< User:Woozle‎ | PostFerret
Revision as of 01:49, 30 June 2015 by Woozle (talk | contribs) (Rules)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Rules

  • An atom is a place-holder for any type of content.
  • Every content-type has a class.
  • Content-types include: text and post.
    • Content-types can make use of other content-types.
      • Example: Every post record makes use of multiple text records (for title, subject, and body).
  • Every change to an atom is logged in the history.

Tables

  • /atom: root common record for a lot of different types - a trackable thing
  • /class: chain-type definitions
  • /post: an atom with a bit of text and possibly an owner
  • /text: textual content records
  • /hist: text revision history