Difference between revisions of "Database Table: userpicmap3"

From Dreamwidth Notes
Jump to: navigation, search
m (Create page for new table userpicmap3)
 
m (Robot: Updating: Format)
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
{{Database Table|name=userpicmap3|table type=clustered|need desc=1|repo=dw-free}}
+
{{Database Table|name=userpicmap3|table type=clustered|repo=dw-free}}
 +
[[Description::Stores userpic keyword mappings.]]
 +
 
 +
* NULL kwid with non-NULL picid is a pic#xxxx keyword
 +
* NULL picid with non-NULL kwid is a unassigned keyword
 +
* NULL picid and kwid is a redirect.
 
= Definition =
 
= Definition =
 
<source lang="sql">
 
<source lang="sql">

Latest revision as of 21:15, 15 October 2010

This is a clustered table. Stores userpic keyword mappings.

  • NULL kwid with non-NULL picid is a pic#xxxx keyword
  • NULL picid with non-NULL kwid is a unassigned keyword
  • NULL picid and kwid is a redirect.

Definition

CREATE TABLE userpicmap3 (
    userid INT(10) UNSIGNED NOT NULL DEFAULT '0',
    mapid INT(10) UNSIGNED NOT NULL,
    kwid INT(10) UNSIGNED,
    picid INT(10) UNSIGNED,
    redirect_mapid INT(10) UNSIGNED,
 
    PRIMARY KEY (userid, mapid),
    UNIQUE KEY  (userid, kwid),
    INDEX redirect (userid, redirect_mapid)
)

Relationships