create1.sql

python web programming 部分

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
);