

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

generated by                              SchemaCrawler 15.06.01
generated on                              2018-06-03 07:39:42
database version                          HSQL Database Engine 2.5.0
driver version                            HSQL Database Engine Driver 2.5.0



Tables
========================================================================



PUBLIC.BOOKS.AUTHORS                                             [table]
------------------------------------------------------------------------
Contact details for book authors
  ID                                INTEGER NOT NULL
  FIRSTNAME                         VARCHAR(20) NOT NULL
  LASTNAME                          VARCHAR(20) NOT NULL
  CITY                              VARCHAR(50)
  STATE                             VARCHAR(2)
  POSTALCODE                        VARCHAR(10)
  COUNTRY                           VARCHAR(50)

Primary Key

PK_AUTHORS                                                 [primary key]
  ID                                ascending

Foreign Keys

Z_FK_AUTHOR                                [foreign key, with no action]
  ID <--(0..many) PUBLIC.BOOKS.BOOKAUTHORS.AUTHORID



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



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

Foreign Keys

Z_FK_AUTHOR                                [foreign key, with no action]
  AUTHORID (0..many)--> PUBLIC.BOOKS.AUTHORS.ID

SYS_FK_10128                               [foreign key, with no action]
  BOOKID (0..many)--> PUBLIC.BOOKS.BOOKS.ID



PUBLIC.BOOKS.BOOKS                                               [table]
------------------------------------------------------------------------
Details for published books
  ID                                INTEGER NOT NULL
                                    Unique (internal) id for book
  PREVIOUSEDITIONID                 INTEGER

Primary Key

PK_BOOKS                                                   [primary key]
  ID                                ascending

Foreign Keys

SYS_FK_10128                               [foreign key, with no action]
  ID <--(0..many) PUBLIC.BOOKS.BOOKAUTHORS.BOOKID

FK_PREVIOUSEDITION                         [foreign key, with no action]
  ID <--(0..1) PREVIOUSEDITIONID



PUBLIC.BOOKS.COUPONS                                             [table]
------------------------------------------------------------------------
  ID                                INTEGER NOT NULL

Primary Key

PK_COUPONS                                                 [primary key]
  ID                                ascending



PUBLIC.BOOKS.CUSTOMERDATA                                        [table]
------------------------------------------------------------------------
  ID                                INTEGER NOT NULL

Primary Key

PK_CUSTOMERDATA                                            [primary key]
  ID                                ascending



PUBLIC.BOOKS.CUSTOMERS                                           [table]
------------------------------------------------------------------------
  ID                                INTEGER NOT NULL

Primary Key

PK_CUSTOMERS                                               [primary key]
  ID                                ascending



PUBLIC.BOOKS."Global Counts"                                     [table]
------------------------------------------------------------------------



PUBLIC.BOOKS.PUBLISHERS                                          [table]
------------------------------------------------------------------------
List of book publishers
  ID                                INTEGER NOT NULL
                                    auto-incremented
                                    Unique (internal) id for book publisher

Primary Key

SYS_PK_10106                                               [primary key]
  ID                                ascending

Foreign Keys

FK_ΒΙΒΛΊΑ_PUBLISHERS                       [foreign key, with no action]
  ID <--(0..many) PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ



PUBLIC.BOOKS.ΒΙΒΛΊΑ                                              [table]
------------------------------------------------------------------------
  ΜΟΝΑΔΙΚΌΣ                         SMALLINT NOT NULL
  ΕΚΔΌΤΗΣ                           SMALLINT NOT NULL

Primary Key

PK_ΒΙΒΛΊΑ                                                  [primary key]
  ΜΟΝΑΔΙΚΌΣ                         ascending

Foreign Keys

FK_ΒΙΒΛΊΑ_PUBLISHERS                       [foreign key, with no action]
  ΕΚΔΌΤΗΣ (0..many)--> PUBLIC.BOOKS.PUBLISHERS.ID



PUBLIC.FOR_LINT.EXTRA_PK                                         [table]
------------------------------------------------------------------------
Extra table with just a primary key
  WRITERID                          BIGINT NOT NULL
  PUBLICATIONID                     INTEGER NOT NULL
  ID                                INTEGER NOT NULL

Primary Key

PK_EXTRA_PK                                                [primary key]
  ID                                ascending

Foreign Keys

FK_PUBLICATION_JOIN                        [foreign key, with no action]
  PUBLICATIONID (0..many)--> PUBLIC.FOR_LINT.PUBLICATIONS.ID

FK_WRITER_JOIN                             [foreign key, with no action]
  WRITERID (0..many)--> PUBLIC.FOR_LINT.WRITERS.ID



PUBLIC.FOR_LINT."Global Counts"                                  [table]
------------------------------------------------------------------------



PUBLIC.FOR_LINT.PUBLICATIONS                                     [table]
------------------------------------------------------------------------
  ID                                INTEGER NOT NULL
  WRITERID                          BIGINT NOT NULL

Primary Key

PK_PUBLICATIONS                                            [primary key]
  ID                                ascending

Foreign Keys

FK_PUBLICATION_JOIN                        [foreign key, with no action]
  ID <--(0..many) PUBLIC.FOR_LINT.EXTRA_PK.PUBLICATIONID

FK_PUBLICATION                             [foreign key, with no action]
  ID <--(0..many) PUBLIC.FOR_LINT.PUBLICATIONWRITERS.PUBLICATIONID

FK_WRITERS_PUBLICATION                     [foreign key, with no action]
  ID <--(0..many) PUBLIC.FOR_LINT.WRITERS.PUBLICATION_ID

FK_PUBLICATIONS_WRITER                     [foreign key, with no action]
  WRITERID (0..many)--> PUBLIC.FOR_LINT.WRITERS.ID



PUBLIC.FOR_LINT.PUBLICATIONWRITERS                               [table]
------------------------------------------------------------------------
  PUBLICATIONID                     INTEGER NOT NULL
  WRITERID                          BIGINT NOT NULL

Foreign Keys

FK_PUBLICATION                             [foreign key, with no action]
  PUBLICATIONID (0..many)--> PUBLIC.FOR_LINT.PUBLICATIONS.ID

FK_WRITER                                  [foreign key, with no action]
  WRITERID (0..many)--> PUBLIC.FOR_LINT.WRITERS.ID



PUBLIC.FOR_LINT.SELFREFERENCE                                    [table]
------------------------------------------------------------------------
  ID                                INTEGER NOT NULL

Primary Key

PK_SELFREFERENCE                                           [primary key]
  ID                                ascending

Foreign Keys

FK_SELFREFERENCE                           [foreign key, with no action]
  ID <--(0..1) ID



PUBLIC.FOR_LINT.WRITERS                                          [table]
------------------------------------------------------------------------
  ID                                BIGINT NOT NULL
  FIRSTNAME                         VARCHAR(20) NOT NULL
  LASTNAME                          VARCHAR(20) NOT NULL
  CITY                              VARCHAR(50)
  STATE                             VARCHAR(2)
  POSTALCODE                        VARCHAR(10)
  COUNTRY                           VARCHAR(50)
  EMAIL1                            VARCHAR(10)
  PUBLICATION_ID                    BIGINT NOT NULL

Primary Key

PK_WRITERS                                                 [primary key]
  ID                                ascending

Foreign Keys

FK_WRITERS_PUBLICATION                     [foreign key, with no action]
  PUBLICATION_ID (0..many)--> PUBLIC.FOR_LINT.PUBLICATIONS.ID

FK_WRITER_JOIN                             [foreign key, with no action]
  ID <--(0..many) PUBLIC.FOR_LINT.EXTRA_PK.WRITERID

FK_PUBLICATIONS_WRITER                     [foreign key, with no action]
  ID <--(0..many) PUBLIC.FOR_LINT.PUBLICATIONS.WRITERID

FK_WRITER                                  [foreign key, with no action]
  ID <--(0..many) PUBLIC.FOR_LINT.PUBLICATIONWRITERS.WRITERID



PUBLIC."PUBLISHER SALES".REGIONS                                 [table]
------------------------------------------------------------------------
  POSTALCODE                        VARCHAR(10) NOT NULL
  COUNTRY                           VARCHAR(50) NOT NULL

Primary Key

PK_CUSTOMERS                                               [primary key]
  POSTALCODE                        ascending
  COUNTRY                           ascending

Foreign Keys

FK_SALES_REGIONS                           [foreign key, with no action]
  POSTALCODE <--(0..many) PUBLIC."PUBLISHER SALES".SALES.POSTALCODE
  COUNTRY <--(0..many) PUBLIC."PUBLISHER SALES".SALES.COUNTRY



PUBLIC."PUBLISHER SALES".SALES                                   [table]
------------------------------------------------------------------------
  POSTALCODE                        VARCHAR(10) NOT NULL
  COUNTRY                           VARCHAR(50) NOT NULL
  SALESDATAID                       INTEGER

Foreign Keys

FK_SALES_SALESDATA                         [foreign key, with no action]
  SALESDATAID (0..many)--> PUBLIC."PUBLISHER SALES".SALESDATA.SALESDATAID

FK_SALES_REGIONS                           [foreign key, with no action]
  POSTALCODE (0..many)--> PUBLIC."PUBLISHER SALES".REGIONS.POSTALCODE
  COUNTRY (0..many)--> PUBLIC."PUBLISHER SALES".REGIONS.COUNTRY



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

Foreign Keys

FK_SALES_SALESDATA                         [foreign key, with no action]
  SALESDATAID <--(0..many) PUBLIC."PUBLISHER SALES".SALES.SALESDATAID



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



PUBLIC.BOOKS.NEW_PUBLISHER                        [procedure, no result]
------------------------------------------------------------------------



PUBLIC.BOOKS.NEW_PUBLISHER                        [procedure, no result]
------------------------------------------------------------------------



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



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



PUBLIC.SYSTEM_LOBS.ALLOC_BLOCKS                   [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.ALLOC_SINGLE_BLOCK             [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.CONVERT_BLOCK                  [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.CREATE_EMPTY_BLOCK             [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.DELETE_BLOCKS                  [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.DELETE_LOB                     [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.DELETE_UNUSED                  [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.DELETE_UNUSED_LOBS             [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.DIVIDE_BLOCK                   [procedure, no result]
------------------------------------------------------------------------



PUBLIC.SYSTEM_LOBS.MERGE_EMPTY_BLOCKS             [procedure, no result]
------------------------------------------------------------------------

