# generated by SchemaCrawler 17.10.1
# generated on 2026-04-21 22:15:07
# database: HSQL Database Engine 2.7.4



# Contact details for book authors
"AUTHORS" as authors_f521e766
# PUBLIC.BOOKS.AUTHORS
------
  "ID" "INTEGER" PK
  "FIRSTNAME" "VARCHAR(20)" INDEX
  "LASTNAME" "VARCHAR(20)" INDEX
  "ADDRESS1" "VARCHAR(255)" NULLABLE
  "ADDRESS2" "VARCHAR(255)" NULLABLE
  "CITY" "VARCHAR(50)" INDEX NULLABLE
  "STATE" "CHARACTER(2)" INDEX NULLABLE
  "POSTALCODE" "VARCHAR(10)" INDEX NULLABLE
  "COUNTRY" "VARCHAR(50)"="'USA'" INDEX NULLABLE

# Details for published books
"BOOKS" as books_f4a675c8
# PUBLIC.BOOKS.BOOKS
------
  "ID" "INTEGER" PK   # Unique (internal) id for book
  "TITLE" "VARCHAR(255)"   # Book title
  "DESCRIPTION" "VARCHAR(255)" NULLABLE   # Book description (Usually the blurb from the book jacket or promotional materials)
  "PUBLISHERID" "INTEGER"   # Foreign key to the book publisher
  "PUBLICATIONDATE" "DATE" NULLABLE   # Book publication date
  "PRICE" "DOUBLE(64, 0)" NULLABLE   # Current price for the book
  "PREVIOUSEDITIONID" "INTEGER" UNIQUE NULLABLE FK 0- books_f4a675c8."ID"

"Celebrities" as celebrities_db1258df
# PUBLIC.BOOKS."Celebrities"
------
  "Id" "INTEGER" PK
  "NAME" "VARCHAR(20)" NULLABLE

"COUPONS" as coupons_54c3042b
# PUBLIC.BOOKS.COUPONS
------
  "ID" "INTEGER" PK
  "DATA" "CLOB" NULLABLE
  "COUPONS" "INTEGER ARRAY"="ARRAY[]" NULLABLE
  "BOOKS" "VARCHAR(20) ARRAY[10]" NULLABLE

"CUSTOMERS" as customers_f705d773
# PUBLIC.BOOKS.CUSTOMERS
------
  "ID" "INTEGER" PK
  "FIRSTNAME" "NAME_TYPE(100)"
  "LASTNAME" "NAME_TYPE(100)"
  "AGE" "AGE_TYPE" NULLABLE

# List of book publishers
"PUBLISHERS" as publishers_8037d535
# PUBLIC.BOOKS.PUBLISHERS
------
  "ID" "INTEGER" PK AUTOINCREMENT   # Unique (internal) id for book publisher
  "PUBLISHER" "VARCHAR(255)" NULLABLE   # Name of book publisher

# Relationship between books and their authors,  along with the latest updated information
"BOOKAUTHORS" as bookauthors_ead84c5d
# PUBLIC.BOOKS.BOOKAUTHORS
------
  "BOOKID" "INTEGER" UNIQUE FK >- books_f4a675c8."ID"
  "AUTHORID" "INTEGER" UNIQUE FK >- authors_f521e766."ID"
  "SOMEDATA" "VARCHAR(30)" NULLABLE

"Celebrity Updates" as celebrityupdates_f5088e8b
# PUBLIC.BOOKS."Celebrity Updates"
------
  "Celebrity Id" "INTEGER" PK FK - celebrities_db1258df."Id"
  "UPDATE" "VARCHAR(20)" NULLABLE

"CUSTOMERDATA" as customerdata_b0af83c6
# PUBLIC.BOOKS.CUSTOMERDATA
------
  "CUSTOMERID" "INTEGER" PK FK >- customers_f705d773."ID"
  "DATAID" "INTEGER" PK
  "DATA" "VALID_STRING(20)" NULLABLE

"ΒΙΒΛΊΑ" as βιβλία_3cecb755
# PUBLIC.BOOKS.ΒΙΒΛΊΑ
------
  "ΜΟΝΑΔΙΚΌΣ" "SMALLINT" PK
  "ΤΊΤΛΟΣ" "VARCHAR(255)"
  "ΠΕΡΙΓΡΑΦΉ" "VARCHAR(255)" NULLABLE
  "ΕΚΔΌΤΗΣ" "SMALLINT" INDEX FK >- publishers_8037d535."ID"

"AUTHORSLIST" as authorslist_9ccb3c04
# PUBLIC.BOOKS.AUTHORSLIST
------
  "ID" "INTEGER" NULLABLE
  "FIRSTNAME" "VARCHAR(20)" NULLABLE
  "LASTNAME" "VARCHAR(20)" NULLABLE



"REGIONS" as regions_dbf65bbf
# PUBLIC."PUBLISHER SALES".REGIONS
------
  "CITY" "VARCHAR(50)"
  "STATE" "VARCHAR(2)"
  "POSTALCODE" "VARCHAR(10)" PK
  "COUNTRY" "VARCHAR(50)" PK

"SALESDATA" as salesdata_1193fa76
# PUBLIC."PUBLISHER SALES".SALESDATA
------
  "SALESDATAID" "INTEGER" UNIQUE NULLABLE
  "YEARLYAMOUNT" "DOUBLE(64, 0)" NULLABLE

"SALES" as sales_751e68cc
# PUBLIC."PUBLISHER SALES".SALES
------
  "POSTALCODE" "VARCHAR(10)" INDEX FK >- regions_dbf65bbf."POSTALCODE"
  "COUNTRY" "VARCHAR(50)" INDEX FK >- regions_dbf65bbf."COUNTRY"
  "BOOKID" "INTEGER" INDEX NULLABLE FK >0- books_f4a675c8."ID"
  "COUPON_ID" "INTEGER" NULLABLE
  "PERIODENDDATE" "DATE" NULLABLE
  "TOTALAMOUNT" "DOUBLE(64, 0)" NULLABLE
  "SALESDATAID" "INTEGER" INDEX NULLABLE FK >0- salesdata_1193fa76."SALESDATAID"

