Database Table: userpicmap3

From Dreamwidth Notes
Jump to: navigation, search

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