创建数据库表的sql语句.txt

来自「java语言开发的数据库管理系统」· 文本 代码 · 共 11 行

CREATE TABLE UserTable(ID int identity, UserName char(40), Password char(40), 
Power char(40), CONSTRAINT ID_User_Containt PRIMARY KEY (ID));

CREATE TABLE books(ID int identity, BookName char(20), Press char(20), Author char(20), 
PressDate char(10), Price char(10), Com char(20), books_count char(2), 
borrowed_count char(2), CONSTRAINT ID_Contraint_PK PRIMARY KEY (ID));

CREATE TABLE bookBrowse(ID int identity, StudentName char(40), BookName char(40), 
ReturnDate char(10), BorrowDate char(10), Com char(40), Is_Returned char(2), 
CONSTRAINT ID_BookBrowse_Containt PRIMARY KEY (ID));