Difference between revisions of "User:Woozle/PostFerret/sql"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(class, text, hist)
(Rules)
 
Line 1: Line 1:
 +
==Rules==
 +
* An {{l/sub|atom}} is a place-holder for any type of content.
 +
* Every content-type has a {{l/sub|class}}.
 +
* Content-types include: {{l/sub|text}} and {{l/sub|post}}.
 +
** Content-types can make use of other content-types.
 +
*** Example: Every {{l/sub|post}} record makes use of multiple {{l/sub|text}} records (for title, subject, and body).
 +
* Every change to an {{l/sub|atom}} is logged in the {{l/sub|hist}}ory.
 
==Tables==
 
==Tables==
 
* [[/atom]]: root common record for a lot of different types - a trackable thing
 
* [[/atom]]: root common record for a lot of different types - a trackable thing

Latest revision as of 01:49, 30 June 2015

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