System Information

generated by SchemaCrawler 16.9.2
generated on 2020-06-20 14:57:29
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
ADDRESS1 VARCHAR(255)
ADDRESS2 VARCHAR(255)
CITY VARCHAR(50)
STATE CHARACTER(2)
POSTALCODE VARCHAR(10)
COUNTRY VARCHAR(50)
Primary Key
[primary key]
ID
Foreign Keys
[foreign key, with no action]
ID ←(0..many) PUBLIC.BOOKS.BOOKAUTHORS.AUTHORID
Indexes
[unique index]
ID ascending
[non-unique index]
LASTNAME ascending
FIRSTNAME ascending
[non-unique index]
CITY ascending
STATE ascending
POSTALCODE ascending
COUNTRY ascending
Triggers
TRG_AUTHORS [trigger, after delete, per row]
UPDATE BOOKS.PUBLISHERS SET PUBLISHER='Jacob'WHERE PUBLISHER='John'
Table Constraints
[check constraint]
STATE
[check constraint]
ID
[check constraint]
FIRSTNAME
[check constraint]
LASTNAME

 

PUBLIC.BOOKS.AUTHORSLIST [view]
ID INTEGER
FIRSTNAME VARCHAR(20)
LASTNAME VARCHAR(20)

 

PUBLIC.BOOKS.BOOKAUTHORS [table]
Relationship between books and their authors, along with the latest updated information
BOOKID INTEGER NOT NULL
AUTHORID INTEGER NOT NULL
SOMEDATA VARCHAR(30)
Foreign Keys
[foreign key, with no action]
AUTHORID (0..many)→ PUBLIC.BOOKS.AUTHORS.ID
[foreign key, with no action]
BOOKID (0..many)→ PUBLIC.BOOKS.BOOKS.ID
Indexes
[non-unique index]
AUTHORID ascending
[non-unique index]
BOOKID ascending
[unique index]
BOOKID ascending
AUTHORID ascending
Table Constraints
[check constraint]
BOOKID
[check constraint]
AUTHORID

 

PUBLIC.BOOKS.BOOKS [table]
Details for published books
ID INTEGER NOT NULL
Unique (internal) id for book
TITLE VARCHAR(255) NOT NULL
Book title
DESCRIPTION VARCHAR(255)
Book description (Usually the blurb from the book jacket or promotional materials)
PUBLISHERID INTEGER NOT NULL
Foreign key to the book publisher
PUBLICATIONDATE DATE
Book publication date
PRICE DOUBLE(64, 0)
Current price for the book
PREVIOUSEDITIONID INTEGER
Primary Key
[primary key]
ID
Foreign Keys
[foreign key, with no action]
ID ←(0..many) PUBLIC.BOOKS.BOOKAUTHORS.BOOKID
[foreign key, with no action]
ID ←(0..1) PREVIOUSEDITIONID
Indexes
[unique index]
ID ascending
[unique index]
PREVIOUSEDITIONID ascending
[non-unique index]
PREVIOUSEDITIONID ascending
Table Constraints
[unique constraint]
PREVIOUSEDITIONID
[check constraint]
ID
[check constraint]
TITLE
[check constraint]
PUBLISHERID

 

PUBLIC.BOOKS.COUPONS [table]
ID INTEGER NOT NULL
DATA CLOB
COUPONS INTEGER ARRAY
BOOKS VARCHAR(20) ARRAY[10]
Primary Key
[primary key]
ID
Indexes
[unique index]
ID ascending
Table Constraints
[check constraint]
ID

 

PUBLIC.BOOKS.CUSTOMERDATA [table]
ID INTEGER NOT NULL
DATA VALID_STRING(20)
Primary Key
[primary key]
ID
Indexes
[unique index]
ID ascending
Table Constraints
[check constraint]
ID

 

PUBLIC.BOOKS.CUSTOMERS [table]
ID INTEGER NOT NULL
FIRSTNAME NAME_TYPE NOT NULL
LASTNAME NAME_TYPE NOT NULL
AGE AGE_TYPE
Primary Key
[primary key]
ID
Indexes
[unique index]
ID ascending
Table Constraints
[check constraint]
ID
[check constraint]
FIRSTNAME
[check constraint]
LASTNAME

 

PUBLIC.BOOKS."Global Counts" [table]
"Global Count" INTEGER
"UPDATE" VARCHAR(20)

 

PUBLIC.BOOKS.PUBLISHERS [table]
List of book publishers
ID INTEGER NOT NULL
auto-incremented
Unique (internal) id for book publisher
PUBLISHER VARCHAR(255)
Name of book publisher
Primary Key
[primary key]
ID
Foreign Keys
[foreign key, with no action]
ID ←(0..many) PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ
Indexes
[unique index]
ID ascending

 

PUBLIC.BOOKS.ΒΙΒΛΊΑ [table]
ΜΟΝΑΔΙΚΌΣ SMALLINT NOT NULL
ΤΊΤΛΟΣ VARCHAR(255) NOT NULL
ΠΕΡΙΓΡΑΦΉ VARCHAR(255)
ΕΚΔΌΤΗΣ SMALLINT NOT NULL
Primary Key
[primary key]
ΜΟΝΑΔΙΚΌΣ
Foreign Keys
[foreign key, with no action]
ΕΚΔΌΤΗΣ (0..many)→ PUBLIC.BOOKS.PUBLISHERS.ID
Indexes
[non-unique index]
ΕΚΔΌΤΗΣ ascending
[unique index]
ΜΟΝΑΔΙΚΌΣ ascending
Table Constraints
[check constraint]
ΜΟΝΑΔΙΚΌΣ
[check constraint]
ΤΊΤΛΟΣ
[check constraint]
ΕΚΔΌΤΗΣ

 

PUBLIC."PUBLISHER SALES".REGIONS [table]
CITY VARCHAR(50) NOT NULL
STATE VARCHAR(2) NOT NULL
POSTALCODE VARCHAR(10) NOT NULL
COUNTRY VARCHAR(50) NOT NULL
Primary Key
[primary key]
POSTALCODE
COUNTRY
Foreign Keys
[foreign key, with no action]
POSTALCODE ←(0..many) PUBLIC."PUBLISHER SALES".SALES.POSTALCODE
COUNTRY ←(0..many) PUBLIC."PUBLISHER SALES".SALES.COUNTRY
Indexes
[unique index]
POSTALCODE ascending
COUNTRY ascending
Table Constraints
[check constraint]
CITY
[check constraint]
STATE
[check constraint]
POSTALCODE
[check constraint]
COUNTRY

 

PUBLIC."PUBLISHER SALES".SALES [table]
POSTALCODE VARCHAR(10) NOT NULL
COUNTRY VARCHAR(50) NOT NULL
BOOKID INTEGER
PERIODENDDATE DATE
TOTALAMOUNT DOUBLE(64, 0)
SALESDATAID INTEGER
Foreign Keys
[foreign key, with no action]
SALESDATAID (0..many)→ PUBLIC."PUBLISHER SALES".SALESDATA.SALESDATAID
[foreign key, with no action]
POSTALCODE (0..many)→ PUBLIC."PUBLISHER SALES".REGIONS.POSTALCODE
COUNTRY (0..many)→ PUBLIC."PUBLISHER SALES".REGIONS.COUNTRY
Indexes
[non-unique index]
SALESDATAID ascending
[non-unique index]
POSTALCODE ascending
COUNTRY ascending
Table Constraints
[check constraint]
POSTALCODE
[check constraint]
COUNTRY

 

PUBLIC."PUBLISHER SALES".SALESDATA [table]
SALESDATAID INTEGER
YEARLYAMOUNT DOUBLE(64, 0)
Foreign Keys
[foreign key, with no action]
SALESDATAID ←(0..many) PUBLIC."PUBLISHER SALES".SALES.SALESDATAID
Indexes
[unique index]
SALESDATAID ascending
Table Constraints
[unique constraint]
SALESDATAID

 

 

Routines

PUBLIC.BOOKS.NEW_PUBLISHER [procedure, no result]
PUBLISHER CHARACTER VARYING, out

 

PUBLIC.BOOKS.NEW_PUBLISHER [procedure, no result]
NEWPUBLISHER CHARACTER VARYING, in
PUBLISHER CHARACTER VARYING, out

 

PUBLIC.BOOKS.CUSTOMADD [function, does not return a table]
ONE INTEGER, in

 

PUBLIC.BOOKS.CUSTOMADD [function, does not return a table]
ONE INTEGER, in
TWO INTEGER, in

 

 

Sequences

PUBLIC.BOOKS.PUBLISHER_ID_SEQ [sequence]
increment 1
start value
minimum value -2147483648
maximum value 2147483647
cycle false

 

 

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

 

 

Dump

PUBLIC.BOOKS.AUTHORS
ID FIRSTNAME LASTNAME ADDRESS1 ADDRESS2 CITY STATE POSTALCODE COUNTRY
1 Oren Shaffer 900-2273 Integer Avenue Farmer City MD 37032 Cook Islands
2 Octavia Burke 955-7635 Natoque St. Kalispell MS 66863 Cape Verde
3 Aiko Stafford Ap #554-7132 Dictum Street Kankakee ID 59675 Brunei Darussalam
4 Christine Aguilar Ap #698-4255 Sodales Av. Riverton MA 24828 Ghana
5 Kenneth Curry P.O. Box 305, 8335 Cras St. Somersworth ME 36619 Kazakhstan
6 Lillian Nieves P.O. Box 827, 1923 Ornare Avenue Sierra Vista MA 12684 Mali
7 Damian Donaldson 5047 Eu Rd. LaGrange UT 64681 Thailand
8 Jordan Woodward Ap #486-6702 Iaculis Road Glen Cove OH 18011 Libyan Arab Jamahiriya
9 Adele Holmes 7585 Magna. Ave Villa Park ME 00619 Cayman Islands
10 Jillian Mckee 1185 Per Ave Rapid City LA 11671 New Caledonia
11 Mikayla Knight Ap #375-6798 Auctor St. Sault Ste. Marie CO 26558 Lesotho
12 Denise Dominguez 324-4875 Vitae Av. Hudson SD 41933 Russian Federation
13 Ira Dunn 8869 Velit Rd. Lincoln IA 74182 Zambia
14 Elvis Blevins Ap #629-9258 In St. Abilene WY 19269 Saint Vincent and The Grenadines
15 Theodore Gilliam 6293 Enim, Ave Baltimore UT 86549 Saudi Arabia
16 Jared White P.O. Box 806, 6212 Adipiscing, Road Thibodaux KS 90172 China
17 Melyssa Willis Ap #467-9359 Ipsum Rd. Roanoke OH 45706 Niger
18 Hilary Marks Ap #361-1093 Vitae Street Fort Lauderdale ID 10855 Venezuela
19 Frances Ellis Ap #458-4569 Sem. Ave Durham MS 50037 Gambia
20 Lenore Cooley P.O. Box 937, 3415 Nulla Ave Half Moon Bay OR 51967 Canada

 

PUBLIC.BOOKS.AUTHORSLIST
ID FIRSTNAME LASTNAME
1 Oren Shaffer
2 Octavia Burke
3 Aiko Stafford
4 Christine Aguilar
5 Kenneth Curry
6 Lillian Nieves
7 Damian Donaldson
8 Jordan Woodward
9 Adele Holmes
10 Jillian Mckee
11 Mikayla Knight
12 Denise Dominguez
13 Ira Dunn
14 Elvis Blevins
15 Theodore Gilliam
16 Jared White
17 Melyssa Willis
18 Hilary Marks
19 Frances Ellis
20 Lenore Cooley

 

PUBLIC.BOOKS.BOOKAUTHORS
BOOKID AUTHORID SOMEDATA
1 7 This is the latest update
2 4 NULL
2 6 Some update
3 1 NULL
3 4 No updates since a week
3 5 NULL
3 6 NULL
4 9 NULL
5 5 NULL
5 7 NULL
6 1 NULL
6 8 NULL
7 8 NULL
7 9 NULL
8 6 NULL
9 3 NULL
9 6 NULL
9 7 NULL
10 1 NULL
10 9 NULL

 

PUBLIC.BOOKS.BOOKS
ID TITLE DESCRIPTION PUBLISHERID PUBLICATIONDATE PRICE PREVIOUSEDITIONID
1 Neque. In Ornare Sagittis Dis Parturient Montes, Nascetur Ridiculus Mus. 18 2000-10-27 69.99 1
2 Duis Dignissim Tempor Arcu. Eu, Euismod Ac, Fermentum Vel, 20 2002-05-09 27.99 2
3 Lacinia Orci, Consectetuer Euismod Est Sem Ut Cursus Luctus, Ipsum Leo Elementum Sem, Vitae Aliquam Eros Turpis Non Enim. 15 2006-04-14 37.99 3
4 Vitae Sodales Rhoncus. Nullam Velit Dui, Semper Et, Lacinia Vitae, Sodales At, 1 2007-05-21 64.99 4
5 Posuere Cubilia Curae Phasellus Ornare. Risus A Ultricies Adipiscing, Enim Mi Tempor Lorem, Eget Mollis Lectus Pede 7 2010-05-14 83.99 5
6 Tincidunt Aliquam Arcu. Tristique Pellentesque, Tellus Sem Mollis Dui, 13 2009-07-17 31.99 6
7 Auctor Quis, Tristique Vel, Faucibus Id, Libero. Donec Consectetuer Mauris Id Sapien. Cras Dolor Dolor, Tempus Non, Lacinia 7 1999-06-09 76.99 7
8 Sem. Nulla Interdum. Curabitur Turpis. Nulla Aliquet. Proin Velit. Sed Malesuada Augue Ut 7 2009-01-24 30.99 8
9 Lobortis Ultrices. Vivamus Rhoncus. Est, Mollis Non, Cursus Non, Egestas A, Dui. Cras Pellentesque. Sed Dictum. 1 2004-06-25 69.99 9
10 Quisque Purus Sapien, Gravida Et Ultrices Posuere Cubilia Curae Phasellus Ornare. Fusce Mollis. Duis Sit Amet Diam Eu Dolor Egestas Rhoncus. 19 2005-11-14 34.99 10
11 Phasellus Egestas. Duis Ac Arcu. Nunc Mauris. 5 2003-10-19 89.99 11
12 Non Massa Non Est Mauris, Rhoncus Id, Mollis 5 2002-05-04 64.99 12
13 Gravida Mauris Ut Mi. Duis Fusce Mollis. Duis Sit Amet Diam Eu Dolor Egestas Rhoncus. Proin Nisl Sem, Consequat Nec, 8 2005-08-03 25.99 13
14 Auctor Vitae, Suspendisse Dui. Fusce Diam Nunc, Ullamcorper Eu, Euismod Ac, Fermentum Vel, Mauris. Integer Sem Elit, Pharetra 2 2009-02-09 84.99 14
15 Ultrices Posuere Cubilia Elit, Pellentesque A, Facilisis Non, Bibendum Sed, Est. Nunc Laoreet Lectus Quis Massa. Mauris Vestibulum, Neque Sed 20 2001-08-28 77.99 15
16 Vitae, Aliquet Nec, Imperdiet Cursus Purus. Nullam 6 2003-08-30 47.99 16
17 Parturient Montes, Nascetur Ridiculus Ornare, Lectus Ante Dictum Mi, Ac Mattis Velit Justo Nec Ante. Maecenas Mi Felis, Adipiscing Fringilla, Porttitor Vulputate, Posuere Vulputate, 17 2005-06-24 36.99 17
18 Lacus. Etiam Bibendum Facilisi. Sed Neque. Sed 18 2008-01-28 63.99 18
19 Luctus Lobortis. Rutrum. Fusce Dolor Quam, Elementum At, Egestas A, Scelerisque Sed, Sapien. 5 2006-08-23 67.99 19
20 Dui, In Sodales Elit Erat Sociis Natoque Penatibus Et Magnis Dis Parturient 5 2002-09-29 43.99 20

 

PUBLIC.BOOKS.COUPONS
ID DATA COUPONS BOOKS
1 <binary> ARRAY[] NULL
2 <binary> ARRAY[] NULL
3 <binary> ARRAY[] NULL
4 <binary> ARRAY[] NULL
5 NULL ARRAY[] NULL
6 <binary> ARRAY[] NULL
7 <binary> ARRAY[] NULL
8 NULL ARRAY[] NULL
9 <binary> ARRAY[] NULL
10 <binary> ARRAY[] NULL

 

PUBLIC.BOOKS.CUSTOMERDATA
ID DATA

 

PUBLIC.BOOKS.CUSTOMERS
ID FIRSTNAME LASTNAME AGE

 

PUBLIC.BOOKS."Global Counts"
Global Count UPDATE
1 Abbot
2 Alexis
3 Jasmine
4 NULL
5 Teagan
6 Stella
7 Alden
8 Daniel
9 NULL
10 Yetta

 

PUBLIC.BOOKS.PUBLISHERS
ID PUBLISHER
1 Dalton Lewis
2 Macaulay Bryant
3 Nash Fox
4 Leonard Bradshaw
5 Brendan Kramer
6 Tobias Mosley
7 Zachary Tate
8 Derek Lee
9 Neil Tyson
10 Shad Robinson
11 Justin Schroeder
12 Leonard Atkinson
13 Hyatt Caldwell
14 Neil Fletcher
15 Ferdinand Tucker
16 Barrett Mclaughlin
17 Hayden Potts
18 Neville Cardenas
19 Allistair Gilbert
20 Cooper Chapman

 

PUBLIC.BOOKS.ΒΙΒΛΊΑ
ΜΟΝΑΔΙΚΌΣ ΤΊΤΛΟΣ ΠΕΡΙΓΡΑΦΉ ΕΚΔΌΤΗΣ

 

PUBLIC."PUBLISHER SALES".REGIONS
CITY STATE POSTALCODE COUNTRY
Arvada KY 17131 USA
Baltimore AK 34702 USA
Clairton MA 42875 USA
Del Rio CA 24179 USA
Duluth ND 82539 USA
Effingham TX 44207 USA
El Segundo VA 13078 USA
Fayetteville MS 41233 USA
Hopkinsville IN 54618 USA
Kent OH 91624 USA
Lake Forest AK 26131 USA
Marlborough WV 88272 USA
Martinsburg KY 76672 USA
Nashua SC 27829 USA
Ogdensburg AZ 50786 USA
San Juan MD 30552 USA
Tacoma PA 70472 USA
Warren VA 42210 USA
Watertown SC 20239 USA
Woburn NV 27392 USA

 

PUBLIC."PUBLISHER SALES".SALES
POSTALCODE COUNTRY BOOKID PERIODENDDATE TOTALAMOUNT SALESDATAID
13078 USA 1 2001-07-18 18257.0 NULL
13078 USA 1 2001-09-29 14895.0 NULL
13078 USA 6 2003-12-28 6083.0 NULL
13078 USA 6 2006-06-11 7840.0 NULL
17131 USA 2 2002-04-30 17887.0 NULL
17131 USA 2 2004-11-13 16317.0 NULL
17131 USA 7 2000-03-08 6951.0 NULL
17131 USA 7 2003-03-21 18431.0 NULL
20239 USA 3 2004-08-28 18747.0 NULL
20239 USA 3 2005-07-27 6712.0 NULL
20239 USA 8 2008-03-29 11013.0 NULL
20239 USA 8 2008-08-15 17514.0 NULL
24179 USA 4 2005-12-24 11103.0 NULL
24179 USA 4 2009-02-14 5885.0 NULL
24179 USA 9 2000-05-16 13595.0 NULL
24179 USA 9 2004-04-10 14069.0 NULL
26131 USA 5 2001-12-02 14798.0 NULL
26131 USA 5 2004-11-03 15348.0 NULL
26131 USA 10 2000-09-20 14476.0 NULL
26131 USA 10 2005-12-03 17069.0 NULL

 

PUBLIC."PUBLISHER SALES".SALESDATA
SALESDATAID YEARLYAMOUNT