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
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;