table.txt

来自「本源码是一个图书馆管理系统的实例」· 文本 代码 · 共 35 行

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