Difference between revisions of "InstaGov/schema/answer"
Jump to navigation
Jump to search
(updated thoughts -- probably won't use this table) |
(some cross-links) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
| − | * '''Rules''': Any question may have zero or more answers. New answers can be added at any time. | + | * '''Purpose''': implements {{instagov|concepts|answer}}s |
| + | * '''Rules''': Any {{l/same|question}} may have zero or more answers. New answers can be added at any time. | ||
* '''Notes''': | * '''Notes''': | ||
** "WhenExpires" field: same applies as in "{{instagov|schema|question}}" table. | ** "WhenExpires" field: same applies as in "{{instagov|schema|question}}" table. | ||
Revision as of 16:37, 30 December 2012
About
- Purpose: implements answers
- Rules: Any question may have zero or more answers. New answers can be added at any time.
- Notes:
- "WhenExpires" field: same applies as in "question" table.
- 2011-06-06 This table may end up not being used, since I've found I can use SMW to store answer data. Also, I'm thinking it should be "choice" rather than "answer", but since it's no longer hard-coded, this is just a matter of updating documentation (and one field name in the rating table.
SQL
<mysql>CREATE TABLE `answer` (
`ID` INT NOT NULL AUTO_INCREMENT, `ID_Question` INT NO 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>