Difference between revisions of "InstaGov/schema/rating"
Jump to navigation
Jump to search
(Created page with '==About== * '''Concepts''': see {{instagov|concepts|proxy}} ==SQL== Records each user's current rating of each proposed solution. <section begin=sql /><mysql>CREATE TABLE `rating…') |
(purpose, rules; some cleanup) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
| − | * ''' | + | * '''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. | ||
| − | + | <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> | ||
| − | |||
Revision as of 16:41, 30 December 2012
About
- Purpose: implements ratings
- Rules:
- Any 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 rating log.
- Users can set their ratings directly, or by choosing a proxy to rate for them.
SQL
Records each user's current rating of each proposed solution. <mysql>CREATE TABLE `rating` (
`ID` INT NOT NULL AUTO_INCREMENT, `ID_User` INT COMMENT "user.ID who gave this 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_Proxy` INT DEFAULT NULL COMMENT "if this approval was proxied, records which proxy was used", `Value` INT NOT NULL COMMENT "rating value", `WhenDone` DATETIME NOT NULL COMMENT "when this rating was posted", `Remark` VARCHAR(255) COMMENT "comments on this rating (can include link)", PRIMARY KEY(`ID`) ) ENGINE = MYISAM;</mysql>