InstaGov/schema/rating - Revision history

Woozle: decided not to implement yet

2013-08-05T17:48:17Z

decided not to implement yet

@@ Line 7: / Line 7: @@
 ==History==
 * '''2013-01-09''' Removed the "ID_Proxy" field; see {{l/same|rating_log}} for explanation; added unique key: one rating per answer per user; added WhenEdited, QtyEdits
-* '''2013-08-05''' Integrating with {{l/pferret}}: added ID_Atom, removed redundant fields
+* '''2013-08-05''' Designed new version for integrating with {{l/pferret}} (added ID_Atom, removed redundant fields) but decided not to implement yet, because value is not clear. Ratings already keep a separate log, and would we ever want to rate a rating? (...or do any of the other things that integration would enable)
 ==SQL==
 <mysql>CREATE TABLE `rating` (
     `ID`          INT          NOT NULL AUTO_INCREMENT,
@@ Line 31: / Line 19: @@
     `QtyEdits`    INT      DEFAULT NULL COMMENT "number of times this rating has been edited",
     `Remark`      VARCHAR(255)          COMMENT "comments on this rating (can include link)",
     PRIMARY KEY(`ID`),
     UNIQUE KEY(`ID_User`,`ID_Answer`)
+  )
   ENGINE = MYISAM;</mysql>

Woozle: integrating with PostFerret

2013-08-05T16:55:23Z

integrating with PostFerret

@@ Line 7: / Line 7: @@
 ==History==
 * '''2013-01-09''' Removed the "ID_Proxy" field; see {{l/same|rating_log}} for explanation; added unique key: one rating per answer per user; added WhenEdited, QtyEdits
 ==SQL==
 <mysql>CREATE TABLE `rating` (
     `ID`          INT          NOT NULL AUTO_INCREMENT,

Woozle: one more field

2013-01-09T23:34:28Z

one more field

← Older revision		Revision as of 23:34, 9 January 2013
Line 6:		Line 6:
	** Changes to ratings are logged in the {{l/same\|rating log}}.		** Changes to ratings are logged in the {{l/same\|rating log}}.
	==History==		==History==
	* '''2013-01-09''' Removed the "ID_Proxy" field; see {{l/same\|rating_log}} for explanation; added unique key: one rating per answer per user; added WhenEdited		* '''2013-01-09''' Removed the "ID_Proxy" field; see {{l/same\|rating_log}} for explanation; added unique key: one rating per answer per user; added WhenEdited, QtyEdits
	==SQL==		==SQL==
	<mysql>CREATE TABLE `rating` (		<mysql>CREATE TABLE `rating` (
Line 16:		Line 16:
	`WhenCreated` DATETIME NOT NULL COMMENT "when this user first rated this answer",		`WhenCreated` DATETIME NOT NULL COMMENT "when this user first rated this answer",
	`WhenEdited` DATETIME DEFAULT NULL COMMENT "when this rating (of this answer) was last edited (by this user)",		`WhenEdited` DATETIME DEFAULT NULL COMMENT "when this rating (of this answer) was last edited (by this user)",
			`QtyEdits` INT DEFAULT NULL COMMENT "number of times this rating has been edited",
	`Remark` VARCHAR(255) COMMENT "comments on this rating (can include link)",		`Remark` VARCHAR(255) COMMENT "comments on this rating (can include link)",
	PRIMARY KEY(`ID`),		PRIMARY KEY(`ID`),

Woozle: revisions to timestamp fields; clarified field comments

2013-01-09T23:13:55Z

revisions to timestamp fields; clarified field comments

← Older revision		Revision as of 23:13, 9 January 2013
Line 6:		Line 6:
	** Changes to ratings are logged in the {{l/same\|rating log}}.		** Changes to ratings are logged in the {{l/same\|rating log}}.
	==History==		==History==
	* '''2013-01-09''' Removed the "ID_Proxy" field; see {{l/same\|rating_log}} for explanation; added unique key: one rating per answer per user.		* '''2013-01-09''' Removed the "ID_Proxy" field; see {{l/same\|rating_log}} for explanation; added unique key: one rating per answer per user; added WhenEdited
	==SQL==		==SQL==
	<mysql>CREATE TABLE `rating` (		<mysql>CREATE TABLE `rating` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_User` INT COMMENT "user~~.ID~~ who gave this rating",		`ID_User` INT NOT NULL COMMENT "ID of user who gave this rating",
	`ID_Answer` INT NOT NULL COMMENT "answer~~.ID~~ for which this is a rating",		`ID_Answer` INT NOT NULL COMMENT "ID of answer for which this is a rating",
	`ID_Log` INT NOT NULL COMMENT "ID of log ~~event which posted~~ this ~~value~~",		`ID_Log` INT NOT NULL COMMENT "ID of log entry for the most recent update of this rating",
	`Value` INT NOT NULL COMMENT "rating value",		`Value` INT NOT NULL COMMENT "rating value",
	`~~WhenDone~~` DATETIME NOT NULL COMMENT "when this rating was ~~posted~~",		`WhenCreated` DATETIME NOT NULL COMMENT "when this user first rated this answer",
	`Remark` VARCHAR(255) COMMENT "comments on this rating (can include link)",		`WhenEdited` DATETIME DEFAULT NULL COMMENT "when this rating (of this answer) was last edited (by this user)",
			`Remark` VARCHAR(255) COMMENT "comments on this rating (can include link)",
	PRIMARY KEY(`ID`),		PRIMARY KEY(`ID`),
	UNIQUE KEY(`ID_User`,`ID_Answer`)		UNIQUE KEY(`ID_User`,`ID_Answer`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>

Woozle at 16:20, 9 January 2013

2013-01-09T16:20:12Z

← Older revision		Revision as of 16:20, 9 January 2013
Line 16:		Line 16:
	`WhenDone` DATETIME NOT NULL COMMENT "when this rating was posted",		`WhenDone` DATETIME NOT NULL COMMENT "when this rating was posted",
	`Remark` VARCHAR(255) COMMENT "comments on this rating (can include link)",		`Remark` VARCHAR(255) COMMENT "comments on this rating (can include link)",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`),
	UNIQUE KEY(`ID_User`,`ID_Answer`)		UNIQUE KEY(`ID_User`,`ID_Answer`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>

Woozle: unique key: one rating per user per answer

2013-01-09T16:20:02Z

unique key: one rating per user per answer

← Older revision		Revision as of 16:20, 9 January 2013
Line 6:		Line 6:
	** Changes to ratings are logged in the {{l/same\|rating log}}.		** Changes to ratings are logged in the {{l/same\|rating log}}.
	==History==		==History==
	* '''2013-01-09''' Removed the "ID_Proxy" field; see {{l/same\|rating_log}} for explanation.		* '''2013-01-09''' Removed the "ID_Proxy" field; see {{l/same\|rating_log}} for explanation; added unique key: one rating per answer per user.
	==SQL==		==SQL==
	<mysql>CREATE TABLE `rating` (		<mysql>CREATE TABLE `rating` (
Line 17:		Line 17:
	`Remark` VARCHAR(255) COMMENT "comments on this rating (can include link)",		`Remark` VARCHAR(255) COMMENT "comments on this rating (can include link)",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
			UNIQUE KEY(`ID_User`,`ID_Answer`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>

Woozle: clearer explanation

2013-01-09T16:04:14Z

clearer explanation

← Older revision		Revision as of 16:04, 9 January 2013
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': ~~implements~~ {{igov/term\|rating}}~~s, i.e~~. ~~a record of each user's current rating of~~ each ~~proposed solution~~.		* '''Purpose''': Records the current value of one user's {{igov/term\|rating}} of a given {{igov/term\|answer}} (which in turn is tied to a specific {{igov/term\|question}}. These are the values which are aggregated to calculate the voting results for each question.
	* '''Rules''':		* '''Rules''':
	** Any {{l/same\|answer}} may have zero or more ratings.		** Any {{l/same\|answer}} may have zero or more ratings.
	** Each user sets the value of their rating for each answer, and can change that rating at any time.		** Each user sets the value of their rating for each answer, and can change that rating at any time.
	** Changes to ratings are logged in the {{l/same\|rating log}}.		** Changes to ratings are logged in the {{l/same\|rating log}}.
	** Users can set their ratings directly, or by choosing a {{~~igov~~/~~term~~\|~~proxy~~}} ~~to rate~~ for ~~them~~.		==History==
			* '''2013-01-09''' Removed the "ID_Proxy" field; see {{l/same\|rating_log}} for explanation.
	==SQL==		==SQL==
	<mysql>CREATE TABLE `rating` (		<mysql>CREATE TABLE `rating` (
Line 12:		Line 13:
	`ID_Answer` INT NOT NULL COMMENT "answer.ID for which this is a rating",		`ID_Answer` INT NOT NULL COMMENT "answer.ID for which this is a rating",
	`ID_Log` INT NOT NULL COMMENT "ID of log event which posted this value",		`ID_Log` INT NOT NULL COMMENT "ID of log event which posted this value",
	~~`ID_Proxy` INT DEFAULT NULL COMMENT "if this approval was proxied, records which proxy was used",~~
	`Value` INT NOT NULL COMMENT "rating value",		`Value` INT NOT NULL COMMENT "rating value",
	`WhenDone` DATETIME NOT NULL COMMENT "when this rating was posted",		`WhenDone` DATETIME NOT NULL COMMENT "when this rating was posted",

Woozle: using new terms template

2013-01-06T17:01:20Z

using new terms template

← Older revision		Revision as of 17:01, 6 January 2013
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': implements {{~~instagov\|concepts~~\|rating}}s, i.e. a record of each user's current rating of each proposed solution.		* '''Purpose''': implements {{igov/term\|rating}}s, i.e. a record of each user's current rating of each proposed solution.
	* '''Rules''':		* '''Rules''':
	** Any {{l/same\|answer}} may have zero or more ratings.		** Any {{l/same\|answer}} may have zero or more ratings.
	** Each user sets the value of their rating for each answer, and can change that rating at any time.		** Each user sets the value of their rating for each answer, and can change that rating at any time.
	** Changes to ratings are logged in the {{l/same\|rating log}}.		** Changes to ratings are logged in the {{l/same\|rating log}}.
	** Users can set their ratings directly, or by choosing a {{~~instagov\|concepts~~\|proxy}} to rate for them.		** Users can set their ratings directly, or by choosing a {{igov/term\|proxy}} to rate for them.
	==SQL==		==SQL==
	<mysql>CREATE TABLE `rating` (		<mysql>CREATE TABLE `rating` (

Woozle: a bit of "about" doc was still down under "SQL" -- moved it

2012-12-30T17:17:52Z

a bit of "about" doc was still down under "SQL" -- moved it

← Older revision		Revision as of 17:17, 30 December 2012
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': implements {{instagov\|concepts\|rating}}s		* '''Purpose''': implements {{instagov\|concepts\|rating}}s, i.e. a record of each user's current rating of each proposed solution.
	* '''Rules''':		* '''Rules''':
	** Any {{l/same\|answer}} may have zero or more ratings.		** Any {{l/same\|answer}} may have zero or more ratings.
Line 7:		Line 7:
	** Users can set their ratings directly, or by choosing a {{instagov\|concepts\|proxy}} to rate for them.		** Users can set their ratings directly, or by choosing a {{instagov\|concepts\|proxy}} to rate for them.
	==SQL==		==SQL==
	~~Records each user's current rating of each proposed solution.~~
	<mysql>CREATE TABLE `rating` (		<mysql>CREATE TABLE `rating` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,

Woozle: purpose, rules; some cleanup

2012-12-30T16:41:26Z

purpose, rules; some cleanup

← Older revision		Revision as of 16:41, 30 December 2012
Line 1:		Line 1:
	==About==		==About==
	* '''~~Concepts~~''': ~~see~~ {{instagov\|concepts\|proxy}}		* '''Purpose''': implements {{instagov\|concepts\|rating}}s
			* '''Rules''':
			** Any {{l/same\|answer}} may have zero or more ratings.
			** Each user sets the value of their rating for each answer, and can change that rating at any time.
			** Changes to ratings are logged in the {{l/same\|rating log}}.
			** Users can set their ratings directly, or by choosing a {{instagov\|concepts\|proxy}} to rate for them.
	==SQL==		==SQL==
	Records each user's current rating of each proposed solution.		Records each user's current rating of each proposed solution.
	~~<section begin=sql />~~<mysql>CREATE TABLE `rating` (		<mysql>CREATE TABLE `rating` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_User` INT COMMENT "user.ID who gave this rating",		`ID_User` INT COMMENT "user.ID who gave this rating",
Line 15:		Line 20:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~