

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

generated by                              SchemaCrawler 16.23.1         
generated on                              2024-11-17 20:57:51           
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

Triggers

TRG_AUTHORS                                                    [trigger]
  after delete, per row
                                                      [action statement]
UPDATE BOOKS.PUBLISHERS SET PUBLISHER='Jacob'WHERE PUBLISHER='John'

Table Constraints

                                                      [check constraint]
  STATE                                                         

                                                      [check constraint]
  ID                                                            

                                                      [check constraint]
  FIRSTNAME                                                     

                                                      [check constraint]
  LASTNAME                                                      



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



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

Table Constraints

                                                      [check constraint]
  BOOKID                                                        

                                                      [check constraint]
  AUTHORID                                                      



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

Table Constraints

                                                     [unique constraint]
  PREVIOUSEDITIONID                                             

                                                      [check constraint]
  ID                                                            

                                                      [check constraint]
  TITLE                                                         

                                                      [check constraint]
  PUBLISHERID                                                   



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

Table Constraints

                                                      [check constraint]
  "Id"                                                          



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

Table Constraints

                                                      [check constraint]
  "Celebrity Id"                                                



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

Table Constraints

                                                      [check constraint]
  ID                                                            



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

Table Constraints

                                                      [check constraint]
  ID                                                            



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

Table Constraints

                                                      [check constraint]
  ID                                                            

                                                      [check constraint]
  FIRSTNAME                                                     

                                                      [check constraint]
  LASTNAME                                                      



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



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

Table Constraints

                                                      [check constraint]
  ΜΟΝΑΔΙΚΌΣ                                                     

                                                      [check constraint]
  ΤΊΤΛΟΣ                                                        

                                                      [check constraint]
  ΕΚΔΌΤΗΣ                                                       



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

Table Constraints

                                                      [check constraint]
  CITY                                                          

                                                      [check constraint]
  STATE                                                         

                                                      [check constraint]
  POSTALCODE                                                    

                                                      [check constraint]
  COUNTRY                                                       



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

Table Constraints

                                                      [check constraint]
  POSTALCODE                                                    

                                                      [check constraint]
  COUNTRY                                                       



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

Table Constraints

                                                     [unique constraint]
  SALESDATAID                                                   



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



PUBLIC.BOOKS.NEW_PUBLISHER                        [procedure, no result]
------------------------------------------------------------------------
  PUBLISHER                         CHARACTER VARYING, out      



PUBLIC.BOOKS.NEW_PUBLISHER                        [procedure, no result]
------------------------------------------------------------------------
  NEWPUBLISHER                      CHARACTER VARYING, in       
  PUBLISHER                         CHARACTER VARYING, out      



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



PUBLIC.BOOKS.CUSTOMADD               [function, does not return a table]
------------------------------------------------------------------------
  ONE                               INTEGER, in                 
  TWO                               INTEGER, in                 



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



PUBLIC.BOOKS.PUBLISHER_ID_SEQ                                 [sequence]
------------------------------------------------------------------------
  increment                         1                           
  start value                       1                           
  minimum value                     -2147483648                 
  maximum value                     2147483647                  
  cycle                             false                       

