BRIGHTMATE_LIBRARY.sql

/*
 Navicat Premium Data Transfer

 Source Server         : LIBRARY_MANAGEMENT
 Source Server Type    : Oracle
 Source Server Version : 120200
 Source Host           : 103.94.135.201:1521
 Source Schema         : TFUSER11

 Target Server Type    : Oracle
 Target Server Version : 120200
 File Encoding         : 65001

 Date: 25/02/2022 19:08:40
*/


-- ----------------------------
-- Table structure for AUTHOR
-- ----------------------------
DROP TABLE "TFUSER11"."AUTHOR";
CREATE TABLE "TFUSER11"."AUTHOR" (
  "AUTHOR_ID" NUMBER VISIBLE NOT NULL,
  "AUTHOR_NAME" VARCHAR2(100 BYTE) VISIBLE NOT NULL,
  "DATE_OF_BIRTH" DATE VISIBLE,
  "DATE_OF_DEATH" DATE VISIBLE,
  "BIO" VARCHAR2(1000 BYTE) VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of AUTHOR
-- ----------------------------
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('1', 'HUMAYUN AHMED', TO_DATE('1948-11-13 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2012-07-19 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'Humayun Ahmed was a Bangladeshi novelist, dramatist, screenwriter, filmmaker, songwriter, scholar, and professor. His breakthrough was his debut novel Nondito Noroke published in 1972. He wrote over 200 fiction and non-fiction books, many of which were bestsellers in Bangladesh. ');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('2', 'Rabindranath Tagore', TO_DATE('1861-05-07 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('1941-08-07 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'Rabindranath Tagore was a Bengali polymath—poet, writer, playwright, composer, philosopher, social reformer and painter. He reshaped Bengali literature and music as well as Indian art with Contextual Modernism in the late 19th and early 20th centuries.');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('3', 'Kazi Nazrul Islam', TO_DATE('1899-05-24 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('1976-08-29 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'Kazi Nazrul Islam was a Bengali poet, writer, musician, and the national poet of Bangladesh. Popularly known as Nazrul, he produced a large body of poetry and music with themes that included religious devotion and rebellion against oppression.');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('8', 'Thomas H. Cormen', NULL, NULL, NULL);
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('9', 'Ronald Rivest', NULL, NULL, 'Ronald Rivest');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('10', 'Charles E. Leiserson', TO_DATE('2022-01-29 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2022-02-09 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'Charles E. Leiserson');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('15', 'J. K. Rowling', TO_DATE('1965-07-31 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, 'Joanne Rowling, CH, OBE, HonFRSE, FRCPE, FRSL, known by her pen name J. K. Rowling, is a British author, philanthropist, film producer, and screenwriter.');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('16', 'DEMO AUTHOR', TO_DATE('2022-03-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, 'FAAAAAAAAAAAAAAAAAAAAAAA');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('19', 'New Test Author', TO_DATE('1995-07-12 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, 'Test bio');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('4', 'Sarat Chandra Chattopadhyay', TO_DATE('1876-09-15 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('1938-01-16 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'Sarat Chandra Chattopadhyay was a Bengali novelist and short story writer of the early 20th century. Most of his works deal with the lifestyle, tragedy and struggle of the village people and the contemporary social practices that prevailed in Bengal.');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('12', 'Muhammad Zafar Iqbal', TO_DATE('1952-12-23 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, 'Muhammed Zafar Iqbal is a Bangladeshi science fiction author, physicist, academic, activist & former professor of computer science and engineering and Head of the department of Electrical and Electronic Engineering at Shahjalal University of Science and Technology. He achieved his PhD from University of Washington.');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('13', 'Sidney Sheldon', TO_DATE('1917-02-11 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2007-01-30 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'Sidney Sheldon was an American writer, director, and producer. Sheldon was prominent in the 1930s, first working on Broadway plays, and then in motion pictures, notably writing the successful comedy The Bachelor and the Bobby-Soxer, which earned him an Oscar in 1948.');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('5', 'Satyajit Ray', TO_DATE('1921-05-02 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('1992-04-23 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'Satyajit Ray was an Indian filmmaker, screenwriter, documentary filmmaker, author, essayist, lyricist, magazine editor, illustrator, calligrapher, and music composer. Ray is widely considered one of the greatest filmmakers of all time. ');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('6', 'Colleen Hoover', TO_DATE('1979-12-11 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, 'Colleen Hoover is an author of young adult fiction and romance novels. She published her first novel, Slammed, in January 2012. In December 2012, she published Hopeless, which rose to the top of the New York Times best seller list.');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('7', 'সেলিনা হোসেন', TO_DATE('1947-06-14 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, 'সেলিনা হোসেন (জন্ম ১৪ জুন ১৯৪৭)[১] বাংলাদেশের একজন প্রখ্যাত ঔপন্যাসিক। তার উপন্যাসে প্রতিফলিত হয়েছে সমকালের সামাজিক ও রাজনৈতিক দ্বন্দ্ব সংকটের সামগ্রিকতা। বাঙালির অহংকার ভাষা আন্দোলন ও মুক্তিযুদ্ধের প্রসঙ্গ তার লেখায় নতুন মাত্রা যোগ করেছে।');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('11', 'Clifford Stein', NULL, NULL, 'Algorithm');
INSERT INTO "TFUSER11"."AUTHOR" VALUES ('18', 'KS Khan', TO_DATE('1997-09-16 06:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, 'Nothing to say');

-- ----------------------------
-- Table structure for BOOKS
-- ----------------------------
DROP TABLE "TFUSER11"."BOOKS";
CREATE TABLE "TFUSER11"."BOOKS" (
  "BOOK_ID" NUMBER VISIBLE NOT NULL,
  "BOOK_TITLE" VARCHAR2(500 BYTE) VISIBLE NOT NULL,
  "YEAR_OF_PUBLICATION" NUMBER(4,0) VISIBLE,
  "DESCRIPTION" VARCHAR2(500 BYTE) VISIBLE,
  "LANGUAGE" VARCHAR2(45 BYTE) VISIBLE,
  "PUBLISHER_ID" NUMBER VISIBLE NOT NULL,
  "ISBN" VARCHAR2(30 BYTE) VISIBLE DEFAULT '#' NOT NULL,
  "AVAILABLE_COPIES" NUMBER VISIBLE DEFAULT 0
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of BOOKS
-- ----------------------------
INSERT INTO "TFUSER11"."BOOKS" VALUES ('2', 'Gitanjali', '1909', 'Tagore received the Nobel Prize for Literature, largely for the English translation, Song Offerings. It is part of the UNESCO Collection of Representative Works. Its central theme is devotion, and its motto is - I am here to sing thee songs', 'Bangla', '6', '9788174764270', '20');
INSERT INTO "TFUSER11"."BOOKS" VALUES ('29', 'Harry Potter and the Philosopher''s Stone', '1997', 'Harry Potter''s life is miserable. His parents are dead and he''s stuck with his heartless relatives, who force him to live in a tiny closet under the stairs. But his fortune changes when he receives a letter that tells him the truth about himself: he''s a wizard. A mysterious visitor rescues him from his relatives and takes him to his new home, Hogwarts School of Witchcraft and Wizardry.', 'English', '15', '524189734615', '14');
INSERT INTO "TFUSER11"."BOOKS" VALUES ('1', 'Jochona O Jononir Golpo', '2005', 'Jochna O Jononir Golpo is a novel based on the Liberation War of Bangladesh.', 'Bangla', '3', '9789845021326', '10');
INSERT INTO "TFUSER11"."BOOKS" VALUES ('4', 'শেষের কবিতা', '1929', 'Shesher Kabita is a novel by Rabindranath Tagore. The novel was serialised in 1928, from Bhadra to Choitro in the magazine Probashi, and was published in book form the following year. It has been translated into English as The Last Poem and Farewell song.', 'Bangla', '7', '9848794352', '12');
INSERT INTO "TFUSER11"."BOOKS" VALUES ('5', 'হাঙর নদী গ্রেনেড', '1976', 'হাঙর নদী গ্রেনেড উপন্যাসটি ১৯৭১ সালে বাংলাদেশের স্বাধীনতা যুদ্ধের সময়কালের যশোরের কালীগঞ্জ গ্রামের এক মায়ের সত্য ঘটনা অবলম্বনে রচনা', 'Bangla', '1', '9789844122994', '15');
INSERT INTO "TFUSER11"."BOOKS" VALUES ('13', 'INTRODUCTION TO ALGORITHMS', '1989', 'Introduction to Algorithms uniquely combines rigor and comprehensiveness. The book covers a broad range of algorithms in depth, yet makes their design and analysis accessible to all levels of readers. Each chapter is relatively self-contained and can be used as a unit of study.', 'English', '3', '9780262033848', '99');
INSERT INTO "TFUSER11"."BOOKS" VALUES ('31', 'Harry Potter and the Prisoner of Azkaban', '1999', 'Harry Potter and the Chamber of Secrets is a fantasy novel written by British author J. K. Rowling and the second novel in the Harry Potter series.', 'English', '15', '524189734617', '3');
INSERT INTO "TFUSER11"."BOOKS" VALUES ('30', 'Harry Potter and the Chamber of Secrets', '1998', 'Harry Potter and the Chamber of Secrets is a fantasy novel written by British author J. K. Rowling and the second novel in the Harry Potter series.', 'English', '15', '524189734616', '16');
INSERT INTO "TFUSER11"."BOOKS" VALUES ('32', 'Test book', '2020', 'Test Description', 'Bengali', '16', '1234567', '8');

-- ----------------------------
-- Table structure for BOOKS_AUTHORS
-- ----------------------------
DROP TABLE "TFUSER11"."BOOKS_AUTHORS";
CREATE TABLE "TFUSER11"."BOOKS_AUTHORS" (
  "BOOK_ID" NUMBER VISIBLE,
  "AUTHOR_ID" NUMBER VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of BOOKS_AUTHORS
-- ----------------------------
INSERT INTO "TFUSER11"."BOOKS_AUTHORS" VALUES ('29', '15');
INSERT INTO "TFUSER11"."BOOKS_AUTHORS" VALUES ('4', '2');
INSERT INTO "TFUSER11"."BOOKS_AUTHORS" VALUES ('5', '7');
INSERT INTO "TFUSER11"."BOOKS_AUTHORS" VALUES ('13', '8');
INSERT INTO "TFUSER11"."BOOKS_AUTHORS" VALUES ('13', '9');
INSERT INTO "TFUSER11"."BOOKS_AUTHORS" VALUES ('13', '10');
INSERT INTO "TFUSER11"."BOOKS_AUTHORS" VALUES ('13', '11');
INSERT INTO "TFUSER11"."BOOKS_AUTHORS" VALUES ('31', '15');
INSERT INTO "TFUSER11"."BOOKS_AUTHORS" VALUES ('2', '2');
INSERT INTO "TFUSER11"."BOOKS_AUTHORS" VALUES ('1', '1');
INSERT INTO "TFUSER11"."BOOKS_AUTHORS" VALUES ('30', '15');
INSERT INTO "TFUSER11"."BOOKS_AUTHORS" VALUES ('32', '19');

-- ----------------------------
-- Table structure for BOOKS_GENRE
-- ----------------------------
DROP TABLE "TFUSER11"."BOOKS_GENRE";
CREATE TABLE "TFUSER11"."BOOKS_GENRE" (
  "BOOK_ID" NUMBER VISIBLE,
  "GENRE_ID" NUMBER VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of BOOKS_GENRE
-- ----------------------------
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('29', '8');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('5', '1');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('5', '3');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('1', '23');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('1', '5');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('4', '5');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('4', '1');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('4', '2');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('31', '8');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('13', '3');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('13', '6');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('13', '7');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('2', '5');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('32', '5');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('32', '23');
INSERT INTO "TFUSER11"."BOOKS_GENRE" VALUES ('30', '8');

-- ----------------------------
-- Table structure for BOOK_COPY
-- ----------------------------
DROP TABLE "TFUSER11"."BOOK_COPY";
CREATE TABLE "TFUSER11"."BOOK_COPY" (
  "BOOK_COPY_ID" NUMBER VISIBLE NOT NULL,
  "EDITION" NUMBER VISIBLE NOT NULL,
  "BOOK_ID" NUMBER VISIBLE,
  "STATUS" NUMBER VISIBLE DEFAULT 1
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of BOOK_COPY
-- ----------------------------
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('209', '3', '2', '0');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('210', '3', '2', '0');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('211', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('212', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('213', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('214', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('215', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('216', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('217', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('218', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('219', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('220', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('221', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('222', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('223', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('224', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('225', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('226', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('227', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('228', '3', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('244', '4', '1', '0');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('245', '4', '1', '0');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('246', '4', '1', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('247', '4', '1', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('248', '4', '1', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('249', '4', '1', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('250', '4', '1', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('251', '4', '1', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('252', '4', '1', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('253', '4', '1', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('254', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('255', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('256', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('257', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('258', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('259', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('260', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('261', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('262', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('263', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('264', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('265', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('266', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('267', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('268', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('269', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('270', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('271', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('272', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('273', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('274', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('275', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('276', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('277', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('278', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('279', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('280', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('281', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('282', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('283', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('284', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('285', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('286', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('287', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('288', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('289', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('290', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('291', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('292', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('293', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('294', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('295', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('296', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('297', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('298', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('299', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('300', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('301', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('302', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('303', '9', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('356', '10', '29', '0');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('357', '10', '29', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('358', '10', '29', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('359', '10', '29', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('360', '10', '29', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('361', '10', '29', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('362', '10', '29', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('363', '10', '29', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('364', '10', '29', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('365', '10', '29', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('366', '10', '29', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('367', '10', '29', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('368', '10', '29', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('369', '10', '29', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('370', '10', '29', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('354', '2', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('355', '2', '2', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('422', '1', '1', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('423', '1', '1', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('404', '1', '30', '0');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('405', '1', '30', '0');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('406', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('407', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('408', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('409', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('410', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('411', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('412', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('413', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('414', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('415', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('416', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('417', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('418', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('419', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('420', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('421', '1', '30', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('304', '7', '13', '0');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('305', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('306', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('307', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('308', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('309', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('310', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('311', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('312', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('313', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('314', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('315', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('316', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('317', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('318', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('319', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('320', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('321', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('322', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('323', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('324', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('325', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('326', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('327', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('328', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('329', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('330', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('331', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('332', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('333', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('334', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('335', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('336', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('337', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('338', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('339', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('340', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('341', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('342', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('343', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('344', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('345', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('346', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('347', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('348', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('349', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('350', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('351', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('352', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('353', '7', '13', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('371', '8', '4', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('372', '8', '4', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('373', '8', '4', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('374', '8', '4', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('375', '8', '4', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('376', '8', '4', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('377', '8', '4', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('378', '8', '4', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('379', '8', '4', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('380', '8', '4', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('381', '8', '4', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('382', '8', '4', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('383', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('384', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('385', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('386', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('387', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('388', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('389', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('390', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('391', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('392', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('393', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('394', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('395', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('396', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('397', '1', '5', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('398', '9', '31', '0');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('399', '9', '31', '0');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('400', '9', '31', '0');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('401', '9', '31', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('402', '9', '31', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('403', '9', '31', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('424', '1', '32', '0');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('425', '1', '32', '0');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('426', '1', '32', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('427', '1', '32', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('428', '1', '32', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('429', '1', '32', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('430', '1', '32', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('431', '1', '32', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('432', '1', '32', '1');
INSERT INTO "TFUSER11"."BOOK_COPY" VALUES ('433', '1', '32', '1');

-- ----------------------------
-- Table structure for FINE_HISTORY
-- ----------------------------
DROP TABLE "TFUSER11"."FINE_HISTORY";
CREATE TABLE "TFUSER11"."FINE_HISTORY" (
  "FINE_HISTORY_ID" NUMBER VISIBLE NOT NULL,
  "USER_ID" NUMBER VISIBLE NOT NULL,
  "FINE_STARTING_DATE" DATE VISIBLE,
  "FEE_AMOUNT" NUMBER VISIBLE,
  "PAYMENT_STATUS" NUMBER(1,0) VISIBLE DEFAULT 0,
  "PAYMENT_DATE" DATE VISIBLE,
  "RENTAL_HISTORY_ID" NUMBER VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of FINE_HISTORY
-- ----------------------------
INSERT INTO "TFUSER11"."FINE_HISTORY" VALUES ('13', '25', TO_DATE('2022-01-22 03:28:13', 'SYYYY-MM-DD HH24:MI:SS'), '86', '0', NULL, '73');
INSERT INTO "TFUSER11"."FINE_HISTORY" VALUES ('14', '25', TO_DATE('2022-01-22 03:28:13', 'SYYYY-MM-DD HH24:MI:SS'), '86', '0', NULL, '74');
INSERT INTO "TFUSER11"."FINE_HISTORY" VALUES ('15', '25', TO_DATE('2022-01-22 03:28:13', 'SYYYY-MM-DD HH24:MI:SS'), '86', '0', NULL, '75');
INSERT INTO "TFUSER11"."FINE_HISTORY" VALUES ('16', '20', TO_DATE('2022-02-01 03:28:13', 'SYYYY-MM-DD HH24:MI:SS'), '66', '1', TO_DATE('2022-02-24 12:40:17', 'SYYYY-MM-DD HH24:MI:SS'), '71');
INSERT INTO "TFUSER11"."FINE_HISTORY" VALUES ('17', '21', TO_DATE('2022-02-01 03:28:13', 'SYYYY-MM-DD HH24:MI:SS'), '66', '0', NULL, '72');
INSERT INTO "TFUSER11"."FINE_HISTORY" VALUES ('18', '20', TO_DATE('2022-02-01 03:28:13', 'SYYYY-MM-DD HH24:MI:SS'), '66', '0', NULL, '70');

-- ----------------------------
-- Table structure for GENRE
-- ----------------------------
DROP TABLE "TFUSER11"."GENRE";
CREATE TABLE "TFUSER11"."GENRE" (
  "GENRE_ID" NUMBER VISIBLE NOT NULL,
  "GENRE_NAME" VARCHAR2(100 BYTE) VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of GENRE
-- ----------------------------
INSERT INTO "TFUSER11"."GENRE" VALUES ('20', 'ADULT');
INSERT INTO "TFUSER11"."GENRE" VALUES ('19', 'ART');
INSERT INTO "TFUSER11"."GENRE" VALUES ('18', 'BUSINESS');
INSERT INTO "TFUSER11"."GENRE" VALUES ('11', 'COMICS');
INSERT INTO "TFUSER11"."GENRE" VALUES ('15', 'CRIME');
INSERT INTO "TFUSER11"."GENRE" VALUES ('12', 'EDUCATION');
INSERT INTO "TFUSER11"."GENRE" VALUES ('21', 'FANTASY');
INSERT INTO "TFUSER11"."GENRE" VALUES ('14', 'FASHION');
INSERT INTO "TFUSER11"."GENRE" VALUES ('1', 'HISTORY');
INSERT INTO "TFUSER11"."GENRE" VALUES ('7', 'HORROR');
INSERT INTO "TFUSER11"."GENRE" VALUES ('9', 'HUMOR');
INSERT INTO "TFUSER11"."GENRE" VALUES ('16', 'MEDICAL');
INSERT INTO "TFUSER11"."GENRE" VALUES ('5', 'POETRY');
INSERT INTO "TFUSER11"."GENRE" VALUES ('2', 'ROMANCE');
INSERT INTO "TFUSER11"."GENRE" VALUES ('17', 'SCIENCE');
INSERT INTO "TFUSER11"."GENRE" VALUES ('4', 'SCIENCE-FICTION');
INSERT INTO "TFUSER11"."GENRE" VALUES ('10', 'SHORT-STORY');
INSERT INTO "TFUSER11"."GENRE" VALUES ('22', 'SPIRITUAL');
INSERT INTO "TFUSER11"."GENRE" VALUES ('13', 'TECHNOLOGY');
INSERT INTO "TFUSER11"."GENRE" VALUES ('8', 'TEEN-FICTION');
INSERT INTO "TFUSER11"."GENRE" VALUES ('6', 'THRILLER');
INSERT INTO "TFUSER11"."GENRE" VALUES ('23', 'Test Genre');
INSERT INTO "TFUSER11"."GENRE" VALUES ('3', 'WAR');

-- ----------------------------
-- Table structure for JOBS
-- ----------------------------
DROP TABLE "TFUSER11"."JOBS";
CREATE TABLE "TFUSER11"."JOBS" (
  "JOB_ID" NUMBER VISIBLE NOT NULL,
  "JOB_TITLE" VARCHAR2(45 BYTE) VISIBLE NOT NULL,
  "SALARY" VARCHAR2(45 BYTE) VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of JOBS
-- ----------------------------
INSERT INTO "TFUSER11"."JOBS" VALUES ('1', 'LIBRARIAN', '30000');
INSERT INTO "TFUSER11"."JOBS" VALUES ('2', 'LIBRARY TECHNICIAN', '12500');
INSERT INTO "TFUSER11"."JOBS" VALUES ('3', 'LIBRARY ASSISTANT', '20000');
INSERT INTO "TFUSER11"."JOBS" VALUES ('4', 'PUBLIC RELATION OFFICER', '35000');
INSERT INTO "TFUSER11"."JOBS" VALUES ('5', 'ADMINISTRATIVE SERVICES MANAGER', '40000');
INSERT INTO "TFUSER11"."JOBS" VALUES ('6', 'JANITOR', '10000');

-- ----------------------------
-- Table structure for MAGAZINES
-- ----------------------------
DROP TABLE "TFUSER11"."MAGAZINES";
CREATE TABLE "TFUSER11"."MAGAZINES" (
  "MAGAZINE_ID" NUMBER VISIBLE NOT NULL,
  "MAGAZINE_TITLE" VARCHAR2(45 BYTE) VISIBLE NOT NULL,
  "PUBLISHER_ID" NUMBER VISIBLE,
  "LANGUAGE" VARCHAR2(45 BYTE) VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of MAGAZINES
-- ----------------------------
INSERT INTO "TFUSER11"."MAGAZINES" VALUES ('2', 'কিশোর আলো ২০২২', '1', 'Bangla');
INSERT INTO "TFUSER11"."MAGAZINES" VALUES ('1', 'কিশোর আলো', '8', 'Bangla');
INSERT INTO "TFUSER11"."MAGAZINES" VALUES ('3', 'কিআ', '1', 'Bangla');
INSERT INTO "TFUSER11"."MAGAZINES" VALUES ('4', 'Rosh Alo', '8', 'Bangla');
INSERT INTO "TFUSER11"."MAGAZINES" VALUES ('5', 'VOGUE', '9', 'English');
INSERT INTO "TFUSER11"."MAGAZINES" VALUES ('6', 'Magazine 01', '13', 'German');

-- ----------------------------
-- Table structure for MAGAZINES_GENRE
-- ----------------------------
DROP TABLE "TFUSER11"."MAGAZINES_GENRE";
CREATE TABLE "TFUSER11"."MAGAZINES_GENRE" (
  "MAGAZINE_ID" NUMBER VISIBLE,
  "GENRE_ID" NUMBER VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of MAGAZINES_GENRE
-- ----------------------------
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('2', '9');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('2', '11');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('1', '9');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('1', '11');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('5', '2');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('5', '8');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('4', '9');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('4', '11');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('5', '13');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('3', '1');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('3', '3');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('3', '11');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('6', '13');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('6', '12');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('6', '11');
INSERT INTO "TFUSER11"."MAGAZINES_GENRE" VALUES ('6', '14');

-- ----------------------------
-- Table structure for PUBLISHER
-- ----------------------------
DROP TABLE "TFUSER11"."PUBLISHER";
CREATE TABLE "TFUSER11"."PUBLISHER" (
  "PUBLISHER_ID" NUMBER VISIBLE NOT NULL,
  "PUBLISHER_NAME" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "PHONE" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "ADDRESS_LINE" VARCHAR2(300 BYTE) VISIBLE,
  "CITY" VARCHAR2(50 BYTE) VISIBLE,
  "POSTAL_CODE" VARCHAR2(50 BYTE) VISIBLE,
  "COUNTRY" VARCHAR2(50 BYTE) VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of PUBLISHER
-- ----------------------------
INSERT INTO "TFUSER11"."PUBLISHER" VALUES ('7', 'Others 2', '123456', 'Dhanmondi', 'Dhaka', '1209', 'Bangladesh');
INSERT INTO "TFUSER11"."PUBLISHER" VALUES ('17', 'New Publlisher', '1234', 'Dhaka, Bangladesh', 'Dhaka', '1207', 'Bangladesh');
INSERT INTO "TFUSER11"."PUBLISHER" VALUES ('9', 'The MIT Press', '617-253-5646', '12th floor of One Broadway', 'Cambridge', 'MA 02142', 'USA');
INSERT INTO "TFUSER11"."PUBLISHER" VALUES ('16', 'Test Publisher', '1234', 'Address', 'abc', '13', 'BD');
INSERT INTO "TFUSER11"."PUBLISHER" VALUES ('15', 'BloomsBury', '+44 (0)20 7631 5600', '31 Bedford Avenue', 'London', 'WC1B 3AT', 'England');
INSERT INTO "TFUSER11"."PUBLISHER" VALUES ('3', 'Ankur Prokashoni', '02 7111069', '38/4, banglabazar', 'Dhaka', '1100', 'Bangladesh');
INSERT INTO "TFUSER11"."PUBLISHER" VALUES ('4', 'BoiBazar.com', '+88-09638777777', NULL, NULL, NULL, NULL);
INSERT INTO "TFUSER11"."PUBLISHER" VALUES ('5', 'Somoy Prokashon', '+88 02 7121652', NULL, NULL, NULL, NULL);
INSERT INTO "TFUSER11"."PUBLISHER" VALUES ('6', 'Seba Prokashani', '+ 88 02 8314184', NULL, NULL, NULL, NULL);
INSERT INTO "TFUSER11"."PUBLISHER" VALUES ('8', 'PROTHOM ALO', '+88 02 8180078-81', NULL, NULL, NULL, NULL);
INSERT INTO "TFUSER11"."PUBLISHER" VALUES ('1', 'Rokomari', '01519521971', NULL, NULL, NULL, NULL);
INSERT INTO "TFUSER11"."PUBLISHER" VALUES ('2', 'Anyaprokash', '02-57164124', NULL, NULL, NULL, NULL);
INSERT INTO "TFUSER11"."PUBLISHER" VALUES ('13', 'Batighar', '123455', 'dfds', 'Dhaka', 'dfvsv', 'Bangladesh');
INSERT INTO "TFUSER11"."PUBLISHER" VALUES ('14', 'test', '+8801671430830', 'House-26, Road-13/A, Dhanmondi, Dhaka-1209', 'Bangladesh', '1209', 'Bangladesh');

-- ----------------------------
-- Table structure for RENTAL_HISTORY
-- ----------------------------
DROP TABLE "TFUSER11"."RENTAL_HISTORY";
CREATE TABLE "TFUSER11"."RENTAL_HISTORY" (
  "RENTAL_HISTORY_ID" NUMBER VISIBLE NOT NULL,
  "ISSUE_DATE" DATE VISIBLE NOT NULL,
  "RENTAL_STATUS" NUMBER(1,0) VISIBLE DEFAULT 1,
  "USER_ID" NUMBER VISIBLE NOT NULL,
  "BOOK_COPY_ID" NUMBER VISIBLE,
  "RETURN_DATE" DATE VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of RENTAL_HISTORY
-- ----------------------------
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('61', TO_DATE('2022-02-22 18:58:44', 'SYYYY-MM-DD HH24:MI:SS'), '4', '19', '209', TO_DATE('2022-02-22 22:56:07', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('80', TO_DATE('2022-02-24 12:36:02', 'SYYYY-MM-DD HH24:MI:SS'), '1', '17', '210', NULL);
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('68', TO_DATE('2022-02-23 00:32:50', 'SYYYY-MM-DD HH24:MI:SS'), '1', '25', '244', NULL);
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('69', TO_DATE('2022-02-23 00:33:15', 'SYYYY-MM-DD HH24:MI:SS'), '1', '25', '245', NULL);
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('77', TO_DATE('2022-02-23 10:41:27', 'SYYYY-MM-DD HH24:MI:SS'), '4', '17', '357', TO_DATE('2022-02-24 13:00:25', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('79', TO_DATE('2022-02-23 12:26:24', 'SYYYY-MM-DD HH24:MI:SS'), '1', '20', '209', NULL);
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('64', TO_DATE('2022-02-22 22:58:45', 'SYYYY-MM-DD HH24:MI:SS'), '4', '17', '209', TO_DATE('2022-02-22 23:03:41', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('70', TO_DATE('2022-02-23 03:23:00', 'SYYYY-MM-DD HH24:MI:SS'), '2', '20', '404', NULL);
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('71', TO_DATE('2022-02-01 03:23:50', 'SYYYY-MM-DD HH24:MI:SS'), '3', '20', '398', NULL);
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('72', TO_DATE('2022-02-01 03:24:11', 'SYYYY-MM-DD HH24:MI:SS'), '2', '21', '399', NULL);
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('73', TO_DATE('2022-01-08 03:24:42', 'SYYYY-MM-DD HH24:MI:SS'), '2', '25', '400', NULL);
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('75', TO_DATE('2022-01-08 03:25:33', 'SYYYY-MM-DD HH24:MI:SS'), '2', '25', '356', NULL);
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('74', TO_DATE('2022-01-08 03:24:56', 'SYYYY-MM-DD HH24:MI:SS'), '2', '25', '405', NULL);
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('82', TO_DATE('2022-02-24 13:33:21', 'SYYYY-MM-DD HH24:MI:SS'), '1', '17', '425', NULL);
INSERT INTO "TFUSER11"."RENTAL_HISTORY" VALUES ('81', TO_DATE('2022-02-24 13:33:09', 'SYYYY-MM-DD HH24:MI:SS'), '1', '20', '424', NULL);

-- ----------------------------
-- Table structure for SYSTEM_REGISTER
-- ----------------------------
DROP TABLE "TFUSER11"."SYSTEM_REGISTER";
CREATE TABLE "TFUSER11"."SYSTEM_REGISTER" (
  "SY_REGISTER_ID" NUMBER VISIBLE NOT NULL,
  "SY_REGISTER_DESCRIPTION" VARCHAR2(45 BYTE) VISIBLE,
  "SY_REGISTER_NEXTVAL" NUMBER VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of SYSTEM_REGISTER
-- ----------------------------
INSERT INTO "TFUSER11"."SYSTEM_REGISTER" VALUES ('3', 'GENRE_TABLE', '24');
INSERT INTO "TFUSER11"."SYSTEM_REGISTER" VALUES ('4', 'BOOKS_TABLE', '33');
INSERT INTO "TFUSER11"."SYSTEM_REGISTER" VALUES ('5', 'PUBLISHER_TABLE', '18');
INSERT INTO "TFUSER11"."SYSTEM_REGISTER" VALUES ('6', 'MAGAZINES_TABLE', '7');
INSERT INTO "TFUSER11"."SYSTEM_REGISTER" VALUES ('7', 'RENTAL_HISTORY_TABLE', '83');
INSERT INTO "TFUSER11"."SYSTEM_REGISTER" VALUES ('8', 'FINE_HISTORY_TABLE', '19');
INSERT INTO "TFUSER11"."SYSTEM_REGISTER" VALUES ('9', 'BOOK_COPY_TABLE', '434');
INSERT INTO "TFUSER11"."SYSTEM_REGISTER" VALUES ('1', 'USERS_TABLE', '29');
INSERT INTO "TFUSER11"."SYSTEM_REGISTER" VALUES ('2', 'AUTHORS_TABLE', '20');

-- ----------------------------
-- Table structure for USERS
-- ----------------------------
DROP TABLE "TFUSER11"."USERS";
CREATE TABLE "TFUSER11"."USERS" (
  "USER_ID" NUMBER VISIBLE NOT NULL,
  "USER_NAME" VARCHAR2(45 BYTE) VISIBLE NOT NULL,
  "EMAIL" VARCHAR2(45 BYTE) VISIBLE NOT NULL,
  "PASSWORD_KEY" VARCHAR2(100 BYTE) VISIBLE NOT NULL,
  "MOBILE" VARCHAR2(45 BYTE) VISIBLE,
  "GENDER" VARCHAR2(45 BYTE) VISIBLE,
  "USER_TYPE_ID" NUMBER VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of USERS
-- ----------------------------
INSERT INTO "TFUSER11"."USERS" VALUES ('17', 'Anup', 'anupbhowmik.1998@gmail.com', '$2b$05$egeK4O0UWBBVYaR/LhvKE.c2VE1KWXPhF.vCOSzs0RQTPtWgpxBGu', '1234', 'Male', '1');
INSERT INTO "TFUSER11"."USERS" VALUES ('15', 'Harold Finch', 'haroldfinch@gmail.com', '$2b$05$AXcHAw7BtIWaAw.ARQBw3esnkhGFiifTsntBXZxIHscLUBxJUwgGu', '+880900021', 'Male', '2');
INSERT INTO "TFUSER11"."USERS" VALUES ('19', 'Pam Beasley', 'pam@gmail.com', '$2b$05$d7cQ3qgAEbPpeMF3EULoJe1u3ebHEetQ.omIpDg6iCN7RfDX1GiJG', '+9801111237878', 'Female', '1');
INSERT INTO "TFUSER11"."USERS" VALUES ('27', 'Bernadette Rostankowski', 'bernie@gmail.com', '$2b$05$0.rWFFwdrVWkaRn.BWRLv.F8n1yKKiaEeRV1mqg1.yKcE8b9TtxFm', '745294153', 'Female', '2');
INSERT INTO "TFUSER11"."USERS" VALUES ('5', 'Sherlock Holmes', 'holmes@gmail.com', '$2b$05$bwbYpWGVd71/b0lEvlBR.eYGNPkEjX80W1guwRSq2iCBzkY5k2AUG', '+8801789', 'Male', '2');
INSERT INTO "TFUSER11"."USERS" VALUES ('21', 'Ross Geller', 'ross@gmail.com', '$2b$05$uA76B2R6BythTMIw3ux3nORva4wS5coTWXBPVgLT0b4U4hgh9vFHa', '+980234679788', 'Male', '1');
INSERT INTO "TFUSER11"."USERS" VALUES ('20', 'Monica', 'monica@gmail.com', '$2b$05$C0KivsjePtS9CcLRuTC5Lul99UoSiSg8eME5tuo3Q2HkmjOaVeovK', '+980234523788', 'Female', '1');
INSERT INTO "TFUSER11"."USERS" VALUES ('25', 'Iftekhar E Mahbub Zeeon', 'mahbubzeeon@gmail.com', '$2b$05$m2DRTCIS4nF.s8hiWf0WT.KFm8KI8aFTajF.6xQgNv9TkKRj2y4mm', '01947429553', 'Male', '1');
INSERT INTO "TFUSER11"."USERS" VALUES ('26', 'Howard Wolowitz', 'howard@gmail.com', '$2b$05$g5gtkRVlna9PlHZETUTK7OwFI571WzWattIa8.l4f7Y.amCo5a9aW', '745295651', 'Male', '2');
INSERT INTO "TFUSER11"."USERS" VALUES ('12', 'Mr. Jim Halpert', 'jimhalpert@gmail.com', '$2b$05$lK2jGi0aAumzLwbcb.99MOtSuNXxKMtScOHTaxjfOcVRKKGxVcjzi', '+8801913375180', 'Male', '1');
INSERT INTO "TFUSER11"."USERS" VALUES ('3', 'Robert Langdon', 'admin@gmail.com', '$2b$05$0BrM7lRNXwKPn8N/evWpxuk14MOGmI4x1QlbqmovuJ191HekMMeQW', '0188888888', 'MALE', '3');
INSERT INTO "TFUSER11"."USERS" VALUES ('16', 'John Reese', 'reese@gmail.com', '$2b$05$uA7Ld4/y4QBcUDff3bnhF.swdb6IG99A9jd8AVKS0sEFN9SLcl182', '01671430830', 'Male', '2');
INSERT INTO "TFUSER11"."USERS" VALUES ('22', 'Pheobe Buffay', 'pheobe@gmail.com', '$2b$05$jUuz3lcu3Swz7.1JyKLno.1F7AijNRFeL/Q.CPenfxswxUbQK1v2q', '+88014523698721', 'Female', '2');
INSERT INTO "TFUSER11"."USERS" VALUES ('23', 'Leonard Hofstadter', 'leonard@gmail.com', '$2b$05$Hzfat/hOEB.tLnVFdI5GiugYXoB2mknDd/8gzMzekDkEzSV.F8PCm', '01869055338', 'Male', '2');
INSERT INTO "TFUSER11"."USERS" VALUES ('24', 'Rajesh Koothrappali', 'raj@gmail.com', '$2b$05$KGmpARBxD7CgWV7.t6Ta3e1Hq369cKYfv4xTNCBbvQXHDYX2t9Fau', '+8801478532631', 'Male', '2');
INSERT INTO "TFUSER11"."USERS" VALUES ('28', 'Test Employee', 'empl2@gmail.com', '$2b$05$t5ZsvA1IBORJipCZNHWGGuccIx3L2KLtLouPLCkf8NHJCukt/s5t6', '1234', 'Male', '2');

-- ----------------------------
-- Table structure for USER_EMPLOYEE
-- ----------------------------
DROP TABLE "TFUSER11"."USER_EMPLOYEE";
CREATE TABLE "TFUSER11"."USER_EMPLOYEE" (
  "USER_ID" NUMBER VISIBLE NOT NULL,
  "JOIN_DATE" VARCHAR2(45 BYTE) VISIBLE,
  "END_DATE" VARCHAR2(45 BYTE) VISIBLE,
  "JOB_ID" NUMBER VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of USER_EMPLOYEE
-- ----------------------------
INSERT INTO "TFUSER11"."USER_EMPLOYEE" VALUES ('15', '21-FEB-22 01.20.36.926000000 AM', NULL, '1');
INSERT INTO "TFUSER11"."USER_EMPLOYEE" VALUES ('27', '23-FEB-22 03.09.51.920000000 AM', NULL, '4');
INSERT INTO "TFUSER11"."USER_EMPLOYEE" VALUES ('5', '10-FEB-22 08.51.38.640000000 PM', NULL, '3');
INSERT INTO "TFUSER11"."USER_EMPLOYEE" VALUES ('26', '23-FEB-22 03.08.13.932000000 AM', NULL, '3');
INSERT INTO "TFUSER11"."USER_EMPLOYEE" VALUES ('23', '22-FEB-22 06.55.28.565000000 PM', NULL, '5');
INSERT INTO "TFUSER11"."USER_EMPLOYEE" VALUES ('16', '21-FEB-22 03.18.27.606000000 AM', NULL, '4');
INSERT INTO "TFUSER11"."USER_EMPLOYEE" VALUES ('22', '22-FEB-22 06.54.09.876000000 PM', NULL, '2');
INSERT INTO "TFUSER11"."USER_EMPLOYEE" VALUES ('24', '22-FEB-22 06.56.29.157000000 PM', NULL, '6');
INSERT INTO "TFUSER11"."USER_EMPLOYEE" VALUES ('28', '24-FEB-22 01.37.02.391000000 PM', NULL, '2');

-- ----------------------------
-- Table structure for USER_READERS
-- ----------------------------
DROP TABLE "TFUSER11"."USER_READERS";
CREATE TABLE "TFUSER11"."USER_READERS" (
  "USER_ID" NUMBER VISIBLE NOT NULL,
  "LIBRARY_CARD_NUMBER" VARCHAR2(100 BYTE) VISIBLE NOT NULL,
  "MEMBERSHIP_TAKEN_DATE" VARCHAR2(45 BYTE) VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of USER_READERS
-- ----------------------------
INSERT INTO "TFUSER11"."USER_READERS" VALUES ('17', 'e9006c2c-77df-4f77-a628-54720cf47672', '21-FEB-22 12.03.42.107000000 PM');
INSERT INTO "TFUSER11"."USER_READERS" VALUES ('19', '2f635e52-1f4f-4ee6-878d-a7c33af77e62', '22-FEB-22 06.50.06.567000000 PM');
INSERT INTO "TFUSER11"."USER_READERS" VALUES ('20', 'bf1bd184-79db-44de-b41b-670109df261f', '22-FEB-22 06.51.05.591000000 PM');
INSERT INTO "TFUSER11"."USER_READERS" VALUES ('21', '3254ef03-a65f-4c3c-affa-75229aafd128', '22-FEB-22 06.53.08.334000000 PM');
INSERT INTO "TFUSER11"."USER_READERS" VALUES ('25', '50e0f2cb-c669-4b09-ace8-9f1c9422508a', '22-FEB-22 10.42.26.306000000 PM');
INSERT INTO "TFUSER11"."USER_READERS" VALUES ('12', 'b31e29f7-5d5c-4a5b-8cff-5abd97891d6e', '16-FEB-22 10.13.11.447000000 PM');

-- ----------------------------
-- Table structure for USER_TYPE
-- ----------------------------
DROP TABLE "TFUSER11"."USER_TYPE";
CREATE TABLE "TFUSER11"."USER_TYPE" (
  "USER_TYPE_ID" NUMBER VISIBLE NOT NULL,
  "USER_TYPE_NAME" VARCHAR2(45 BYTE) VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of USER_TYPE
-- ----------------------------
INSERT INTO "TFUSER11"."USER_TYPE" VALUES ('1', 'READERS');
INSERT INTO "TFUSER11"."USER_TYPE" VALUES ('2', 'EMPLOYEES');
INSERT INTO "TFUSER11"."USER_TYPE" VALUES ('3', 'ADMINS');

-- ----------------------------
-- Primary Key structure for table AUTHOR
-- ----------------------------
ALTER TABLE "TFUSER11"."AUTHOR" ADD CONSTRAINT "SYS_C0017731" PRIMARY KEY ("AUTHOR_ID");

-- ----------------------------
-- Checks structure for table AUTHOR
-- ----------------------------
ALTER TABLE "TFUSER11"."AUTHOR" ADD CONSTRAINT "CHK_DATES" CHECK (DATE_OF_BIRTH < DATE_OF_DEATH) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."AUTHOR" ADD CONSTRAINT "SYS_C0017730" CHECK ("AUTHOR_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."AUTHOR" ADD CONSTRAINT "SYS_C0025746" CHECK ("AUTHOR_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table BOOKS
-- ----------------------------
ALTER TABLE "TFUSER11"."BOOKS" ADD CONSTRAINT "SYS_C0017735" PRIMARY KEY ("BOOK_ID");

-- ----------------------------
-- Uniques structure for table BOOKS
-- ----------------------------
ALTER TABLE "TFUSER11"."BOOKS" ADD CONSTRAINT "ISBN" UNIQUE ("ISBN") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table BOOKS
-- ----------------------------
ALTER TABLE "TFUSER11"."BOOKS" ADD CONSTRAINT "SYS_C0017734" CHECK ("BOOK_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."BOOKS" ADD CONSTRAINT "SYS_C0018890" CHECK ("PUBLISHER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."BOOKS" ADD CONSTRAINT "SYS_C0018891" CHECK ("ISBN" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."BOOKS" ADD CONSTRAINT "SYS_C0025606" CHECK ("BOOK_TITLE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table BOOKS
-- ----------------------------
CREATE TRIGGER "TFUSER11"."BOOK_DELETION" BEFORE DELETE ON "TFUSER11"."BOOKS" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE
B_ID NUMBER;
BEGIN
B_ID := :OLD.BOOK_ID;
DELETE FROM BOOKS_AUTHORS WHERE BOOK_ID = B_ID;
DELETE FROM BOOKS_GENRE WHERE BOOK_ID = B_ID;
DELETE FROM BOOK_COPY WHERE BOOK_ID = B_ID;
END;
/

-- ----------------------------
-- Primary Key structure for table BOOK_COPY
-- ----------------------------
ALTER TABLE "TFUSER11"."BOOK_COPY" ADD CONSTRAINT "SYS_C0021553" PRIMARY KEY ("BOOK_COPY_ID");

-- ----------------------------
-- Checks structure for table BOOK_COPY
-- ----------------------------
ALTER TABLE "TFUSER11"."BOOK_COPY" ADD CONSTRAINT "SYS_C0021552" CHECK ("BOOK_COPY_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."BOOK_COPY" ADD CONSTRAINT "SYS_C0025700" CHECK ("EDITION" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table BOOK_COPY
-- ----------------------------
CREATE TRIGGER "TFUSER11"."BOOK_COPY_INSERTION" AFTER INSERT ON "TFUSER11"."BOOK_COPY" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE
B_ID NUMBER;
AV_COP NUMBER;
BEGIN
B_ID := :NEW.BOOK_ID;
SELECT AVAILABLE_COPIES INTO AV_COP FROM BOOKS WHERE BOOK_ID = B_ID;
UPDATE BOOKS SET AVAILABLE_COPIES = (AV_COP + 1) WHERE BOOK_ID = B_ID;
END;
/

-- ----------------------------
-- Primary Key structure for table FINE_HISTORY
-- ----------------------------
ALTER TABLE "TFUSER11"."FINE_HISTORY" ADD CONSTRAINT "SYS_C0017776" PRIMARY KEY ("FINE_HISTORY_ID");

-- ----------------------------
-- Checks structure for table FINE_HISTORY
-- ----------------------------
ALTER TABLE "TFUSER11"."FINE_HISTORY" ADD CONSTRAINT "SYS_C0017774" CHECK ("FINE_HISTORY_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."FINE_HISTORY" ADD CONSTRAINT "SYS_C0017775" CHECK ("USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table GENRE
-- ----------------------------
ALTER TABLE "TFUSER11"."GENRE" ADD CONSTRAINT "SYS_C0017722" PRIMARY KEY ("GENRE_ID");

-- ----------------------------
-- Uniques structure for table GENRE
-- ----------------------------
ALTER TABLE "TFUSER11"."GENRE" ADD CONSTRAINT "SYS_C0025749" UNIQUE ("GENRE_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table GENRE
-- ----------------------------
ALTER TABLE "TFUSER11"."GENRE" ADD CONSTRAINT "SYS_C0017720" CHECK ("GENRE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."GENRE" ADD CONSTRAINT "SYS_C0017721" CHECK ("GENRE_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table JOBS
-- ----------------------------
ALTER TABLE "TFUSER11"."JOBS" ADD CONSTRAINT "SYS_C0017766" PRIMARY KEY ("JOB_ID");

-- ----------------------------
-- Checks structure for table JOBS
-- ----------------------------
ALTER TABLE "TFUSER11"."JOBS" ADD CONSTRAINT "SYS_C0017764" CHECK ("JOB_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."JOBS" ADD CONSTRAINT "SYS_C0017765" CHECK ("JOB_TITLE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table MAGAZINES
-- ----------------------------
ALTER TABLE "TFUSER11"."MAGAZINES" ADD CONSTRAINT "SYS_C0017747" PRIMARY KEY ("MAGAZINE_ID");

-- ----------------------------
-- Checks structure for table MAGAZINES
-- ----------------------------
ALTER TABLE "TFUSER11"."MAGAZINES" ADD CONSTRAINT "SYS_C0017745" CHECK ("MAGAZINE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."MAGAZINES" ADD CONSTRAINT "SYS_C0017746" CHECK ("MAGAZINE_TITLE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table MAGAZINES
-- ----------------------------
CREATE TRIGGER "TFUSER11"."MAGAZINE_DELETION" BEFORE DELETE ON "TFUSER11"."MAGAZINES" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE
M_ID NUMBER;
BEGIN
M_ID := :OLD.MAGAZINE_ID;
DELETE FROM MAGAZINES_GENRE WHERE MAGAZINE_ID = M_ID;
END;
/

-- ----------------------------
-- Primary Key structure for table PUBLISHER
-- ----------------------------
ALTER TABLE "TFUSER11"."PUBLISHER" ADD CONSTRAINT "SYS_C0017733" PRIMARY KEY ("PUBLISHER_ID");

-- ----------------------------
-- Checks structure for table PUBLISHER
-- ----------------------------
ALTER TABLE "TFUSER11"."PUBLISHER" ADD CONSTRAINT "SYS_C0017732" CHECK ("PUBLISHER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."PUBLISHER" ADD CONSTRAINT "SYS_C0025747" CHECK ("PUBLISHER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."PUBLISHER" ADD CONSTRAINT "SYS_C0025748" CHECK ("PHONE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table RENTAL_HISTORY
-- ----------------------------
ALTER TABLE "TFUSER11"."RENTAL_HISTORY" ADD CONSTRAINT "SYS_C0017772" PRIMARY KEY ("RENTAL_HISTORY_ID");

-- ----------------------------
-- Checks structure for table RENTAL_HISTORY
-- ----------------------------
ALTER TABLE "TFUSER11"."RENTAL_HISTORY" ADD CONSTRAINT "SYS_C0017769" CHECK ("RENTAL_HISTORY_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."RENTAL_HISTORY" ADD CONSTRAINT "SYS_C0017770" CHECK ("ISSUE_DATE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."RENTAL_HISTORY" ADD CONSTRAINT "SYS_C0017771" CHECK ("USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table RENTAL_HISTORY
-- ----------------------------
CREATE TRIGGER "TFUSER11"."BOOK_COPY_DECREMENT" AFTER INSERT ON "TFUSER11"."RENTAL_HISTORY" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE
B_ID NUMBER;
C_ID NUMBER;
AV_COP NUMBER;
BEGIN
C_ID := :NEW.BOOK_COPY_ID;
SELECT BOOK_ID INTO B_ID FROM BOOK_COPY WHERE BOOK_COPY_ID = C_ID;
UPDATE BOOK_COPY SET STATUS = 0 WHERE BOOK_COPY_ID = C_ID;
SELECT AVAILABLE_COPIES INTO AV_COP FROM BOOKS WHERE BOOK_ID = B_ID;
UPDATE BOOKS SET AVAILABLE_COPIES = (AV_COP - 1) WHERE BOOK_ID = B_ID;
END;
/
CREATE TRIGGER "TFUSER11"."BOOK_COPY_INCREMENT" AFTER UPDATE OF "RETURN_DATE" ON "TFUSER11"."RENTAL_HISTORY" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE
B_ID NUMBER;
C_ID NUMBER;
AV_COP NUMBER;
BEGIN
C_ID := :OLD.BOOK_COPY_ID;
SELECT BOOK_ID INTO B_ID FROM BOOK_COPY WHERE BOOK_COPY_ID = C_ID;
UPDATE BOOK_COPY SET STATUS = 1 WHERE BOOK_COPY_ID = C_ID;
SELECT AVAILABLE_COPIES INTO AV_COP FROM BOOKS WHERE BOOK_ID = B_ID;
UPDATE BOOKS SET AVAILABLE_COPIES = (AV_COP + 1) WHERE BOOK_ID = B_ID;
END;
/

-- ----------------------------
-- Primary Key structure for table SYSTEM_REGISTER
-- ----------------------------
ALTER TABLE "TFUSER11"."SYSTEM_REGISTER" ADD CONSTRAINT "SYS_C0017779" PRIMARY KEY ("SY_REGISTER_ID");

-- ----------------------------
-- Checks structure for table SYSTEM_REGISTER
-- ----------------------------
ALTER TABLE "TFUSER11"."SYSTEM_REGISTER" ADD CONSTRAINT "SYS_C0017778" CHECK ("SY_REGISTER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table USERS
-- ----------------------------
ALTER TABLE "TFUSER11"."USERS" ADD CONSTRAINT "SYS_C0017759" PRIMARY KEY ("USER_ID");

-- ----------------------------
-- Checks structure for table USERS
-- ----------------------------
ALTER TABLE "TFUSER11"."USERS" ADD CONSTRAINT "SYS_C0017754" CHECK ("USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."USERS" ADD CONSTRAINT "SYS_C0017755" CHECK ("USER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."USERS" ADD CONSTRAINT "SYS_C0017756" CHECK ("EMAIL" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."USERS" ADD CONSTRAINT "SYS_C0017757" CHECK ("PASSWORD_KEY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."USERS" ADD CONSTRAINT "SYS_C0017758" CHECK ("USER_TYPE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table USERS
-- ----------------------------
CREATE TRIGGER "TFUSER11"."USER_DELETION" BEFORE DELETE ON "TFUSER11"."USERS" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE
U_ID NUMBER;
UT NUMBER;
BEGIN
U_ID := :OLD.USER_ID;
UT := :OLD.USER_TYPE_ID;
IF UT = 1 THEN
DELETE FROM USER_READERS WHERE USER_ID = U_ID;
DELETE FROM FINE_HISTORY WHERE USER_ID = U_ID;
DELETE FROM RENTAL_HISTORY WHERE USER_ID = U_ID;
ELSIF UT = 2 THEN
DELETE FROM USER_EMPLOYEE WHERE USER_ID = U_ID;
END IF;
END;
/

-- ----------------------------
-- Checks structure for table USER_EMPLOYEE
-- ----------------------------
ALTER TABLE "TFUSER11"."USER_EMPLOYEE" ADD CONSTRAINT "SYS_C0017767" CHECK ("USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table USER_READERS
-- ----------------------------
ALTER TABLE "TFUSER11"."USER_READERS" ADD CONSTRAINT "SYS_C0017761" CHECK ("USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."USER_READERS" ADD CONSTRAINT "SYS_C0017762" CHECK ("LIBRARY_CARD_NUMBER" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table USER_TYPE
-- ----------------------------
ALTER TABLE "TFUSER11"."USER_TYPE" ADD CONSTRAINT "SYS_C0017753" PRIMARY KEY ("USER_TYPE_ID");

-- ----------------------------
-- Checks structure for table USER_TYPE
-- ----------------------------
ALTER TABLE "TFUSER11"."USER_TYPE" ADD CONSTRAINT "SYS_C0017751" CHECK ("USER_TYPE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."USER_TYPE" ADD CONSTRAINT "SYS_C0017752" CHECK ("USER_TYPE_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table BOOKS
-- ----------------------------
ALTER TABLE "TFUSER11"."BOOKS" ADD CONSTRAINT "FK_PUBLISHER_ID_BOOK" FOREIGN KEY ("PUBLISHER_ID") REFERENCES "TFUSER11"."PUBLISHER" ("PUBLISHER_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table BOOKS_AUTHORS
-- ----------------------------
ALTER TABLE "TFUSER11"."BOOKS_AUTHORS" ADD CONSTRAINT "FK_AUTHOR_ID_BOOKAUTHOR" FOREIGN KEY ("AUTHOR_ID") REFERENCES "TFUSER11"."AUTHOR" ("AUTHOR_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."BOOKS_AUTHORS" ADD CONSTRAINT "FK_BOOK_ID_BOOKAUTHOR" FOREIGN KEY ("BOOK_ID") REFERENCES "TFUSER11"."BOOKS" ("BOOK_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table BOOKS_GENRE
-- ----------------------------
ALTER TABLE "TFUSER11"."BOOKS_GENRE" ADD CONSTRAINT "FK_BOOK_ID_BOOKGENRE" FOREIGN KEY ("BOOK_ID") REFERENCES "TFUSER11"."BOOKS" ("BOOK_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."BOOKS_GENRE" ADD CONSTRAINT "FK_GENRE_ID_BOOKGENRE" FOREIGN KEY ("GENRE_ID") REFERENCES "TFUSER11"."GENRE" ("GENRE_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table BOOK_COPY
-- ----------------------------
ALTER TABLE "TFUSER11"."BOOK_COPY" ADD CONSTRAINT "FK_BOOK_ID_BOOKCOPY" FOREIGN KEY ("BOOK_ID") REFERENCES "TFUSER11"."BOOKS" ("BOOK_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table FINE_HISTORY
-- ----------------------------
ALTER TABLE "TFUSER11"."FINE_HISTORY" ADD CONSTRAINT "FK_RENTAL_HISTORY_ID" FOREIGN KEY ("RENTAL_HISTORY_ID") REFERENCES "TFUSER11"."RENTAL_HISTORY" ("RENTAL_HISTORY_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table MAGAZINES
-- ----------------------------
ALTER TABLE "TFUSER11"."MAGAZINES" ADD CONSTRAINT "FK_PUBLISHER_ID_MAGAZINES" FOREIGN KEY ("PUBLISHER_ID") REFERENCES "TFUSER11"."PUBLISHER" ("PUBLISHER_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table MAGAZINES_GENRE
-- ----------------------------
ALTER TABLE "TFUSER11"."MAGAZINES_GENRE" ADD CONSTRAINT "FK_GENRE_ID_MAGAZINESGENRE" FOREIGN KEY ("GENRE_ID") REFERENCES "TFUSER11"."GENRE" ("GENRE_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "TFUSER11"."MAGAZINES_GENRE" ADD CONSTRAINT "FK_MAGAZINE_ID_MAGAZINESGENRE" FOREIGN KEY ("MAGAZINE_ID") REFERENCES "TFUSER11"."MAGAZINES" ("MAGAZINE_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table RENTAL_HISTORY
-- ----------------------------
ALTER TABLE "TFUSER11"."RENTAL_HISTORY" ADD CONSTRAINT "FK_USER_ID_RENTALHISTORY" FOREIGN KEY ("USER_ID") REFERENCES "TFUSER11"."USERS" ("USER_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table USERS
-- ----------------------------
ALTER TABLE "TFUSER11"."USERS" ADD CONSTRAINT "FK_USER_TYPE_ID_USERS" FOREIGN KEY ("USER_TYPE_ID") REFERENCES "TFUSER11"."USER_TYPE" ("USER_TYPE_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table USER_EMPLOYEE
-- ----------------------------
ALTER TABLE "TFUSER11"."USER_EMPLOYEE" ADD CONSTRAINT "FK_JOB_ID_USEREMPLOYEE" FOREIGN KEY ("JOB_ID") REFERENCES "TFUSER11"."JOBS" ("JOB_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table USER_READERS
-- ----------------------------
ALTER TABLE "TFUSER11"."USER_READERS" ADD CONSTRAINT "FK_USER_ID_USERREADER" FOREIGN KEY ("USER_ID") REFERENCES "TFUSER11"."USERS" ("USER_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;