table.sql

来自「用java写的一个图书馆管理系统,应该说功能相当全面.包含所有源代码,从数据库的」· SQL 代码 · 共 14 行

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(40), Press char(40), Author char(40), 
PressDate char(20), Price char(20), Com char(40), books_count char(4), 
borrowed_count char(4), CONSTRAINT ID_Contraint_PK PRIMARY KEY (ID));

CREATE TABLE bookBrowse(ID int identity, StudentName char(40), BookName char(40), 
ReturnDate char(20), BorrowDate char(20), Com char(40), Is_Returned char(4), 
CONSTRAINT ID_BookBrowse_Containt PRIMARY KEY (ID));           
           
select *from bookbrowse

insert into books(BookName, Press, Author,PressDate, Price, Com, books_count,borrowed_count) values('df','fsd','dfd','fsd','dfs','dfs','d','dsf')