create table books (
ID number(3),
BookName varchar2(20),
Press varchar2(20),
Author varchar2(20),
PressDate Date,
Price number(5,2),
Com varchar2(20),
books_count number(2),
borrowed_count number(2),
constraint ID_Contraint_PK primary key ( ID ));

create sequence ID_Sequence;
//*******************************
create table bookBrowse (
ID number(3),
StudentName varchar2(40),
BookName varchar2(40),
ReturnDate Date,
BorrowDate Date,
Com varchar2(40),
Is_Returned char(2),//設(shè)置默認(rèn)直為‘否’
constraint ID_BookBrowse_Containt primary key ( ID ));

create sequence ID_Browse_Sequence;
//************************************
create table UserTable(
ID number(3),
UserName varchar2(40),
Password varchar2(40),
Power varchar2(40),
constraint ID_User_Containt primary key ( ID ));
//******************************
create sequence ID_User_Sequence;