-- generated by: SchemaCrawler 17.3.0
-- generated on: 2026-01-11T21:40:51.3154154
-- database: HSQL Database Engine 2.7.4
-- driver: HSQL Database Engine Driver 2.7.4
-- operating system: Windows 11 10.0
-- JVM system: Microsoft OpenJDK 64-Bit Server VM 21.0.8+9-LTS


- PUBLIC.BOOKS.AUTHORS
 - ID
 - FIRSTNAME
 - LASTNAME
 - ADDRESS1
 - ADDRESS2
 - CITY
 - STATE
 - POSTALCODE
 - COUNTRY

- PUBLIC.BOOKS.BOOKS
 - ID
 - TITLE
 - DESCRIPTION
 - PUBLISHERID
 - PUBLICATIONDATE
 - PRICE
 - PREVIOUSEDITIONID

- PUBLIC.BOOKS."Celebrities"
 - Id
 - NAME

- PUBLIC.BOOKS.COUPONS
 - ID
 - DATA
 - COUPONS
 - BOOKS

- PUBLIC.BOOKS.CUSTOMERS
 - ID
 - FIRSTNAME
 - LASTNAME
 - AGE

- PUBLIC.BOOKS.PUBLISHERS
 - ID
 - PUBLISHER

- PUBLIC."PUBLISHER SALES".REGIONS
 - CITY
 - STATE
 - POSTALCODE
 - COUNTRY

- PUBLIC."PUBLISHER SALES".SALESDATA
 - SALESDATAID
 - YEARLYAMOUNT

- PUBLIC.BOOKS.BOOKAUTHORS
 - BOOKID
 - AUTHORID
 - SOMEDATA

- PUBLIC.BOOKS."Celebrity Updates"
 - Celebrity Id
 - UPDATE

- PUBLIC.BOOKS.CUSTOMERDATA
 - CUSTOMERID
 - DATAID
 - DATA

- PUBLIC.BOOKS.ΒΙΒΛΊΑ
 - ΜΟΝΑΔΙΚΌΣ
 - ΤΊΤΛΟΣ
 - ΠΕΡΙΓΡΑΦΉ
 - ΕΚΔΌΤΗΣ

- PUBLIC."PUBLISHER SALES".SALES
 - POSTALCODE
 - COUNTRY
 - BOOKID
 - COUPON_ID
 - PERIODENDDATE
 - TOTALAMOUNT
 - SALESDATAID

- PUBLIC.BOOKS.AUTHORSLIST
 - ID
 - FIRSTNAME
 - LASTNAME

