-- Testing UTF-8 characters: ¥ · £ · € · $ · ¢ · ₡ · ₢ · ₣ · ₤ · ₥ · ₦ · ₧ · ₨ · ₩ · ₪ · ₫ · ₭ · ₮ · ₯

-- generated by: SchemaCrawler 17.10.1
-- generated on: 2026-04-18T19:13:33.3591335
-- database: HSQL Database Engine 2.7.4
-- driver: HSQL Database Engine Driver 2.7.4
-- operating system: Windows 11 10.0
-- JVM system: Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 25.0.2+10-LTS-jvmci-b01


SET SCHEMA PUBLIC.BOOKS;

CREATE TABLE PUBLIC.BOOKS.AUTHORS
(
  ID INTEGER NOT NULL,
  FIRSTNAME VARCHAR NOT NULL,
  LASTNAME VARCHAR NOT NULL,
  ADDRESS1 VARCHAR,
  ADDRESS2 VARCHAR,
  CITY VARCHAR,
  STATE CHARACTER,
  POSTALCODE VARCHAR,
  COUNTRY VARCHAR
);

CREATE TABLE PUBLIC.BOOKS.BOOKS
(
  ID INTEGER NOT NULL,
  TITLE VARCHAR NOT NULL,
  DESCRIPTION VARCHAR,
  PUBLISHERID INTEGER NOT NULL,
  PUBLICATIONDATE DATE,
  PRICE DOUBLE,
  PREVIOUSEDITIONID INTEGER
);

CREATE TABLE PUBLIC.BOOKS."Celebrities"
(
  Id INTEGER NOT NULL,
  NAME VARCHAR
);

CREATE TABLE PUBLIC.BOOKS.COUPONS
(
  ID INTEGER NOT NULL,
  DATA CLOB,
  COUPONS PUBLIC.BOOKS."INTEGER ARRAY",
  BOOKS PUBLIC.BOOKS."VARCHAR(20) ARRAY[10]"
);

CREATE TABLE PUBLIC.BOOKS.CUSTOMERS
(
  ID INTEGER NOT NULL,
  FIRSTNAME PUBLIC.BOOKS.NAME_TYPE NOT NULL,
  LASTNAME PUBLIC.BOOKS.NAME_TYPE NOT NULL,
  AGE PUBLIC.BOOKS.AGE_TYPE
);

CREATE TABLE PUBLIC.BOOKS.PUBLISHERS
(
  ID INTEGER NOT NULL,
  PUBLISHER VARCHAR
);

CREATE TABLE PUBLIC.BOOKS.BOOKAUTHORS
(
  BOOKID INTEGER NOT NULL,
  AUTHORID INTEGER NOT NULL,
  SOMEDATA VARCHAR
);

CREATE TABLE PUBLIC.BOOKS."Celebrity Updates"
(
  Celebrity Id INTEGER NOT NULL,
  UPDATE VARCHAR
);

CREATE TABLE PUBLIC.BOOKS.CUSTOMERDATA
(
  CUSTOMERID INTEGER NOT NULL,
  DATAID INTEGER NOT NULL,
  DATA PUBLIC.BOOKS.VALID_STRING
);

CREATE TABLE PUBLIC.BOOKS.ΒΙΒΛΊΑ
(
  ΜΟΝΑΔΙΚΌΣ SMALLINT NOT NULL,
  ΤΊΤΛΟΣ VARCHAR NOT NULL,
  ΠΕΡΙΓΡΑΦΉ VARCHAR,
  ΕΚΔΌΤΗΣ SMALLINT NOT NULL
);

SET SCHEMA PUBLIC.INFORMATION_SCHEMA;

SET SCHEMA PUBLIC.PUBLIC;

SET SCHEMA PUBLIC."PUBLISHER SALES";

CREATE TABLE PUBLIC."PUBLISHER SALES".REGIONS
(
  CITY VARCHAR NOT NULL,
  STATE VARCHAR NOT NULL,
  POSTALCODE VARCHAR NOT NULL,
  COUNTRY VARCHAR NOT NULL
);

CREATE TABLE PUBLIC."PUBLISHER SALES".SALESDATA
(
  SALESDATAID INTEGER,
  YEARLYAMOUNT DOUBLE
);

CREATE TABLE PUBLIC."PUBLISHER SALES".SALES
(
  POSTALCODE VARCHAR NOT NULL,
  COUNTRY VARCHAR NOT NULL,
  BOOKID INTEGER,
  COUPON_ID INTEGER,
  PERIODENDDATE DATE,
  TOTALAMOUNT DOUBLE,
  SALESDATAID INTEGER
);

SET SCHEMA PUBLIC.SYSTEM_LOBS;

