create1.sql

来自「python web programming 部分」· SQL 代码 · 共 24 行

CREATE TABLE Publisher  (
        PubNo           INT             NOT NULL,
        PubName         VARCHAR (12)    NOT NULL,
        PubWebSIte      VARCHAR (50)
);

CREATE TABLE Author     (
        AutNo           INT             NOT NULL,
        AutFirst        VARCHAR (10)    NOT NULL,
        AutLast         VARCHAR (10)    NOT NULL,
        AutLoc          VARCHAR (10)
);

CREATE TABLE Book       (
        BkISBN          CHAR    (12)    NOT NULL,
        BkName          VARCHAR (30)    NOT NULL,
        PubNo           INT             NOT NULL,
        BkYear          INT
);

CREATE TABLE Authorship (
        AutNo           INT             NOT NULL,
        BkISBN          CHAR    (12)    NOT NULL
);