System Information

generated by SchemaCrawler 16.17.1
generated on 2022-07-29 15:55:46
database version HSQL Database Engine 2.7.0
driver version HSQL Database Engine Driver 2.7.0

 

 

Tables

PUBLIC.BOOKS.AUTHORS [table]
Contact details for book authors

 

PUBLIC.BOOKS.AUTHORSLIST [view]

 

PUBLIC.BOOKS.BOOKAUTHORS [table]
Relationship between books and their authors, along with the latest updated information

 

PUBLIC.BOOKS.BOOKS [table]
Details for published books

 

PUBLIC.BOOKS.COUPONS [table]

 

PUBLIC.BOOKS.CUSTOMERDATA [table]

 

PUBLIC.BOOKS.CUSTOMERS [table]

 

PUBLIC.BOOKS."Global Counts" [table]

 

PUBLIC.BOOKS.PUBLISHERS [table]
List of book publishers

 

PUBLIC.BOOKS.ΒΙΒΛΊΑ [table]

 

PUBLIC.FOR_LINT.EXTRA_PK [table]
Extra table with just a primary key

 

PUBLIC.FOR_LINT."Global Counts" [table]

 

PUBLIC.FOR_LINT.PUBLICATIONS [table]

 

PUBLIC.FOR_LINT.PUBLICATIONWRITERS [table]

 

PUBLIC.FOR_LINT.SELFREFERENCE [table]

 

PUBLIC.FOR_LINT.WRITERS [table]

 

PUBLIC."PUBLISHER SALES".REGIONS [table]

 

PUBLIC."PUBLISHER SALES".SALES [table]

 

PUBLIC."PUBLISHER SALES".SALESDATA [table]

 

 

Routines

PUBLIC.BOOKS.NEW_PUBLISHER [procedure, no result]
[specific name]
NEW_PUBLISHER_10148

 

PUBLIC.BOOKS.NEW_PUBLISHER [procedure, no result]
[specific name]
NEW_PUBLISHER_FORCE_VALUE

 

PUBLIC.BOOKS.CUSTOMADD [function, does not return a table]
[specific name]
CUSTOMADD_10149

 

PUBLIC.BOOKS.CUSTOMADD [function, does not return a table]
[specific name]
CUSTOMADD_10150

 

PUBLIC.SYSTEM_LOBS.ALLOC_BLOCKS [procedure, no result]
[specific name]
ALLOC_BLOCKS_10071

 

PUBLIC.SYSTEM_LOBS.ALLOC_SINGLE_BLOCK [procedure, no result]
[specific name]
ALLOC_SINGLE_BLOCK_10074

 

PUBLIC.SYSTEM_LOBS.CONVERT_BLOCK [procedure, no result]
[specific name]
CONVERT_BLOCK_10029

 

PUBLIC.SYSTEM_LOBS.CREATE_EMPTY_BLOCK [procedure, no result]
[specific name]
CREATE_EMPTY_BLOCK_10063

 

PUBLIC.SYSTEM_LOBS.DELETE_BLOCKS [procedure, no result]
[specific name]
DELETE_BLOCKS_10060

 

PUBLIC.SYSTEM_LOBS.DELETE_LOB [procedure, no result]
[specific name]
DELETE_LOB_10031

 

PUBLIC.SYSTEM_LOBS.DELETE_UNUSED [procedure, no result]
[specific name]
DELETE_UNUSED_10046

 

PUBLIC.SYSTEM_LOBS.DELETE_UNUSED_LOBS [procedure, no result]
[specific name]
DELETE_UNUSED_LOBS_10058

 

PUBLIC.SYSTEM_LOBS.DIVIDE_BLOCK [procedure, no result]
[specific name]
DIVIDE_BLOCK_10066

 

PUBLIC.SYSTEM_LOBS.MERGE_EMPTY_BLOCKS [procedure, no result]
[specific name]
MERGE_EMPTY_BLOCKS_10079

 

 

System Information

Database Information

database product name HSQL Database Engine
database product version 2.7.0
database user name SA

 

JDBC Driver Information

connection url jdbc:hsqldb:hsql://0.0.0.0:60689/schemacrawler60689
driver name HSQL Database Engine Driver
driver version 2.7.0