InstaGov/schema/claim

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

About

  • Purpose: implements the idea of a "claim" (aka "point"), as described here.
  • Fields
    • isSupport: If TRUE, this is a support-point.
    • isCounter: If TRUE, this is a counter-point. If both isSupport and isCounter are FALSE, this is an informal point.
    • isBundled:
      • If TRUE, validity of this point requires that all sub-points must be valid.
      • If FALSE, validity of this point requires only that at least one sub-point must be valid.
    • isAnsNeed: is answer needed? If TRUE, add to list of unanswered points if there is no response.
      • ...but maybe setting isSupport and isCounter both TRUE would be a better way to signal this?
  • History:
    • 2013-03-13 Started.
    • 2013-03-15 Added isAnsNeed

SQL

<mysql> CREATE TABLE `claim` (

 ID_Post   INT      NOT NULL  COMMENT "post.ID for content of claim",
 ID_Parent INT  DEFAULT NULL  COMMENT "parent claim, if any",
 isSupport BOOL DEFAULT FALSE COMMENT "TRUE = this is a support-point",
 isCounter BOOL DEFAULT FALSE COMMENT "TRUE = this is a counter-point",
 isBundled BOOL DEFAULT FALSE COMMENT "TRUE = ALL sub-points must be valid",
 isAnsNeed BOOL DEFAULT FALSE COMMENT "TRUE = this point needs to be answered",
 PRIMARY KEY(`ID_Post`)
)
ENGINE = MYISAM;

</mysql>