-- generated by: SchemaCrawler 15.05.01
-- generated on: 2019-01-28 20:19:47
-- database: HSQL Database Engine 2.4.1
-- driver: HSQL Database Engine Driver 2.4.1
-- operating system: Windows 10 10.0
-- JVM system: Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 1.8.0_191-b12


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

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

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

- PUBLIC.BOOKS.CUSTOMERDATA
 - ID
 - DATA

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

- PUBLIC.BOOKS."Global Counts"
 - Global Count
 - UPDATE

- 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.ΒΙΒΛΊΑ
 - ΜΟΝΑΔΙΚΌΣ
 - ΤΊΤΛΟΣ
 - ΠΕΡΙΓΡΑΦΉ
 - ΕΚΔΌΤΗΣ

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

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

