InstaGov/schema/rating log

About

• Purpose: Records every time a user submits or revises a rating

SQL

<mysql>CREATE TABLE `rating_log` (

  `ID` INT  NOT NULL AUTO_INCREMENT,
  `ID_Answer` INT NOT NULL COMMENT "answer.ID for which this is a rating",
  `ID_Rating` INT NOT NULL COMMENT "rating.ID to which this rating was applied",
  `ID_User` INT COMMENT "user.ID of user who gave this rating",
  `ID_Solution` INT NOT NULL COMMENT "solution.ID of solution for which this is a rating",
  `ID_Proxy` INT DEFAULT NULL COMMENT "if this approval was proxied, records who the proxy was",
  `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 or redirect)",
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>