create table reader_info
(reader_id bigint identity(1,1) primary key,
 reader_name char(10),
 reader_unit char(20),
 reader_work char(16),
)

insert into reader_info(reader_name,reader_unit,reader_work)
values ('huang','computer','asdf')

insert into reader_info(reader_name,reader_unit,reader_work)
values ('cheng','computer','student')


 
create table book_type
(type_num char(20) primary key,
 type_nam char(20) not null,
 type_remark char(50)
)
create table user_info
(user_num char(10),
 user_psw char(10),
 user_type_name char(10)
)

create table punnish 
(reader_id bigint,
 punnish_time datetime,
 user_num char(10),
 punnish_money money,
 book_id bigint,
 primary key(reader_id,punnish_time,user_num)
)


create table book_info
(book_id bigint identity(1,1) primary key,
 book_isbn char(16),
 book_author char(10),
 book_press char(20),
 book_price money,
 book_flag char(2),
 type_num char(20) references book_type(type_num),
 book_remark char(50),
 book_name char(40),
 
)
 

create table record_info
(reader_id  bigint references reader_info(reader_id),
 book_id    bigint references book_info(book_id),
 record_borr datetime,
 record_be_back datetime,
 recerd_back datetime,
 primary key(reader_id,book_id,record_borr),
 
)