Difference between revisions of "InstaGov/schema/claim"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, 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...")
 
m (syntax fix)
 
(One intermediate revision by the same user not shown)
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",
   PRIMARY KEY(`ID_Post`),
+
  isAnsNeed BOOL DEFAULT FALSE COMMENT "TRUE = this point needs to be answered",
 +
   PRIMARY KEY(`ID_Post`)
 
  )
 
  )
 
  ENGINE = MYISAM;
 
  ENGINE = MYISAM;
 
</mysql>
 
</mysql>

Latest revision as of 15:54, 14 July 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>