Difference between revisions of "InstaGov/schema/claim"
Jump to navigation
Jump to search
(Created page with "==About== * '''Purpose''': implements the idea of a "claim" (aka "point"), as described here. * '''Fields''' ** '''isSupport''': If TRUE, this is a sup...") |
(No difference)
|
Revision as of 15:15, 12 March 2013
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>