System Information

generated by SchemaCrawler 16.1.2
generated on 2019-10-09 01:01:36
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."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]

 

 

Sequences

PUBLIC.BOOKS.PUBLISHER_ID_SEQ [sequence]

 

 

Row Count

Row Count
PUBLIC.BOOKS.AUTHORS 20 rows
PUBLIC.BOOKS.AUTHORSLIST 20 rows
PUBLIC.BOOKS.BOOKAUTHORS 20 rows
PUBLIC.BOOKS.BOOKS 20 rows
PUBLIC.BOOKS.COUPONS 10 rows
PUBLIC.BOOKS.CUSTOMERDATA empty
PUBLIC.BOOKS.CUSTOMERS empty
PUBLIC.BOOKS."Global Counts" 10 rows
PUBLIC.BOOKS.PUBLISHERS 20 rows
PUBLIC.BOOKS.ΒΙΒΛΊΑ empty
PUBLIC."PUBLISHER SALES".REGIONS 20 rows
PUBLIC."PUBLISHER SALES".SALES 20 rows
PUBLIC."PUBLISHER SALES".SALESDATA empty