Database Table: logtags

From Dreamwidth Notes
Jump to: navigation, search

This is a clustered table.

Definition

CREATE TABLE logtags (
    journalid INT UNSIGNED NOT NULL,
    jitemid   MEDIUMINT UNSIGNED NOT NULL,
    kwid      INT UNSIGNED NOT NULL,
 
    PRIMARY KEY (journalid, jitemid, kwid),
    KEY (journalid, kwid)
)

Relationships