InstaGov/schema/claim

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< InstaGov‎ | schema
Revision as of 15:15, 12 March 2013 by Woozle (talk | contribs) (Created page with "==About== * '''Purpose''': implements the idea of a "claim" (aka "point"), as described here. * '''Fields''' ** '''isSupport''': If TRUE, this is a sup...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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>