

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

generated by                              SchemaCrawler 16.23.1         
generated on                              2024-11-17 20:58:00           
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]
------------------------------------------------------------------------

                                                         [specific name]
NEW_PUBLISHER_10151



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_10152



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

                                                         [specific name]
CUSTOMADD_10153



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

                                                         [specific name]
ALLOC_BLOCKS_10071



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

                                                         [specific name]
ALLOC_SINGLE_BLOCK_10074



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

                                                         [specific name]
CONVERT_BLOCK_10029



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

                                                         [specific name]
CREATE_EMPTY_BLOCK_10063



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

                                                         [specific name]
DELETE_BLOCKS_10060



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

                                                         [specific name]
DELETE_LOB_10031



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

                                                         [specific name]
DELETE_UNUSED_10046



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

                                                         [specific name]
DELETE_UNUSED_LOBS_10058



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

                                                         [specific name]
DIVIDE_BLOCK_10066



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

                                                         [specific name]
MERGE_EMPTY_BLOCKS_10079



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


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


JDBC Driver Information
-=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=-
connection url                            jdbc:hsqldb:hsql://0.0.0.0:55551/schemacrawler55551
driver name                               HSQL Database Engine Driver   
driver version                            2.7.4                         
driver class name                         org.hsqldb.jdbc.JDBCDriver    
is JDBC compliant                         true                          
supported JDBC version                    4.2                           

