create.sql

来自「ssd7数据库系统练习一」· SQL 代码 · 共 19 行

Create table BOOK( 
  "Primary Author"         integer(4),
  "Title"                  char(20),
  "ISBN"                   char(10),
  "PublisherID"            integer(4),
  "Edition"                integer(1),
  "Date of Publication"    date,
  "Price"                  numeric(5,2),
  "Book Description"       char(50),
  constraint PK_
)

Create table PUBLISHER
(PublisherID integer(4),
 Name char(20),
 Address char(40),
 Primary key (PublisherID)
)