Software Project Database Design Version 1.0 2007. 6. 9 Library DB Scenario Team
개정이력 개정번호개정일자개정자개정사유개정내용승인일자비고 1.00 2007-06-09 서오석신규제정문서의초안생성 2007-06-09
Table of Contents 1.0 ER Diagram... 5 Logical Review... 5 Physical Review... 5 2.0 Table Detail Design... 6 3.0 DDL CREATE SQL... 10 3.1 저자... 10 3.2 도서위치정보... 10 3.3 출판사정보... 10 3.4 도서정보... 11 3.5 저자서적분류... 11 3.6 회원직급... 11 3.7 대출권한... 12 3.8 회원... 12 3.9 대출정보... 12 3.10 블랙리스트... 13 4.0 Data loading... 13 4.1 저자... 13 4.2 도서위치정보... 14 4.3 출판사정보... 14 4.4 도서정보... 16 4.5 저자서적분류... 18 4.6 회원직급... 21 4.7 대출권한... 21 4.8 회원... 21
4.9 대출정보... 22 4.10 블랙리스트... 23 5.0 Grant SQL... 23
1.0 ER Diagram Logical Review Physical Review
2.0 Table Detail Design 시스템명 도서대출시스템 페이지 1 테이블 ID USERS 작성일 2007-06-09 테이블명 회원 작성자 서오석 순번 한글명 영문명 데이터타입 ( 길이 ) NULL Default PK FK 속성정의 1 회원번호 USER_NUM NUMBER(8) N Y 학번 2 성별 SEX VARCHAR2(1) 1: 남자 2: 여자 3 성 FIRST_NAME VARCHAR2(15) 4 이름 LAST_NAME VARCHAR2(15) 5 소속 COURSE VARCHAR2(15) 6 전화번호 PHONE_NUM VARCHAR2(15) BER 7 이메일 E_MAIL VARCHAR2(25) 8 집주소 ADDRESS VARCHAR2(100) 9 권한번호 AUTHORITY_N NUMBER(8) Y UM 10 회원직급번호 TYPE_NUM NUMBER(2) Y Primary key USER_NUM 시스템명 도서대출시스템 페이지 2 테이블 ID LEND_AUTHORITY 작성일 2007-06-09 테이블명 대출권한 작성자 서오석 순번 한글명 영문명 데이터타입 ( 길이 ) NULL Default PK FK 속성정의 1 권한번호 AUTHORITY_N NUMBER(8) N Y UM 2 권한별내용 AUTHORITY_D SC VARCHAR2(25) 1 1: 일반 2: 장기연체 Primary key AUTHORITY_NUM
시스템명 도서대출시스템 페이지 3 테이블 ID USER_TYPE 작성일 2007-06-09 테이블명 회원직급 작성자 서오석 순번 한글명 영문명 데이터타입 ( 길이 ) NULL Default PK FK 속성정의 1 회원직급번호 TYPE_NUM NUMBER(2) N Y 1: 대학생 2: 대학원생 3: 교수 2 직급이름 TYPE_DESC VARCHAR2(15) 3 직급별대여권수 GRADE_DESC NUMBER(2) Primary key TYPE_NUM 시스템명 도서대출시스템 페이지 4 테이블 ID BOOK 작성일 2007-06-09 테이블명 도서정보 작성자 서오석 순번 한글명 영문명 데이터타입 ( 길이 ) NULL Default PK FK 속성정의 1 도서번호 BOOK_NUM NUMBER(8) N Y 2 도서위치번호 LOCATION_NU NUMBER(4) N Y M 3 출판사번호 PUBLISHER_N NUMBER(8) Y UM 4 도서이름 TITLE VARCHAR2(100) 5 도서카테고리 TYPE VARCHAR2(10) 6 출판일자 PUBLISHED_D DATE ATE 7 도서표준 STANDARD VARCHAR2(1) 1:ISBN 2:ISSN 8 도서표준코드 STANDARD_C ODE VARCHAR2(13) Primary key BOOK_NUM
시스템명 도서대출시스템 페이지 5 테이블 ID BOOK_LEND_INFO 작성일 2007-06-09 테이블명 대여정보 작성자 서오석 순번 한글명 영문명 데이터타입 ( 길이 ) NULL Default PK FK 속성정의 1 회원번호 USER_NUM NUMBER(8) N Y 2 도서번호 BOOK_NUM NUMBER(8) N Y 3 도서위치번호 LOCATION_NU M NUMBER(4) 4 대출일자 LEND_DATE DATE 5 반납일자 RETURN_DATE DATE Primary key USER_NUM, BOOK_NUM Y 시스템명 도서대출시스템 페이지 6 테이블 ID LOACTION 작성일 2007-06-09 테이블명 도서위치정보 작성자 서오석 순번 한글명 영문명 데이터타입 ( 길이 ) NULL Default PK FK 속성정의 1 위치번호 LOCATION_NU M 2 위치명 LOCATION_DE SC Primary key LOCATION_NUM NUMBER(4) N Y VARCHAR2(10) 시스템명 도서대출시스템 페이지 7 테이블 ID PUBLISHER 작성일 2007-06-09 테이블명 출판사정보 작성자 서오석 순번 한글명 영문명 데이터타입 ( 길이 ) NULL Default PK FK 속성정의 1 출판사번호 PUBLISHER_N NUMER(8) N Y UM 2 출판사이름 PUBLISHER_N VARCHAR2(30) AME 3 출판사주소 ADDRESSS VARCHAR2(100) 4 전화번호 PHONE_NUM VARCHAR2(15) BER 5 이메일 E_MAIL VARCHAR2(25)
Primary key PUBLISHER_NUM 시스템명 도서대출시스템 페이지 8 테이블 ID WROTE 작성일 2007-06-09 테이블명 저자서적분류 작성자 서오석 순번 한글명 영문명 데이터타입 ( 길이 ) NULL Default PK FK 속성정의 1 도서번호 BOOK_NUM NUMBER(8) N Y Y 2 저자번호 AUTHOR_NU NUMBER(8) N Y Y M 3 저자분류 SEQUENCE VARCHAR2(1) 1: 주저자 2: 부저자 Primary key BOOK_NUM, AUTHOR_NUM 시스템명 도서대출시스템 페이지 9 테이블 ID AUTHOR 작성일 2007-06-09 테이블명 저자 작성자 서오석 순번 한글명 영문명 데이터타입 ( 길이 ) NULL Default PK FK 속성정의 1 저자번호 AUTHOR_NU NUMBER(8) N Y M 2 성별 SEX VARCHAR2(1) 1: 남자 2: 여자 3 이름 LAST_NAME VARCHAR2(15) 4 성 FIRST_NAME VARCHAR2(15) 5 주소 ADDRESS VARCHAR2(100) 6 전화번호 PHONE_NUM VARCHAR2(15) BER 7 이메일 E_MAIL VARCHAR2(25) Primary key AUTHOR_NUM
시스템명 도서대출시스템 페이지 10 테이블 ID BLACKLIST 작성일 2007-06-09 테이블명 블랙리스트 작성자 서오석 순번 한글명 영문명 데이터타입 ( 길이 ) NULL Default PK FK 속성정의 1 회원번호 LIST_NUM NUMBER(8) N Y 학번 2 불량사유 DESCRIPTION VARCHAR2(200) Primary key BLACKLIST 3.0 DDL CREATE SQL 3.1 저자 CREATE TABLE AUTHOR ( AUTHOR_NUM NUMBER(8) NOT NULL, SEX VARCHAR2(1) NULL, LAST_NAME VARCHAR2(15) NULL, FIRST_NAME VARCHAR2(15) NULL, ADDRESS VARCHAR2(100) NULL, PHONE_NUMBER VARCHAR2(15) NULL, E_MAIL VARCHAR2(25) NULL, CONSTRAINT XPKAUTHOR PRIMARY KEY (AUTHOR_NUM) ); 3.2 도서위치정보 CREATE TABLE LOCATION ( LOCATION_NUM NUMBER(4) NOT NULL, LOCATION_DESC VARCHAR2(10) NULL, CONSTRAINT XPKLOCATION PRIMARY KEY (LOCATION_NUM) ); 3.3 출판사정보 CREATE TABLE PUBLISHER ( PUBLISHER_NUM NUMBER(8) NOT NULL, PUBLISHER_NAME VARCHAR2(15) NULL, ADDRESS VARCHAR2(100) NULL, PHONE_NUMBER VARCHAR2(15) NULL, E_MAIL VARCHAR2(25) NULL, CONSTRAINT XPKPUBLISHER PRIMARY KEY (PUBLISHER_NUM) );
3.4 도서정보 CREATE TABLE BOOK ( BOOK_NUM NUMBER(8) NOT NULL, LOCATION_NUM NUMBER(4) NOT NULL, PUBLISHER_NUM NUMBER(8) NOT NULL, TITLE VARCHAR2(100) NULL, TYPE VARCHAR2(10) NULL, PUBLISHED_DATE DATE NULL, STANDARD VARCHAR2(1) NULL, STANDARD_CODE VARCHAR2(13) NULL, CONSTRAINT XPKBOOK PRIMARY KEY (BOOK_NUM), CONSTRAINT R_15 FOREIGN KEY (LOCATION_NUM) REFERENCES LOCATION, CONSTRAINT R_9 FOREIGN KEY (PUBLISHER_NUM) REFERENCES PUBLISHER ); 3.5 저자서적분류 CREATE TABLE WROTE ( BOOK_NUM NUMBER(8) NOT NULL, SEQUENCE VARCHAR2(1) NULL, AUTHOR_NUM NUMBER(8) NOT NULL, CONSTRAINT XPKWROTE PRIMARY KEY (AUTHOR_NUM, BOOK_NUM), CONSTRAINT R_12 FOREIGN KEY (AUTHOR_NUM) REFERENCES AUTHOR, CONSTRAINT R_11 FOREIGN KEY (BOOK_NUM) REFERENCES BOOK ); 3.6 회원직급 CREATE TABLE USER_TYPE ( TYPE_NUM NUMBER(2) NOT NULL, TYPE_DESC VARCHAR2(15) NULL, GRADE_DESC NUMBER(2) NULL, CONSTRAINT XPKUSER_TYPE PRIMARY KEY (TYPE_NUM) );
3.7 대출권한 CREATE TABLE LEND_AUTHORITY ( AUTHORITY_NUM NUMBER(2) NOT NULL, AUTHORITY_DESC VARCHAR2(25) NULL, CONSTRAINT XPKLEND_AUTHORITY PRIMARY KEY (AUTHORITY_NUM) ); 3.8 회원 CREATE TABLE USERS ( USER_NUM NUMBER(8) NOT NULL, AUTHORITY_NUM NUMBER(8) NOT NULL, SEX VARCHAR2(1) NULL, FIRST_NAME VARCHAR2(15) NULL, LAST_NAME VARCHAR2(15) NULL, COURSE VARCHAR2(15) NULL, PHONE_NUMBER VARCHAR2(15) NULL, E_MAIL VARCHAR2(25) NULL, ADDRESS VARCHAR2(100) NULL, TYPE_NUM NUMBER(2) NOT NULL, CONSTRAINT XPKUSERS PRIMARY KEY (USER_NUM), CONSTRAINT R_17 FOREIGN KEY (AUTHORITY_NUM) REFERENCES LEND_AUTHORITY, CONSTRAINT R_3 FOREIGN KEY (TYPE_NUM) REFERENCES USER_TYPE ); 3.9 대출정보 CREATE TABLE BOOK_LEND_INFO ( LEND_NUM NUMBER(8) NOT NULL, LEND_DATE DATE NULL, RETURN_DATE DATE NULL, BOOK_NUM NUMBER(8) NOT NULL, USER_NUM NUMBER(8) NOT NULL, CONSTRAINT XPKBOOK_LEND_INFO PRIMARY KEY (LEND_NUM), CONSTRAINT R_20 FOREIGN KEY (BOOK_NUM) REFERENCES BOOK, CONSTRAINT R_19 FOREIGN KEY (USER_NUM)
REFERENCES USERS ); 3.10 블랙리스트 CREATE TABLE BLACKLIST ( LIST_NUM NUMBER(8) NOT NULL, USER_NUM NUMBER(8) NOT NULL, DESCRIPTION VARCHAR2(200) NULL, CONSTRAINT XPKBLACKLIST PRIMARY KEY (LIST_NUM) ); 4.0 Data loading 4.1 저자 INSERT INTO AUTHOR ('4', '2', 'Noh', 'Taesin', 'Seoul', '767-9984', 'Notae@daum.net'); INSERT INTO AUTHOR ('5', '1', 'Sung', 'Kiwon', 'Busan', '445-1112', 'Soul@naver.com'); INSERT INTO AUTHOR ('6', '1', 'Kim', 'Jieun', 'Anyang', '229-9988', 'Elegarden@smu.ac.kr'); INSERT INTO AUTHOR ('7', '2', 'Iron', 'Maiden', 'LA', '249-0898', 'fear@nate.com'); INSERT INTO AUTHOR ('8', '1', 'Dream', 'Theater', 'Boston', '223-5556', 'Dream1982@nate.com'); INSERT INTO AUTHOR ('9', '1', 'Off', 'Spring', 'Suyoo', '6654-0110', 'spring@naver.com'); INSERT INTO AUTHOR ('10', '1', 'Green', 'Day', 'Walla', '5568-0043', 'Walla2@smu.ac.kr'); INSERT INTO AUTHOR ('11', '1', 'Ivy', 'Hyori', 'Music', '1267-2223', 'Sexygirl@daum.net'); INSERT INTO AUTHOR ('12', '1', 'Jung', 'Down', 'Heart', '104-3453', 'Mylover@smu.ac.kr'); INSERT INTO AUTHOR
('13', '2', 'Seo', 'Osuk', 'Hongeun', '667-9999', '5dols@naver.com'); INSERT INTO AUTHOR ('14', '1', 'Rionel', 'Messi', 'Argen', '842-0088', 'soccer@lycos.com'); INSERT INTO AUTHOR ('15', '1', 'Frank', 'Lampard', 'England', '990-3777', 'middlefield@river.com'); 4.2 도서위치정보 INSERT INTO LOCATION ('1', 'Fiction'); INSERT INTO LOCATION ('2', 'Computer'); INSERT INTO LOCATION ('3', 'History'); INSERT INTO LOCATION ('4', 'Science'); INSERT INTO LOCATION ('5', 'Biography'); INSERT INTO LOCATION ('6', 'Nonfiction'); INSERT INTO LOCATION ('7', 'Finance'); INSERT INTO LOCATION ('8', 'Art'); INSERT INTO LOCATION ('9', 'Etc'); 4.3 출판사정보 ('1', 'Bantam', 'Suwon', '234-1456', 'Bantam@bantam.com'); ('2', 'Penguin USA', 'Tokyo', '436-3256', 'PUSA@pusa.com');
('3', 'Addison-Wesley', 'Hawai', '27-8456', 'Addison@aw.com'); ('4', 'Press', 'Seoul', '897-9754', 'Press@press.com'); ('5', 'AK Peters', 'Anyang', '456-7656', 'AK@ak.com'); ('6', 'Palgrave', 'Busan', '987-2638', 'Palgrave@pm.com'); ('7', 'Random House', 'Ansan', '878-4347', 'Random@rh.com'); ('8', 'Black Rabbit', 'Kyoto', '909-1013', 'Black@br.com'); ('9', 'Oxford Univ', 'Osaka', '787-1010', 'Oxford@ou.com'); ('10', 'Skylight Pub', 'Inchon', '2444-5667', 'Skylight@sp.com'); ('11', 'School Special', 'Gumi', '5060-1121', 'SchoolS@ss.com'); ('12', 'McGraw Hill', 'Jeju', '3943-1034', 'Mcgraw@mh.com'); ('13', 'Prentice Hall', 'Sanghai', '234-7390', 'Prentice@ph.com'); ('14', 'Perseus', 'Boston', '6578-1003', 'Perseus@per.com'); ('15', 'Taschen', 'Seoul', '2220-7698', 'Taschen@tas.com'); ('16', 'McGraw Media', 'Suwon', '1114-4111', 'McGraw@media.com');
('17', 'John Sons', 'Inchon', '299-2255', 'Johnsons@js.com'); ('18', 'Independent', 'Suwon', '909-0080', 'Independent@ind.com'); 4.4 도서정보 ('1', '1', '1', '50 Great Short Stories', 'Fiction', '1995-07-01', '1', '0553277456'); ('2', '1', '2', 'Charlie and the Chocolate Factory', 'Fiction', '1998-11-01', '1', '0141301155'); ('3', '2', '3', 'Art of Computer Programming Vol.1', 'Computer', '1997-6-1', '1', '0201896834'); ('4', '2', '4', 'Ai Techniques for Game Programming', 'Computer', '2002-10-01', '1', '193184108X'); ('5', '2', '5', 'Computer Arithmetic Algorithms', 'Computer', '2001-11-01', '1', '1568811608'); ('6', '3', '6', 'Andreas Capellanus On Love?', 'History', '2007-06-26', '1', '1403967709'); ('7', '3', '6', 'Langland''s Early Modern Id', 'History', '2007-11-27', '1', '140396517X'); ('8', '1', '2', 'Around the World in 80 Days', 'Fiction', '2004-01-01', '1', '014036711X'); ('9', '1', '7', 'The Giver', 'Fiction', '2002-09-01', '1', '0440237688'); ('10', '2', '5', 'Data Structure', 'Computer', '1989-02-14', '2', '1596450653'); ('11', '4', '8', 'Food And the World', 'Science', '2007-01-01', '1', '1596040653'); ('12', '5', '9', 'Francis Crick and James Watson', 'Biography', '1998-05-01', '1', '0195114515');
('13', '5', '9', 'Galileo Galilei', 'Biography', '1999-03-01', '2', '0195131703'); ('14', '2', '10', 'Java Methods a And Ab', 'Computer', '2006-03-15', '1', '0972705570'); ('15', '6', '11', 'Total Reading', 'Nonfiction', '2005-05-09', '2', '076963883X'); ('16', '7', '12', 'The Big Book of Flip Charts', 'Finance', '1999-10-01', '2', '0071343113'); ('17', '7', '13', 'Options, Futures, and Other Derivatives', 'Finance', '2006-01-01', '2', '0131977059'); ('18', '8', '14', 'World Graphic Design', 'Art', '2004-04-01', '1', '1858942195'); ('19', '8', '15', 'Marc Chagall (Taschen Portfolio)', 'Art', '2003-09-01', '1', '3822828866'); ('20', '2', '16', 'Oracle Database 10G Xml N SQL', 'Computer', '2004-07-01', '2', '0072229527'); ('21', '2', '17', 'Enterprise Architecture Planning', 'Computer', '1992-11-01', '1', '0471599859'); ('22', '2', '18', 'Maximum Lego Nxt', 'Computer', '2007-04-30', '2', '0973864915'); ('23', '2', '4', 'Developing Drivers', 'Computer', '2007-04-25', '1', '0735623740'); ('24', '2', '16', 'Aix 5L Administration', 'Computer', '2002-08-01', '1', '0072222557'); ('25', '2', '5', 'Games And Simulations', 'Computer', '2006-09-30', '1', '1599043041'); ('26', '9', '10', 'Ribbonwork The Complete Guide', 'Etc', '2004-07-01', '1', '0873497503'); ('27', '9', '10', 'The Secrets of Fashioning Flowers', 'Etc', '1998-02-01', '2', '0873415620');
('28', '7', '13', 'Grid Computing', 'Finance', '1999-04-09', '1', '0131456601'); ('29', '7', '9', 'Introduction to the Economics', 'Finance', '2003-06-16', '1', '0199243255'); ('30', '2', '15', 'Google Pagerank and Beyond', 'Computer', '2006-07-13', '2', '0691122024'); ('31', '2', '13', 'Human-Computer Interaction', 'Computer', '2003-09-01', '1', '0130461091'); 4.5 저자서적분류 ('1', '1', '1'); ('1', '5', '2'); ('2', '2', '1'); ('3', '3', '1'); ('4', '4', '1'); ('5', '5', '1'); ('6', '6', '1'); ('6', '13', '2'); ('7', '7', '1'); ('8', '8', '1');
('9', '9', '1'); ('9', '3', '2'); ('10', '10', '1'); ('11', '11', '1'); ('12', '12', '1'); ('13', '13', '1'); ('14', '14', '1'); ('15', '15', '1'); ('16', '14', '1'); ('16', '4', '2'); ('17', '7', '1'); ('17', '15', '2'); ('18', '4', '1'); ('18', '7', '2');
('19', '2', '1'); ('20', '2', '1'); ('21', '7', '1'); ('22', '9', '1'); ('22', '3', '2'); ('23', '10', '1'); ('23', '5', '2'); ('24', '5', '1'); ('24', '11', '2'); ('25', '13', '1'); ('26', '12', '1'); ('27', '12', '1'); ('28', '9', '1'); ('29', '13', '1');
('29', '7', '2'); ('30', '6', '1'); ('30', '14', '2'); ('31', '3', '1'); 4.6 회원직급 insert into user_type values(1,' 대학생 ',5); insert into user_type values(2,' 대학원생 ',10); insert into user_type values(3,' 교수 ',15); 4.7 대출권한 insert into lend_authority values(1,' 일반 '); insert into lend_authority values(2,' 장기연체 '); 4.8 회원 values(19901111,1,'1','lim','jwasang','software','011-9018-8311','aaaaa@smu.ac.kr','seoul',3); values(19901112,1,'2','lim','jwasun','economy','011-8976-7654','bbbbb@hotmail.com','inchon',3); values(19901113,1,'1','lim','jasin','music','011-8765-9876','asdf@smu.ac.kr','seoul',3); values(19901114,1,'2','lim','jin','art','018-9018-8311','qwer@smu.ac.kr','seoul',3); values(19901115,1,'1','park','jiyeon','food','017-9018-8311','zxcv@smu.ac.kr','seoul',3); values(19971114,1,'2','jung','deasick','computer','010-1234-5678','qwer@smu.ac.kr','inchon',2); values(19971115,1,'1','park','kangryung','computer','001-5678-9876','zxcv@smu.ac.kr','pusan',3); values(19991001,1,'2','kim','su','se','011-9018-8311','aaaaa@smu.ac.kr','seoul',1); values(19991002,1,'2','kang','jiwon','se','011-8976-7654','bbbbb@hotmail.com','inchon',1);
values(19991003,1,'2','lee','yumi','se','011-8765-9876','asdf@smu.ac.kr','seoul',1); values(19991004,1,'2','lim','jina','se','018-9018-8311','qwer@smu.ac.kr','seoul',1); values(19991005,1,'2','ha','jiyeon','se','017-9018-8311','zxcv@smu.ac.kr','seoul',1); values(20010001,1,'1','kim','su','se','016-9018-8311','poiu@smu.ac.kr','seoul',1); values(20010002,1,'1','kang','jiwon','se','017-9018-8311','lkkjh@hotmail.com','seoul',1); values(20010003,1,'1','lee','yumi','se','018-6543-8765','cndh@smu.ac.kr','seoul',1); values(20010004,1,'1','lim','jina','se','019-9012-8312','ereri@smu.ac.kr','seoul',1); values(20010005,1,'1','ha','jiyeon','se','011-3847-3948','dfdff@smu.ac.kr','seoul',1); values(20020001,1,'1','kim','haha','economy','016-9018-8311','poiu@smu.ac.kr','seoul',1); values(20020002,1,'1','kang','hoho','media','017-9018-8311','lkkjh@hotmail.com','seoul',1); values(20020003,1,'1','lee','huhu','economy','018-6543-8765','cndh@smu.ac.kr','seoul',1); values(20020004,1,'1','lim','heehee','computer','019-9012-8312','ereri@smu.ac.kr','seoul',1); values(20020005,1,'1','ha','kaka','computer','011-3847-3948','dfdff@smu.ac.kr','seoul',1); values(20030001,1,'2','kim','ronaldo','economy','016-9018-8311','poiu@smu.ac.kr','suwon',1); values(20030002,1,'2','kang','roony','media','017-9018-8311','lkkjh@hotmail.com','seoul',2); values(20030003,1,'2','lee','jisung','economy','018-6543-8765','cndh@smu.ac.kr','suwon',3); values(20030004,1,'1','lim','yakubu','computer','019-9012-8312','ereri@smu.ac.kr','seoul',1); values(20030005,1,'1','ha','yamaha','computer','011-3847-3948','dfdff@smu.ac.kr','suwon',2); 4.9 대출정보 insert into book_lend_info values('20',19901111,'2007-06-01','2007-06-14'); insert into book_lend_info values('19',19901111,'2007-06-01','2007-06-14'); insert into book_lend_info values('15',19901111,'2007-06-01','2007-06-14'); insert into book_lend_info
values('18',19971114,'2007-06-01','2007-06-22'); insert into book_lend_info values('17',19971114,'2007-06-01','2007-06-22'); insert into book_lend_info values('16',19971114,'2007-06-01','2007-06-22'); insert into book_lend_info values('10',20010001,'2007-06-01','2007-06-14'); insert into book_lend_info values('11',20010001,'2007-06-01','2007-06-14'); insert into book_lend_info values('12',20010001,'2007-06-01','2007-06-14'); 4.10 블랙리스트 INSERT INTO BLACKLIST ('1', '20020003', ' 책분실 '); INSERT INTO BLACKLIST ('2', '20030002', ' 장기미반납 '); INSERT INTO BLACKLIST ('3', '20030004', ' 장기미반납 '); INSERT INTO BLACKLIST ('4', '20030005', ' 장기미반납 '); 5.0 Grant SQL GRANT SELECT ON USERS TO ADMIN; GRANT SELECT ON USER_TYPE TO ADMIN; GRANT SELECT ON LEND_AUTHORITY TO ADMIN; GRANT SELECT ON BLACKLIST TO ADMIN; GRANT SELECT ON BOOK_LEND_INFO TO ADMIN; GRANT SELECT ON LOCATION TO ADMIN; GRANT SELECT ON PUBLISHER TO ADMIN; GRANT SELECT ON AUTHOR TO ADMIN; GRANT SELECT ON WROTE TO ADMIN; GRANT SELECT ON BOOK TO ADMIN; GRANT INSERT ON USERS TO ADMIN; GRANT INSERT ON USER_TYPE TO ADMIN; GRANT INSERT ON LEND_AUTHORITY TO ADMIN; GRANT INSERT ON BLACKLIST TO ADMIN; GRANT INSERT ON BOOK_LEND_INFO TO ADMIN; GRANT INSERT ON LOCATION TO ADMIN; GRANT INSERT ON PUBLISHER TO ADMIN;
GRANT INSERT ON AUTHOR TO ADMIN; GRANT INSERT ON WROTE TO ADMIN; GRANT INSERT ON BOOK TO ADMIN; GRANT UPDATE ON USERS TO ADMIN; GRANT UPDATE ON USER_TYPE TO ADMIN; GRANT UPDATE ON LEND_AUTHORITY TO ADMIN; GRANT UPDATE ON BLACKLIST TO ADMIN; GRANT UPDATE ON BOOK_LEND_INFO TO ADMIN; GRANT UPDATE ON LOCATION TO ADMIN; GRANT UPDATE ON PUBLISHER TO ADMIN; GRANT UPDATE ON AUTHOR TO ADMIN; GRANT UPDATE ON WROTE TO ADMIN; GRANT UPDATE ON BOOK TO ADMIN; GRANT DELETE ON USERS TO ADMIN; GRANT DELETE ON USER_TYPE TO ADMIN; GRANT DELETE ON LEND_AUTHORITY TO ADMIN; GRANT DELETE ON BLACKLIST TO ADMIN; GRANT DELETE ON BOOK_LEND_INFO TO ADMIN; GRANT DELETE ON LOCATION TO ADMIN; GRANT DELETE ON PUBLISHER TO ADMIN; GRANT DELETE ON AUTHOR TO ADMIN; GRANT DELETE ON WROTE TO ADMIN; GRANT DELETE ON BOOK TO ADMIN;