listing26-1.sql

来自「《Beginning Python--From Novice to Profes」· SQL 代码 · 共 7 行

CREATE TABLE messages (
    id          SERIAL PRIMARY KEY,
    subject     TEXT NOT NULL,
    sender      TEXT NOT NULL,
    reply_to    INTEGER REFERENCES messages,
    text        TEXT NOT NULL
);