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...") |
(isAnsNeed) |
||
| Line 7: | Line 7: | ||
*** If TRUE, validity of this point requires that ''all'' sub-points must be valid. | *** 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. | *** 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''': | * '''History''': | ||
** '''2013-03-13''' Started. | ** '''2013-03-13''' Started. | ||
| + | ** '''2013-03-15''' Added '''isAnsNeed''' | ||
==SQL== | ==SQL== | ||
<mysql> | <mysql> | ||
| Line 17: | Line 20: | ||
isCounter BOOL DEFAULT FALSE COMMENT "TRUE = this is a counter-point", | isCounter BOOL DEFAULT FALSE COMMENT "TRUE = this is a counter-point", | ||
isBundled BOOL DEFAULT FALSE COMMENT "TRUE = ALL sub-points must be valid", | 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`), | PRIMARY KEY(`ID_Post`), | ||
) | ) | ||
ENGINE = MYISAM; | ENGINE = MYISAM; | ||
</mysql> | </mysql> | ||
Revision as of 20:43, 15 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.
- 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>