table.txt

基于目前许多中小型公司, 机关,中小学校,大学院系等都有自己的图书库, 供内部人员借阅。传统的手工登记办法

bookBrowse:
           Id   number(3),primary key
           studentName varchar2(40),not null
           bookName varchar2(40),not null
           borrowDate Date,
           returnDate Date,
           com varchar2(40),
           is_returned char(2),not null,否
           
books:
           id number(3),primary key
           bookName varchar2(40),not null
           press varchar2(40),not null
           author varchar2(40),not null
           address varchar2(40),
           pressDate Date,
           price number(5,2),
           com varchar2(40),
           books_count number(2),
           borrowed_count number(2),
           
userTable:
           id number(3),primary key
           userName varchar2(20),not null
           password varchar2(20),not null
           power varchar(20),not null
           
           
id_browse_sequence
id_user_sequence
id_sequence