Difference between revisions of "Database Table: pollitem2"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'pollitem2 =Definition= <source lang="sql"> CREATE TABLE pollitem2 ( journalid INT UNSIGNED NOT NULL, pollid INT UNSIGNED NOT NULL, pollqid TINY...')
(No difference)

Revision as of 17:39, 22 March 2009

Definition

CREATE TABLE pollitem2 (
  journalid INT UNSIGNED NOT NULL,
  pollid INT UNSIGNED NOT NULL,
  pollqid TINYINT UNSIGNED NOT NULL,
  pollitid TINYINT UNSIGNED NOT NULL,
  sortorder TINYINT UNSIGNED NOT NULL DEFAULT '0',
  item VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY  (journalid,pollid,pollqid,pollitid))

Relationships

Location

Clustered database