InstaGov/schema/claim

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>