

System Information
========================================================================

generated by                              SchemaCrawler 16.23.1         
generated on                              2024-11-17 20:57:56           
database version                          HSQL Database Engine 2.7.4    
driver version                            HSQL Database Engine Driver 2.7.4



Tables
========================================================================



PUBLIC.BOOKS.AUTHORS                                             [table]
------------------------------------------------------------------------
Contact details for book authors



PUBLIC.BOOKS.AUTHORSLIST                                          [view]
------------------------------------------------------------------------



PUBLIC.BOOKS.BOOKAUTHORS                                         [table]
------------------------------------------------------------------------
Relationship between books and their authors, 
along with the latest updated information



PUBLIC.BOOKS.BOOKS                                               [table]
------------------------------------------------------------------------
Details for published books



PUBLIC.BOOKS."Celebrities"                                       [table]
------------------------------------------------------------------------



PUBLIC.BOOKS."Celebrity Updates"                                 [table]
------------------------------------------------------------------------



PUBLIC.BOOKS.COUPONS                                             [table]
------------------------------------------------------------------------



PUBLIC.BOOKS.CUSTOMERDATA                                        [table]
------------------------------------------------------------------------



PUBLIC.BOOKS.CUSTOMERS                                           [table]
------------------------------------------------------------------------



PUBLIC.BOOKS.PUBLISHERS                                          [table]
------------------------------------------------------------------------
List of book publishers



PUBLIC.BOOKS.ΒΙΒΛΊΑ                                              [table]
------------------------------------------------------------------------



PUBLIC.FOR_LINT.EXTRA_PK                                         [table]
------------------------------------------------------------------------
Extra table with just a primary key



PUBLIC.FOR_LINT."Global Counts"                                  [table]
------------------------------------------------------------------------



PUBLIC.FOR_LINT.PUBLICATIONS                                     [table]
------------------------------------------------------------------------



PUBLIC.FOR_LINT.PUBLICATIONWRITERS                               [table]
------------------------------------------------------------------------



PUBLIC.FOR_LINT.SELFREFERENCE                                    [table]
------------------------------------------------------------------------



PUBLIC.FOR_LINT.WRITERS                                          [table]
------------------------------------------------------------------------



PUBLIC."PUBLISHER SALES".REGIONS                                 [table]
------------------------------------------------------------------------



PUBLIC."PUBLISHER SALES".SALES                                   [table]
------------------------------------------------------------------------



PUBLIC."PUBLISHER SALES".SALESDATA                               [table]
------------------------------------------------------------------------



Routines
========================================================================



PUBLIC.BOOKS.NEW_PUBLISHER                        [procedure, no result]
------------------------------------------------------------------------



PUBLIC.BOOKS.NEW_PUBLISHER                        [procedure, no result]
------------------------------------------------------------------------



PUBLIC.BOOKS.CUSTOMADD               [function, does not return a table]
------------------------------------------------------------------------



PUBLIC.BOOKS.CUSTOMADD               [function, does not return a table]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.ALLOC_BLOCKS                   [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.ALLOC_SINGLE_BLOCK             [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.CONVERT_BLOCK                  [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.CREATE_EMPTY_BLOCK             [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.DELETE_BLOCKS                  [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.DELETE_LOB                     [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.DELETE_UNUSED                  [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.DELETE_UNUSED_LOBS             [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.DIVIDE_BLOCK                   [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.MERGE_EMPTY_BLOCKS             [procedure, no result]
------------------------------------------------------------------------

