Difference between revisions of "InstaGov/schema/post"
Jump to navigation
Jump to search
(Created page with "==About== * '''Purpose''': a trackable piece of text (can be modified, has edit history, etc.) *: for handling functionality common to several table types (question, answer, p...") |
(used by) |
||
| Line 2: | Line 2: | ||
* '''Purpose''': a trackable piece of text (can be modified, has edit history, etc.) | * '''Purpose''': a trackable piece of text (can be modified, has edit history, etc.) | ||
*: for handling functionality common to several table types (question, answer, point) | *: for handling functionality common to several table types (question, answer, point) | ||
| + | * '''Used by''': {{l/same|claim}}; eventually {{l/same|question}} and {{l/same|answer}}. | ||
* '''History''': | * '''History''': | ||
** '''2013-03-12''' Created, but not yet in use. | ** '''2013-03-12''' Created, but not yet in use. | ||
Revision as of 21:02, 12 March 2013
About
- Purpose: a trackable piece of text (can be modified, has edit history, etc.)
- for handling functionality common to several table types (question, answer, point)
- Used by: claim; eventually question and answer.
- History:
- 2013-03-12 Created, but not yet in use.
SQL
<mysql> CREATE TABLE `post` (
`ID` INT NOT NULL AUTO_INCREMENT, `Summary` VARCHAR(255) NOT NULL COMMENT "short description of post, for listings", `URI` VARCHAR(255) DEFAULT NULL COMMENT "site-relative URI for more information", `WhenCreated` DATETIME NOT NULL COMMENT "when this question was entered", `WhoCreated` INT NOT NULL COMMENT "ID (site-defined) of user who added the question", `WhenEdited` DATETIME DEFAULT NULL COMMENT "when this question was last edited", `WhoEdited` INT DEFAULT NULL COMMENT "ID of user who last edited the question", `QtyEdits` INT DEFAULT NULL COMMENT "number of times this question has been edited", PRIMARY KEY(`ID`), UNIQUE KEY `content` (`Summary`) ) ENGINE = MYISAM;
</mysql>