Difference between revisions of "Database Table: bannotes"

From Dreamwidth Notes
Jump to: navigation, search
m (Create page for new table bannotes)
 
(No difference)

Latest revision as of 20:57, 19 September 2011

This is a clustered table.

Definition

CREATE TABLE bannotes (
    journalid    INT UNSIGNED NOT NULL,
    banid        INT UNSIGNED NOT NULL,
    remoteid     INT UNSIGNED,
    notetext     MEDIUMTEXT,
 
    PRIMARY KEY (journalid,banid)
)

Relationships