InstaGov/schema/answer

About

• Purpose: implements answers
• Rules: Any question may have zero or more answers. New answers can be added at any time.
• Notes:
  • This table originally had a "WhenExpires" field; it was removed for the same reasons given in notes for the "question" table.

SQL

<mysql>CREATE TABLE `answer` (

  `ID`          INT          NOT NULL AUTO_INCREMENT,
  `ID_Question` INT          NOT NULL COMMENT "question.ID for which this is an answer",
  `Page`        VARCHAR(127)          COMMENT "wiki page describing answer",
  `WhenCreated` DATETIME     NOT NULL COMMENT "when this answer was entered",
  `Pos_Text` VARCHAR(63) DEFAULT NULL COMMENT "optional: text to show at the 'yes' end of the scale (overrides question default)",
  `Neg_Text` VARCHAR(63) DEFAULT NULL COMMENT "optional: text to show at the 'no' end of the scale (overrides question default)",
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>