-- create tables create table ch19_category ( id number generated by default on null as identity constraint ch19_category_id_pk primary key, category_name varchar2(256 char) ) ; insert into ch19_category (id,category_name) values (1, 'Science fiction'); insert into ch19_category (id,category_name) values (2, 'Computer Science Textbook'); insert into ch19_category (id,category_name) values (3, 'Fairy Tails'); create table ch19_book_user ( id number generated by default on null as identity constraint ch19_book_user_id_pk primary key, profile_name varchar2(256 char), firstname varchar2(256 char), lastname varchar2(256 char) ) ; insert into ch19_book_user (id,profile_name, firstname, lastname) values (1, 'No. 1','John','Doe'); insert into ch19_book_user (id,profile_name, firstname, lastname) values (2, 'No. 2','Mary','Doe'); insert into ch19_book_user (id,profile_name, firstname, lastname) values (3, 'No. 3','Georg','Doe'); create table ch19_book_data ( id number generated by default on null as identity constraint ch19_book_data_id_pk primary key, title varchar2(256 char), authors varchar2(256 char), about varchar2(1024 char), publisher varchar2(256 char), publication_date date, rating_count number, category_id number constraint ch19_book_data_category_id_fk references ch19_category on delete cascade ) ; insert into ch19_book_data ( id, title, authors, about, publisher, publication_date, rating_count, category_id ) values ( 1, 'Ante Ipsumprimis ', 'Rhoncus Non Molestie', 'In faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis.', 'Ullamcorper', sysdate - 80, 80, 1 ); insert into ch19_book_data ( id, title, authors, about, publisher, publication_date, rating_count, category_id ) values ( 2, 'Suscipit', 'Proin Sit', 'Massa', 'Ullamcorper', sysdate - 9, 97, 1 ); insert into ch19_book_data ( id, title, authors, about, publisher, publication_date, rating_count, category_id ) values ( 3, 'Mattis', 'Nulla Placerat', 'Id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.', 'Ullamcorper', sysdate - 78, 9, 2 ); insert into ch19_book_data ( id, title, authors, about, publisher, publication_date, rating_count, category_id ) values ( 4, 'Mi venenatis nec', 'Sollicitudin Elementum', 'Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla.', 'In Faucibus', sysdate - 30, 71, 2 ); insert into ch19_book_data ( id, title, authors, about, publisher, publication_date, rating_count, category_id ) values ( 5, 'Mattis risus rhoncus', 'Cubilia Curae', 'Porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi.', 'Fames', sysdate - 23, 59, 2 ); insert into ch19_book_data ( id, title, authors, about, publisher, publication_date, rating_count, category_id ) values ( 6, 'Vestibulum lacinia arcu', 'Donec Convallis', 'Luctus et ultrices posuere cubilia Curae; Proin vulputate placerat.', 'Ultrices', sysdate - 88, 68, 3 ); insert into ch19_book_data ( id, title, authors, about, publisher, publication_date, rating_count, category_id ) values ( 7, 'Vulputate placerat pellentesque', 'Ac Volutpat', 'Id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac.', 'Ullamcorper', sysdate - 79, 53, 3 ); -- table index -- create index ch19_book_data_i1 on ch19_book_data (category_id); create table ch19_book_review ( id number generated by default on null as identity constraint ch19_book_review_id_pk primary key, review varchar2(1024 char), review_date date, review_score number constraint ch19_book_revie_review_scor_ck check (review_score in (1,2,3,4,5)), book_id number constraint ch19_book_review_book_id_fk references ch19_book_data on delete cascade, user_id number constraint ch19_book_review_user_id_fk references ch19_book_user on delete cascade ) ; insert into ch19_book_review ( id, review, review_date, review_score, book_id, user_id ) values ( 1, 'Luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur.', sysdate - 20, 1, '1', '1' ); insert into ch19_book_review ( id, review, review_date, review_score, book_id, user_id ) values ( 2, 'Risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus.', sysdate - 49, 2, '2', '2' ); insert into ch19_book_review ( id, review, review_date, review_score, book_id, user_id ) values ( 3, 'Faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur.', sysdate - 48, 3, '3', '3' ); insert into ch19_book_review ( id, review, review_date, review_score, book_id, user_id ) values ( 4, 'Iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum.', sysdate - 33, 4, '1', '1' ); insert into ch19_book_review ( id, review, review_date, review_score, book_id, user_id ) values ( 5, 'Placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin.', sysdate - 10, 5, '2', '2' ); insert into ch19_book_review ( id, review, review_date, review_score, book_id, user_id ) values ( 6, 'Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus.', sysdate - 42, 1, '3', '3' ); insert into ch19_book_review ( id, review, review_date, review_score, book_id, user_id ) values ( 7, 'Posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, quis posuere mi maximus vitae.', sysdate - 69, 2, '1', '1' ); insert into ch19_book_review ( id, review, review_date, review_score, book_id, user_id ) values ( 8, 'Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, quis posuere mi maximus vitae. Quisque tortor odio, feugiat eget sagittisvel, pretium ut metus.', sysdate - 64, 3, '2', '2' ); insert into ch19_book_review ( id, review, review_date, review_score, book_id, user_id ) values ( 9, 'Sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus.', sysdate - 55, 4, '3', '3' ); insert into ch19_book_review ( id, review, review_date, review_score, book_id, user_id ) values ( 10, 'Suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum.', sysdate - 87, 5, '1', '1' ); -- table index -- create index ch19_book_review_i1 on ch19_book_review (book_id); -- create index ch19_book_review_i112 on ch19_book_review (user_id); create table ch19_review_comment ( id number generated by default on null as identity constraint ch19_review_commen_id_pk primary key, rev_comment varchar2(1024 char), rev_comm_date date, rev_helpfulness varchar2(256 char), rev_comm_score number constraint ch19_review_c_rev_comm_scor_ck check (rev_comm_score in (1,2,3,4,5)), review_id number constraint ch19_review_commen_review_i_fk references ch19_book_review on delete cascade, user_id number constraint ch19_review_commen_user_id_fk references ch19_book_user on delete cascade ) ; insert into ch19_review_comment ( id, rev_comment, rev_comm_date, rev_helpfulness, rev_comm_score, review_id, user_id ) values ( 1, 'Arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique.', sysdate - 1, 'Id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus.', 1, '1', '1' ); insert into ch19_review_comment ( id, rev_comment, rev_comm_date, rev_helpfulness, rev_comm_score, review_id, user_id ) values ( 2, 'Fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, quis posuere mi maximus vitae. Quisque.', sysdate - 82, 'Cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum', 2, '2', '2' ); insert into ch19_review_comment ( id, rev_comment, rev_comm_date, rev_helpfulness, rev_comm_score, review_id, user_id ) values ( 3, 'Sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus.', sysdate - 23, 'Risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada.', 3, '3', '3' ); insert into ch19_review_comment ( id, rev_comment, rev_comm_date, rev_helpfulness, rev_comm_score, review_id, user_id ) values ( 4, 'Mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, quis posuere mi maximus vitae. Quisque tortor odio, feugiat eget sagittisvel, pretium ut metus. Duis et commodo arcu, in vestibulum tellus. In sollicitudin.', sysdate - 55, 'Sapien suscipit tristique ac.', 4, '4', '1' ); insert into ch19_review_comment ( id, rev_comment, rev_comm_date, rev_helpfulness, rev_comm_score, review_id, user_id ) values ( 5, 'Tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, quis posuere mi maximus vitae. Quisque tortor odio, feugiat eget sagittisvel, pretium ut metus. Duis et commodo arcu, in vestibulum tellus. In sollicitudin nisi mi, pharetra gravida.', sysdate - 26, 'Rhoncus.Cras vulputate porttitor ligula. Nam.', 5, '5', '2' ); insert into ch19_review_comment ( id, rev_comment, rev_comm_date, rev_helpfulness, rev_comm_score, review_id, user_id ) values ( 6, 'Ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra.', sysdate - 44, 'Massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidun', 1, '6', '3' ); insert into ch19_review_comment ( id, rev_comment, rev_comm_date, rev_helpfulness, rev_comm_score, review_id, user_id ) values ( 7, 'Semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada.', sysdate - 64, 'Luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur', 2, '7', '1' ); insert into ch19_review_comment ( id, rev_comment, rev_comm_date, rev_helpfulness, rev_comm_score, review_id, user_id ) values ( 8, 'Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, quis posuere mi maximus vitae. Quisque tortor odio, feugiat eget sagittisvel, pretium ut metus. Duis et commodo arcu, in vestibulum tellus. In sollicitudin nisi mi, pharetra gravida ex semper ut.Donec nibh sapien, hendrerit quis varius.', sysdate - 40, 'Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere', 3, '8', '2' ); insert into ch19_review_comment ( id, rev_comment, rev_comm_date, rev_helpfulness, rev_comm_score, review_id, user_id ) values ( 9, 'Eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, quis posuere mi maximus vitae. Quisque tortor odio, feugiat eget sagittisvel, pretium ut.', sysdate - 74, 'Mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, quis posuere mi maximus vitae. Quisque tortor odio, feugiat eget sagittisvel, pretium ut metus. Duis et commodo ', 4, '9', '3' ); insert into ch19_review_comment ( id, rev_comment, rev_comm_date, rev_helpfulness, rev_comm_score, review_id, user_id ) values ( 10, 'Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, quis posuere mi maximus.', sysdate - 67, 'Sollicitudin.', 5, '10', '1' ); -- table index -- create index ch19_review_commen_i1 on ch19_review_comment (review_id); -- create index ch19_review_commen_i162 on ch19_review_comment (user_id); -- load data -- Generated by Quick SQL Sunday February 26, 2023 11:46:29 /* ch19_category category_name vc256 ch19_book_user profile_name vc256 firstname vc256 lastname vc256 ch19_book_data title vc256 authors vc256 about vc1024 publisher vc256 publication_date date rating_count num category_id /fk ch19_category ch19_book_review review vc1024 review_date date review_score num /check 1,2,3,4,5 book_id /fk ch19_book_data user_id /fk ch19_book_user ch19_review_comment rev_comment vc1024 rev_comm_date date rev_helpfulness vc256 rev_comm_score num /check 1,2,3,4,5 review_id /fk ch19_book_review user_id /fk ch19_book_user # settings = { semantics: "CHAR", language: "EN", APEX: true } */