

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

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



Sequences
========================================================================

PUBLIC.BOOKS.PUBLISHER_ID_SEQ                                 [sequence]
PUBLIC.SYSTEM_LOBS.LOB_ID                                     [sequence]



Synonyms
========================================================================

PUBLIC.BOOKS.PUBLICATIONS                                      [synonym]

