InstaGov/schema/claim - Revision history

Woozle: syntax fix

2013-07-14T15:54:59Z

syntax fix

← Older revision		Revision as of 15:54, 14 July 2013
Line 21:		Line 21:
	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",		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>

Woozle: isAnsNeed

2013-03-15T20:43:00Z

isAnsNeed

← Older revision		Revision as of 20:43, 15 March 2013
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>

Woozle: Created page with "==About== * '''Purpose''': implements the idea of a "claim" (aka "point"), as described here. * '''Fields''' ** '''isSupport''': If TRUE, this is a sup..."

2013-03-12T15:15:12Z

Created page with "==About== * '''Purpose''': implements the idea of a "claim" (aka "point"), as described [[../../Debate Mapper|here]]. * '''Fields''' ** '''isSupport''': If TRUE, this is a sup..."

New page

==About==
* '''Purpose''': implements the idea of a "claim" (aka "point"), as described [[../../Debate Mapper|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>