Database Table: usertags

From Dreamwidth Notes
Jump to: navigation, search

This is a clustered table.

Definition

CREATE TABLE usertags (
    journalid   INT UNSIGNED NOT NULL,
    kwid        INT UNSIGNED NOT NULL,
    parentkwid  INT UNSIGNED,
    display     ENUM('0','1') DEFAULT '1' NOT NULL,
 
    PRIMARY KEY (journalid, kwid)
)

Relationships