--장르
create table book_genre(
genre_no char(3) constraint book_genre_no_pk primary key,
genre_name varchar2(20)
);
--고객정보
create table book_customer(
cus_no char(10) constraint customer_no_pk primary key,
id varchar2(30) constraint customer_id_nn not null,
pwd varchar2(80) constraint customer_pwd_nn not null,
cus_name varchar2(50) constraint customer_name_nn not null,
tel varchar2(20) constraint customer_tel_nn not null,
address varchar2(100),
email varchar2(100),
regdate date,
reg char(2)
);
--책정보
create table book_info(
book_no char(10) constraint book_info_no_pk primary key,
book_name varchar2(80),
publisher varchar2(50),
genre_no char(3)
);
--대여
create table book_rent(
id varchar2(30),
rentdate date,
return_date date
);
insert into book_info
values(book_no_seq.nextval, '김', '김', '김', 1, 101, sysdate);
insert into book_info
values(book_no_seq.nextval, '도', '도', '도', 1, 101, sysdate);
insert into book_info
values(book_no_seq.nextval, '영', '영', '영', 1, 101, sysdate);
insert into book_rent(rent_no, user_id, cus_name, title, book_no, rent_date, is_return)
values(rent_no_seq.nextval, 12, '도영', '열강2', 2, sysdate, 'N');
insert into book_rent(rent_no, user_id, cus_name, title, book_no, rent_date, is_return)
values(rent_no_seq.nextval, 12, '도영', '열강3', 3, sysdate, 'N');
insert into book_rent(rent_no, user_id, cus_name, title, book_no, rent_date, is_return)
values(rent_no_seq.nextval, 12, '도영', '열강4', 4, sysdate, 'N');
insert into book_rent(rent_no, user_id, cus_name, title, book_no, rent_date, is_return)
values(rent_no_seq.nextval, 12, '도영', '열강5', 5, sysdate, 'N');
select * from book_rent;
insert into book_info values(book_no_seq.nextval, '열강', '도영', '책방', 1, 101, sysdate);
insert into book_info values(book_no_seq.nextval, '열강2', '도영2', '책방2', 1, 101, sysdate);
insert into book_info values(book_no_seq.nextval, '열강3', '도영3', '책방3', 1, 102, sysdate);
insert into book_info values(book_no_seq.nextval, '열강4', '도영4', '책방4', 1, 102, sysdate);
insert into book_info values(book_no_seq.nextval, '열강5', '도영5', '책방5', 1, 101, sysdate);
insert into book_info values(book_no_seq.nextval, '열강5', '도영5', '책방5', 1, 103, sysdate);
insert into book_genre values(101, '액션');
insert into book_genre values(102, '만화');
insert into book_genre values(103, '애로');
insert into book_genre values(104, '멜로');
insert into book_genre values(105, '3D');
