Query

all_tables
TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS TYPE_CAT TYPE_SCHEM TYPE_NAME SELF_REFERENCING_COL_NAME REF_GENERATION HSQLDB_TYPE READ_ONLY COMMIT_ACTION
PUBLIC BOOKS AUTHORS TABLE Contact details for book authors NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC BOOKS AUTHORSLIST VIEW NULL NULL NULL NULL NULL NULL NULL false NULL
PUBLIC BOOKS BOOKAUTHORS TABLE Relationship between books and their authors, along with the latest updated information NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC BOOKS BOOKS TABLE Details for published books NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC BOOKS COUPONS TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC BOOKS CUSTOMERDATA TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC BOOKS CUSTOMERS TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC BOOKS Global Counts TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC BOOKS PUBLISHERS TABLE List of book publishers NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC BOOKS TEMP_AUTHOR_LIST GLOBAL TEMPORARY NULL NULL NULL NULL NULL NULL MEMORY false DELETE
PUBLIC BOOKS ΒΙΒΛΊΑ TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC FOR_LINT EXTRA_PK TABLE Extra table with just a primary key NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC FOR_LINT Global Counts TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC FOR_LINT PUBLICATIONS TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC FOR_LINT PUBLICATIONWRITERS TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC FOR_LINT SELFREFERENCE TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC FOR_LINT TEMP1 GLOBAL TEMPORARY NULL NULL NULL NULL NULL NULL MEMORY false DELETE
PUBLIC FOR_LINT WRITERS TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS SYSTEM TABLE one row for each role that can be granted NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA APPLICABLE_ROLES SYSTEM TABLE one row for each role granted to an authorization NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ASSERTIONS SYSTEM TABLE NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA AUTHORIZATIONS SYSTEM TABLE one row for each user and one row for each role NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA CHARACTER_SETS SYSTEM TABLE one row for each character set name NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA CHECK_CONSTRAINTS SYSTEM TABLE one row for each domain constraint, table check constraint, and assertion. NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA CHECK_CONSTRAINT_ROUTINE_USAGE SYSTEM TABLE one row for each SQL-invoked routine identified as the subject routine of either a <routine invocation>, a <method reference>, a <method invocation>, or a <static method invocation> contained in an <assertion definition>, a <domain constraint>, or a <table constraint definition>. NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA COLLATIONS SYSTEM TABLE one row for each character collation descriptor. NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA COLUMNS SYSTEM TABLE one row for each column of table of view NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA COLUMN_COLUMN_USAGE SYSTEM TABLE one row for each usage of a column in a generated column definition NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA COLUMN_DOMAIN_USAGE SYSTEM TABLE one row for each usage of a domain as the type of a column NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA COLUMN_PRIVILEGES SYSTEM TABLE the visible user level access permissions of each visible column of each accessible table defined within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA COLUMN_UDT_USAGE SYSTEM TABLE one row for each usage of a user defined type as the type of a column NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA CONSTRAINT_COLUMN_USAGE SYSTEM TABLE one row for each column identified by a <column reference> contained in the <search condition> of a check constraint, domain constraint, or assertion. NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA CONSTRAINT_PERIOD_USAGE SYSTEM TABLE NULL NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA CONSTRAINT_TABLE_USAGE SYSTEM TABLE one row for each table identified by a <table name> simply contained in a <table reference> contained in the <search condition> of a check constraint, domain constraint, or assertion. NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA DATA_TYPE_PRIVILEGES SYSTEM TABLE one row for each usage privilege granted on a user defined type NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA DOMAINS SYSTEM TABLE one row for each domain identified NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA DOMAIN_CONSTRAINTS SYSTEM TABLE one row for each check constraint included in a domain definition NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ELEMENT_TYPES SYSTEM TABLE NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ENABLED_ROLES SYSTEM TABLE NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA INFORMATION_SCHEMA_CATALOG_NAME SYSTEM TABLE the catalog defined within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA JARS SYSTEM TABLE NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA JAR_JAR_USAGE SYSTEM TABLE NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA KEY_COLUMN_USAGE SYSTEM TABLE one row for each column used in s primary key or unique constraint NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA KEY_PERIOD_USAGE SYSTEM TABLE NULL NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA PARAMETERS SYSTEM TABLE one row for each routine parameter NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA PERIODS SYSTEM TABLE NULL NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS SYSTEM TABLE one row for each foreign key constraint NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ROLE_AUTHORIZATION_DESCRIPTORS SYSTEM TABLE one row for each role granted directly to a grantee NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ROLE_COLUMN_GRANTS SYSTEM TABLE one row for each privilege on a column granted to a role NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS SYSTEM TABLE one row for each usage grant on a routine to a role NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ROLE_TABLE_GRANTS SYSTEM TABLE one row for each privilege grant on a table to a role NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ROLE_UDT_GRANTS SYSTEM TABLE one row for each usage grant on a user defined type to a role NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ROLE_USAGE_GRANTS SYSTEM TABLE one row for each usage grant to a role NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ROUTINES SYSTEM TABLE one row for each routine NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ROUTINE_COLUMN_USAGE SYSTEM TABLE one row for each table column usage in a routine NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ROUTINE_JAR_USAGE SYSTEM TABLE NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ROUTINE_PERIOD_USAGE SYSTEM TABLE NULL NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ROUTINE_PRIVILEGES SYSTEM TABLE one row for each usage privilege on a routine NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ROUTINE_ROUTINE_USAGE SYSTEM TABLE one row for each usage of a routine in a routine NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ROUTINE_SEQUENCE_USAGE SYSTEM TABLE one row for each usage of a sequence in a routine NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA ROUTINE_TABLE_USAGE SYSTEM TABLE one row for each usage of a table in a routine NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SCHEMATA SYSTEM TABLE one row for each schema NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SEQUENCES SYSTEM TABLE one row for each external sequence generator NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SQL_FEATURES SYSTEM TABLE list of supported SQL Standard features NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SQL_IMPLEMENTATION_INFO SYSTEM TABLE list of implementation specific limits NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SQL_PACKAGES SYSTEM TABLE list of supported SQL Standard packages NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SQL_PARTS SYSTEM TABLE list of supported SQL Standard parts NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SQL_SIZING SYSTEM TABLE list of size limits for names and database objects NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SQL_SIZING_PROFILES SYSTEM TABLE list of supported SQL Standard packages NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_BESTROWIDENTIFIER SYSTEM TABLE for each accessible table defined within this database, the optimal set of visible columns that uniquely identifies a row NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_CACHEINFO SYSTEM TABLE the current state of the system row caching mechanism NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_COLUMNS SYSTEM TABLE the visible columns of each accessible table defined within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_COLUMN_SEQUENCE_USAGE SYSTEM TABLE the name of the sequences used by autogenerated columns NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_COMMENTS SYSTEM TABLE comments on tables, views and columns, defined by users or system NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_CONNECTION_PROPERTIES SYSTEM TABLE properties defined for the current connection NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_CROSSREFERENCE SYSTEM TABLE a description of how the accessible tables defined within this database import visible columns to enforce referential integrity NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_INDEXINFO SYSTEM TABLE information about the indices of each accessible table defined within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_INDEXSTATS SYSTEM TABLE storage space used by the indices of each accessible table defined within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_KEY_INDEX_USAGE SYSTEM TABLE names of indexes generated by the system for each constraint NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_PRIMARYKEYS SYSTEM TABLE the visible columns of the primary key of each accessible table defined within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_PROCEDURECOLUMNS SYSTEM TABLE a description of the return type, parameters and result columns of each accessible callable procedure, SQL function, trigger body and UDT method defined within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_PROCEDURES SYSTEM TABLE the procedures, SQL functions, trigger body routines and UDT methods defined within the database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_PROPERTIES SYSTEM TABLE the static and dynamic system properties and operating parameters of this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_SCHEMAS SYSTEM TABLE the accessible schemas defined within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_SEQUENCES SYSTEM TABLE the visible sequences in this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_SESSIONINFO SYSTEM TABLE information about the current database session NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_SESSIONS SYSTEM TABLE the visible sessions open in this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_SYNONYMS SYSTEM TABLE the synonyms for tables and other objects defined in this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_TABLES SYSTEM TABLE the accessible tables defined within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_TABLESTATS SYSTEM TABLE cardinality and storage space used by tables and table spaces NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_TABLETYPES SYSTEM TABLE the types of tables that can be created/found within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_TEXTTABLES SYSTEM TABLE the data source descriptors of the accessible TEXT TABLE objects defined within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_TYPEINFO SYSTEM TABLE a description of predefined table column data types known to this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_UDTS SYSTEM TABLE the user-defined types that are available within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_USERS SYSTEM TABLE users defined within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA SYSTEM_VERSIONCOLUMNS SYSTEM TABLE the visible columns of the accessible tables that are automatically updated when any value in a row is updated NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA TABLES SYSTEM TABLE one row for each table or view NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA TABLE_CONSTRAINTS SYSTEM TABLE one row for each table constraint associated with a table NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA TABLE_PRIVILEGES SYSTEM TABLE the visible user level access permissions for each accessible table defined within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA TRANSLATIONS SYSTEM TABLE NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA TRIGGERED_UPDATE_COLUMNS SYSTEM TABLE one row for each column in a foreign key cascade action NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA TRIGGERS SYSTEM TABLE one row for each trigger definition NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA TRIGGER_COLUMN_USAGE SYSTEM TABLE one row for each usage of a table column in a trigger definition NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA TRIGGER_PERIOD_USAGE SYSTEM TABLE NULL NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA TRIGGER_ROUTINE_USAGE SYSTEM TABLE one row for each usage of a routine in a trigger definition NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA TRIGGER_SEQUENCE_USAGE SYSTEM TABLE one row for each usage of a sequence in a trigger definition NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA TRIGGER_TABLE_USAGE SYSTEM TABLE one row for each usage of a table or view in a trigger definition NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA UDT_PRIVILEGES SYSTEM TABLE one row for each usage privilege on a user defined type NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA USAGE_PRIVILEGES SYSTEM TABLE one row for each usage privilege granted on character set or domain NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA USER_DEFINED_TYPES SYSTEM TABLE one row for each user defined type NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA VIEWS SYSTEM TABLE the view descriptors of the accessible views defined within this database NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA VIEW_COLUMN_USAGE SYSTEM TABLE one row for each column of a table that is explicitly or implicitly referenced in the <query expression> of the view being described NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA VIEW_PERIOD_USAGE SYSTEM TABLE NULL NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA VIEW_ROUTINE_USAGE SYSTEM TABLE one row for each SQL-invoked routine identified as the subject routine of either a <routine invocation>, a <method reference>, a <method invocation>, or a <static method invocation> contained in a <view definition> NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC INFORMATION_SCHEMA VIEW_TABLE_USAGE SYSTEM TABLE one row for each table identified by a <table name> simply contained in a <table reference> that is contained in the <query expression> of a view NULL NULL NULL NULL NULL MEMORY true NULL
PUBLIC PUBLISHER SALES REGIONS TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC PUBLISHER SALES SALES TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC PUBLISHER SALES SALESDATA TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC SYSTEM_LOBS BLOCKS SYSTEM TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC SYSTEM_LOBS LOBS SYSTEM TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC SYSTEM_LOBS LOB_IDS SYSTEM TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL
PUBLIC SYSTEM_LOBS PARTS SYSTEM TABLE NULL NULL NULL NULL NULL NULL MEMORY false NULL

 

 

Query

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 NULL
2 Duis Dignissim Tempor Arcu. Eu, Euismod Ac, Fermentum Vel, 20 2002-05-09 27.99 NULL
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 NULL
4 Vitae Sodales Rhoncus. Nullam Velit Dui, Semper Et, Lacinia Vitae, Sodales At, 1 2007-05-21 64.99 NULL
5 Posuere Cubilia Curae Phasellus Ornare. Risus A Ultricies Adipiscing, Enim Mi Tempor Lorem, Eget Mollis Lectus Pede 7 2010-05-14 83.99 NULL
6 Tincidunt Aliquam Arcu. Tristique Pellentesque, Tellus Sem Mollis Dui, 13 2009-07-17 31.99 NULL
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 NULL
8 Sem. Nulla Interdum. Curabitur Turpis. Nulla Aliquet. Proin Velit. Sed Malesuada Augue Ut 7 2009-01-24 30.99 NULL
9 Lobortis Ultrices. Vivamus Rhoncus. Est, Mollis Non, Cursus Non, Egestas A, Dui. Cras Pellentesque. Sed Dictum. 1 2004-06-25 69.99 NULL
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 NULL
11 Phasellus Egestas. Duis Ac Arcu. Nunc Mauris. 5 2003-10-19 89.99 NULL
12 Non Massa Non Est Mauris, Rhoncus Id, Mollis 5 2002-05-04 64.99 NULL
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 NULL
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 NULL
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 NULL
16 Vitae, Aliquet Nec, Imperdiet Cursus Purus. Nullam 6 2003-08-30 47.99 NULL
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 NULL
18 Lacus. Etiam Bibendum Facilisi. Sed Neque. Sed 18 2008-01-28 63.99 NULL
19 Luctus Lobortis. Rutrum. Fusce Dolor Quam, Elementum At, Egestas A, Scelerisque Sed, Sapien. 5 2006-08-23 67.99 NULL
20 Dui, In Sodales Elit Erat Sociis Natoque Penatibus Et Magnis Dis Parturient 5 2002-09-29 43.99 NULL

 

PUBLIC.BOOKS.COUPONS
ID
1
2
3
4
5
6
7
8
9
10

 

PUBLIC.BOOKS.CUSTOMERDATA
ID DATA

 

PUBLIC.BOOKS.CUSTOMERS
ID

 

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

 

 

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

 

 

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]