InstaGov/schema/claim
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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.
- History:
- 2013-03-13 Started.
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", PRIMARY KEY(`ID_Post`), ) ENGINE = MYISAM;
</mysql>