

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

generated by                              SchemaCrawler 16.14.4         
generated on                              2021-04-16 23:51:27.859       
database version                          HSQL Database Engine 2.6.0    
driver version                            HSQL Database Engine Driver 2.6.0



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.COUPONS                                             [table]
------------------------------------------------------------------------



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



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



PUBLIC.BOOKS."Global Counts"                                     [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]
------------------------------------------------------------------------

                                                         [specific name]
NEW_PUBLISHER_10160



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

                                                         [specific name]
NEW_PUBLISHER_FORCE_VALUE



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

                                                         [specific name]
CUSTOMADD_10161



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

                                                         [specific name]
CUSTOMADD_10162



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

                                                         [specific name]
ALLOC_BLOCKS_10070



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

                                                         [specific name]
ALLOC_SINGLE_BLOCK_10073



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

                                                         [specific name]
CONVERT_BLOCK_10028



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

                                                         [specific name]
CREATE_EMPTY_BLOCK_10062



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

                                                         [specific name]
DELETE_BLOCKS_10059



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

                                                         [specific name]
DELETE_LOB_10030



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

                                                         [specific name]
DELETE_UNUSED_10045



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

                                                         [specific name]
DELETE_UNUSED_LOBS_10057



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

                                                         [specific name]
DIVIDE_BLOCK_10065



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

                                                         [specific name]
MERGE_EMPTY_BLOCKS_10078



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


Database Information
-=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=-
database product name                     HSQL Database Engine          
database product version                  2.6.0                         
database user name                        SA                            


JDBC Driver Information
-=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=-
driver name                               HSQL Database Engine Driver   
driver version                            2.6.0                         
driver class name                         org.hsqldb.jdbc.JDBCDriver    
url                                       jdbc:hsqldb:hsql://0.0.0.0:58024/schemacrawler58024
is JDBC compliant                         true                          

