User:Woozle/PostFerret/sql/atom

About

• Purpose:
• Fields:
• History:
  • 2013-03-12 Created, but not yet in use.
  • 2013-03-15 Most fields moved from post to atom.
  • 2013-06-28 "Summary" can't be a key if it's no longer a field.
  • 2013-07-19 Added "Class" field; corrected field descriptions referring to "question"
    • Maybe "QtyEdits" should be renamed "Version".

SQL

<mysql> CREATE TABLE `atom` (

  `ID`          INT              NOT NULL AUTO_INCREMENT,
  `Class`       VARCHAR(15)      NOT NULL COMMENT "what type of chain is using this atom",
  `WhenCreated` DATETIME         NOT NULL COMMENT "when the record-chain attached to this atom was created",
  `WhoCreated`  INT              NOT NULL COMMENT "ID (site-defined) of user who created it",
  `WhenEdited`  DATETIME     DEFAULT NULL COMMENT "when it was last edited",
  `WhoEdited`   INT          DEFAULT NULL COMMENT "ID of user who last edited it",
  `QtyEdits`    INT          DEFAULT NULL COMMENT "number of times it has been edited (i.e. version number)",
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;

</mysql>