| generated by | SchemaCrawler 16.1.2 |
| generated on | 2019-10-09 01:01:18 |
| database version | HSQL Database Engine 2.5.0 |
| driver version | HSQL Database Engine Driver 2.5.0 |
| Contact details for book authors | ||
| 1 | ID | INTEGER NOT NULL |
| 2 | FIRSTNAME | VARCHAR(20) NOT NULL |
| 3 | LASTNAME | VARCHAR(20) NOT NULL |
| 4 | ADDRESS1 | VARCHAR(255) |
| 5 | ADDRESS2 | VARCHAR(255) |
| 6 | CITY | VARCHAR(50) |
| 7 | STATE | VARCHAR(2) |
| 8 | POSTALCODE | VARCHAR(10) |
| 9 | COUNTRY | VARCHAR(50) |
| Primary Key | ||
| PK_AUTHORS | [primary key] | |
| 1 | ID | ascending |
| Foreign Keys | ||
| Z_FK_AUTHOR | [foreign key, with no action] | |
| 1 | ID ←(0..many) PUBLIC.BOOKS.BOOKAUTHORS.AUTHORID | |
| Indexes | ||
| SYS_IDX_PK_AUTHORS_10111 | [unique index] | |
| 1 | ID | ascending |
| IDX_B_AUTHORS | [non-unique index] | |
| 3 | LASTNAME | ascending |
| 2 | FIRSTNAME | ascending |
| IDX_A_AUTHORS | [non-unique index] | |
| 6 | CITY | ascending |
| 7 | STATE | ascending |
| 8 | POSTALCODE | ascending |
| 9 | COUNTRY | ascending |
| Triggers | ||
| TRG_AUTHORS | [trigger, after delete, per row] | |
| UPDATE BOOKS.PUBLISHERS SET PUBLISHER='Jacob'WHERE PUBLISHER='John' | ||
| Table Constraints | ||
| CHECK_UPPERCASE_STATE | [check constraint] | |
| 7 | STATE | |
| BOOKS.AUTHORS.STATE=UPPER(BOOKS.AUTHORS.STATE) | ||
| SYS_CT_10108 | [check constraint] | |
| 1 | ID | |
| BOOKS.AUTHORS.ID IS NOT NULL | ||
| SYS_CT_10109 | [check constraint] | |
| 2 | FIRSTNAME | |
| BOOKS.AUTHORS.FIRSTNAME IS NOT NULL | ||
| SYS_CT_10110 | [check constraint] | |
| 3 | LASTNAME | |
| BOOKS.AUTHORS.LASTNAME IS NOT NULL | ||
| Privileges and Grants | ||
| DELETE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| INSERT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| REFERENCES | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| SELECT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| TRIGGER | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| UPDATE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| 1 | ID | INTEGER |
| 2 | FIRSTNAME | VARCHAR(20) |
| 3 | LASTNAME | VARCHAR(20) |
| Privileges and Grants | ||
| DELETE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| INSERT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| REFERENCES | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| SELECT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| TRIGGER | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| UPDATE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| Definition | ||
| [definition] | ||
| SELECT ID,FIRSTNAME,LASTNAME FROM BOOKS.AUTHORS | ||
| Relationship between books and their authors, along with the latest updated information | ||
| 1 | BOOKID | INTEGER NOT NULL |
| 2 | AUTHORID | INTEGER NOT NULL |
| 3 | SOMEDATA | VARCHAR(30) |
| Foreign Keys | ||
| Z_FK_AUTHOR | [foreign key, with no action] | |
| 1 | AUTHORID (0..many)→ PUBLIC.BOOKS.AUTHORS.ID | |
| SYS_FK_10128 | [foreign key, with no action] | |
| 1 | BOOKID (0..many)→ PUBLIC.BOOKS.BOOKS.ID | |
| Indexes | ||
| SYS_IDX_Z_FK_AUTHOR_10134 | [non-unique index] | |
| 2 | AUTHORID | ascending |
| SYS_IDX_SYS_FK_10128_10132 | [non-unique index] | |
| 1 | BOOKID | ascending |
| UIDX_BOOKAUTHORS | [unique index] | |
| 1 | BOOKID | ascending |
| 2 | AUTHORID | ascending |
| Table Constraints | ||
| SYS_CT_10126 | [check constraint] | |
| 1 | BOOKID | |
| BOOKS.BOOKAUTHORS.BOOKID IS NOT NULL | ||
| SYS_CT_10127 | [check constraint] | |
| 2 | AUTHORID | |
| BOOKS.BOOKAUTHORS.AUTHORID IS NOT NULL | ||
| Privileges and Grants | ||
| DELETE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| INSERT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| REFERENCES | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| SELECT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| TRIGGER | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| UPDATE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| Details for published books | ||
| 1 | ID | INTEGER NOT NULL |
| Unique (internal) id for book | ||
| 2 | TITLE | VARCHAR(255) NOT NULL |
| Book title | ||
| 3 | DESCRIPTION | VARCHAR(255) |
| Book description (Usually the blurb from the book jacket or promotional materials) | ||
| 4 | PUBLISHERID | INTEGER NOT NULL |
| Foreign key to the book publisher | ||
| 5 | PUBLICATIONDATE | DATE |
| Book publication date | ||
| 6 | PRICE | DOUBLE(64, 0) |
| Current price for the book | ||
| 7 | PREVIOUSEDITIONID | INTEGER |
| Primary Key | ||
| PK_BOOKS | [primary key] | |
| 1 | ID | ascending |
| Foreign Keys | ||
| SYS_FK_10128 | [foreign key, with no action] | |
| 1 | ID ←(0..many) PUBLIC.BOOKS.BOOKAUTHORS.BOOKID | |
| FK_PREVIOUSEDITION | [foreign key, with no action] | |
| 1 | ID ←(0..1) PREVIOUSEDITIONID | |
| Indexes | ||
| SYS_IDX_PK_BOOKS_10119 | [unique index] | |
| 1 | ID | ascending |
| SYS_IDX_U_PREVIOUSEDITION_10125 | [unique index] | |
| 7 | PREVIOUSEDITIONID | ascending |
| SYS_IDX_FK_PREVIOUSEDITION_10123 | [non-unique index] | |
| 7 | PREVIOUSEDITIONID | ascending |
| Table Constraints | ||
| U_PREVIOUSEDITION | [unique constraint] | |
| 7 | PREVIOUSEDITIONID | |
| SYS_CT_10116 | [check constraint] | |
| 1 | ID | |
| BOOKS.BOOKS.ID IS NOT NULL | ||
| SYS_CT_10117 | [check constraint] | |
| 2 | TITLE | |
| BOOKS.BOOKS.TITLE IS NOT NULL | ||
| SYS_CT_10118 | [check constraint] | |
| 4 | PUBLISHERID | |
| BOOKS.BOOKS.PUBLISHERID IS NOT NULL | ||
| Privileges and Grants | ||
| DELETE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| INSERT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| REFERENCES | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| SELECT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| TRIGGER | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| UPDATE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| 1 | ID | INTEGER NOT NULL |
| 2 | DATA | CLOB |
| 3 | COUPONS | INTEGER ARRAY |
| 4 | BOOKS | VARCHAR(20) ARRAY[10] |
| Primary Key | ||
| PK_COUPONS | [primary key] | |
| 1 | ID | ascending |
| Indexes | ||
| SYS_IDX_PK_COUPONS_10093 | [unique index] | |
| 1 | ID | ascending |
| Table Constraints | ||
| SYS_CT_10092 | [check constraint] | |
| 1 | ID | |
| BOOKS.COUPONS.ID IS NOT NULL | ||
| Privileges and Grants | ||
| DELETE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| INSERT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| REFERENCES | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| SELECT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| TRIGGER | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| UPDATE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| 1 | ID | INTEGER NOT NULL |
| 2 | DATA | VALID_STRING(20) |
| Primary Key | ||
| PK_CUSTOMERDATA | [primary key] | |
| 1 | ID | ascending |
| Indexes | ||
| SYS_IDX_PK_CUSTOMERDATA_10104 | [unique index] | |
| 1 | ID | ascending |
| Table Constraints | ||
| SYS_CT_10103 | [check constraint] | |
| 1 | ID | |
| BOOKS.CUSTOMERDATA.ID IS NOT NULL | ||
| Privileges and Grants | ||
| DELETE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| INSERT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| REFERENCES | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| SELECT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| TRIGGER | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| UPDATE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| 1 | ID | INTEGER NOT NULL |
| 2 | FIRSTNAME | NAME_TYPE NOT NULL |
| 3 | LASTNAME | NAME_TYPE NOT NULL |
| 4 | AGE | AGE_TYPE |
| Primary Key | ||
| PK_CUSTOMERS | [primary key] | |
| 1 | ID | ascending |
| Indexes | ||
| SYS_IDX_PK_CUSTOMERS_10098 | [unique index] | |
| 1 | ID | ascending |
| Table Constraints | ||
| SYS_CT_10095 | [check constraint] | |
| 1 | ID | |
| BOOKS.CUSTOMERS.ID IS NOT NULL | ||
| SYS_CT_10096 | [check constraint] | |
| 2 | FIRSTNAME | |
| BOOKS.CUSTOMERS.FIRSTNAME IS NOT NULL | ||
| SYS_CT_10097 | [check constraint] | |
| 3 | LASTNAME | |
| BOOKS.CUSTOMERS.LASTNAME IS NOT NULL | ||
| Privileges and Grants | ||
| DELETE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| INSERT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| REFERENCES | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| SELECT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| TRIGGER | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| UPDATE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| 1 | "Global Count" | INTEGER |
| 2 | "UPDATE" | VARCHAR(20) |
| Privileges and Grants | ||
| DELETE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| INSERT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| REFERENCES | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| SELECT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| TRIGGER | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| UPDATE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| List of book publishers | ||
| 1 | ID | INTEGER NOT NULL |
| auto-incremented | ||
| Unique (internal) id for book publisher | ||
| 2 | PUBLISHER | VARCHAR(255) |
| Name of book publisher | ||
| Primary Key | ||
| SYS_PK_10106 | [primary key] | |
| 1 | ID | ascending |
| Foreign Keys | ||
| FK_ΒΙΒΛΊΑ_PUBLISHERS | [foreign key, with no action] | |
| 1 | ID ←(0..many) PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ | |
| Indexes | ||
| SYS_IDX_SYS_PK_10106_10107 | [unique index] | |
| 1 | ID | ascending |
| Privileges and Grants | ||
| DELETE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| INSERT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| REFERENCES | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| SELECT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| TRIGGER | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| UPDATE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| 1 | ΜΟΝΑΔΙΚΌΣ | SMALLINT NOT NULL |
| 2 | ΤΊΤΛΟΣ | VARCHAR(255) NOT NULL |
| 3 | ΠΕΡΙΓΡΑΦΉ | VARCHAR(255) |
| 4 | ΕΚΔΌΤΗΣ | SMALLINT NOT NULL |
| Primary Key | ||
| PK_ΒΙΒΛΊΑ | [primary key] | |
| 1 | ΜΟΝΑΔΙΚΌΣ | ascending |
| Foreign Keys | ||
| FK_ΒΙΒΛΊΑ_PUBLISHERS | [foreign key, with no action] | |
| 1 | ΕΚΔΌΤΗΣ (0..many)→ PUBLIC.BOOKS.PUBLISHERS.ID | |
| Indexes | ||
| SYS_IDX_FK_ΒΙΒΛΊΑ_PUBLISHERS_10144 | [non-unique index] | |
| 4 | ΕΚΔΌΤΗΣ | ascending |
| SYS_IDX_PK_ΒΙΒΛΊΑ_10140 | [unique index] | |
| 1 | ΜΟΝΑΔΙΚΌΣ | ascending |
| Table Constraints | ||
| SYS_CT_10137 | [check constraint] | |
| 1 | ΜΟΝΑΔΙΚΌΣ | |
| BOOKS.ΒΙΒΛΊΑ.ΜΟΝΑΔΙΚΌΣ IS NOT NULL | ||
| SYS_CT_10138 | [check constraint] | |
| 2 | ΤΊΤΛΟΣ | |
| BOOKS.ΒΙΒΛΊΑ.ΤΊΤΛΟΣ IS NOT NULL | ||
| SYS_CT_10139 | [check constraint] | |
| 4 | ΕΚΔΌΤΗΣ | |
| BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ IS NOT NULL | ||
| Privileges and Grants | ||
| DELETE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| INSERT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| REFERENCES | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| SELECT | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| TRIGGER | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| UPDATE | [privilege] | |
| _SYSTEM → SA (grantable) | ||
| 1 | CITY | VARCHAR(50) NOT NULL |
| 2 | STATE | VARCHAR(2) NOT NULL |
| 3 | POSTALCODE | VARCHAR(10) NOT NULL |
| 4 | COUNTRY | VARCHAR(50) NOT NULL |
| Primary Key | ||
| PK_CUSTOMERS | [primary key] | |
| 3 | POSTALCODE | ascending |
| 4 | COUNTRY | ascending |
| Foreign Keys | ||
| FK_SALES_REGIONS | [foreign key, with no action] | |
| 1 | POSTALCODE ←(0..many) PUBLIC."PUBLISHER SALES".SALES.POSTALCODE | |
| 2 | COUNTRY ←(0..many) PUBLIC."PUBLISHER SALES".SALES.COUNTRY | |
| Indexes | ||
| SYS_IDX_PK_CUSTOMERS_10227 | [unique index] | |
| 3 | POSTALCODE | ascending |
| 4 | COUNTRY | ascending |
| Table Constraints | ||
| SYS_CT_10223 | [check constraint] | |
| 1 | CITY | |
| "PUBLISHER SALES".REGIONS.CITY IS NOT NULL | ||
| SYS_CT_10224 | [check constraint] | |
| 2 | STATE | |
| "PUBLISHER SALES".REGIONS.STATE IS NOT NULL | ||
| SYS_CT_10225 | [check constraint] | |
| 3 | POSTALCODE | |
| "PUBLISHER SALES".REGIONS.POSTALCODE IS NOT NULL | ||
| SYS_CT_10226 | [check constraint] | |
| 4 | COUNTRY | |
| "PUBLISHER SALES".REGIONS.COUNTRY IS NOT NULL | ||
| Privileges and Grants | ||
| DELETE | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| INSERT | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| REFERENCES | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| SELECT | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| TRIGGER | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| UPDATE | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| 1 | POSTALCODE | VARCHAR(10) NOT NULL |
| 2 | COUNTRY | VARCHAR(50) NOT NULL |
| 3 | BOOKID | INTEGER |
| 4 | PERIODENDDATE | DATE |
| 5 | TOTALAMOUNT | DOUBLE(64, 0) |
| 6 | SALESDATAID | INTEGER |
| Foreign Keys | ||
| FK_SALES_SALESDATA | [foreign key, with no action] | |
| 1 | SALESDATAID (0..many)→ PUBLIC."PUBLISHER SALES".SALESDATA.SALESDATAID | |
| FK_SALES_REGIONS | [foreign key, with no action] | |
| 1 | POSTALCODE (0..many)→ PUBLIC."PUBLISHER SALES".REGIONS.POSTALCODE | |
| 2 | COUNTRY (0..many)→ PUBLIC."PUBLISHER SALES".REGIONS.COUNTRY | |
| Indexes | ||
| SYS_IDX_FK_SALES_SALESDATA_10241 | [non-unique index] | |
| 6 | SALESDATAID | ascending |
| SYS_IDX_FK_SALES_REGIONS_10239 | [non-unique index] | |
| 1 | POSTALCODE | ascending |
| 2 | COUNTRY | ascending |
| Table Constraints | ||
| SYS_CT_10234 | [check constraint] | |
| 1 | POSTALCODE | |
| "PUBLISHER SALES".SALES.POSTALCODE IS NOT NULL | ||
| SYS_CT_10235 | [check constraint] | |
| 2 | COUNTRY | |
| "PUBLISHER SALES".SALES.COUNTRY IS NOT NULL | ||
| Privileges and Grants | ||
| DELETE | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| INSERT | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| REFERENCES | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| SELECT | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| TRIGGER | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| UPDATE | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| 1 | SALESDATAID | INTEGER |
| 2 | YEARLYAMOUNT | DOUBLE(64, 0) |
| Foreign Keys | ||
| FK_SALES_SALESDATA | [foreign key, with no action] | |
| 1 | SALESDATAID ←(0..many) PUBLIC."PUBLISHER SALES".SALES.SALESDATAID | |
| Indexes | ||
| SYS_IDX_UQ_CUSTOMERS_10233 | [unique index] | |
| 1 | SALESDATAID | ascending |
| Table Constraints | ||
| UQ_CUSTOMERS | [unique constraint] | |
| 1 | SALESDATAID | |
| Privileges and Grants | ||
| DELETE | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| INSERT | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| REFERENCES | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| SELECT | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| TRIGGER | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| UPDATE | [privilege] | |
| _SYSTEM → DBA (grantable) | ||
| 2 | PUBLISHER | CHARACTER VARYING, out |
| [specific name] | ||
| NEW_PUBLISHER_FORCE_VALUE | ||
| Definition | ||
| [definition] | ||
| CREATE PROCEDURE BOOKS.NEW_PUBLISHER(OUT PUBLISHER VARCHAR(50)) SPECIFIC NEW_PUBLISHER_FORCE_VALUE LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL NEW SAVEPOINT LEVEL SET PUBLISHER = 'New Publisher' | ||
| 2 | NEWPUBLISHER | CHARACTER VARYING, in |
| 3 | PUBLISHER | CHARACTER VARYING, out |
| [specific name] | ||
| NEW_PUBLISHER_10160 | ||
| Definition | ||
| [definition] | ||
| CREATE PROCEDURE BOOKS.NEW_PUBLISHER(IN NEWPUBLISHER VARCHAR(50),OUT PUBLISHER VARCHAR(50)) SPECIFIC NEW_PUBLISHER_10160 LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL NEW SAVEPOINT LEVEL SET PUBLISHER = NEWPUBLISHER | ||
| 2 | ONE | INTEGER, in |
| [specific name] | ||
| CUSTOMADD_10162 | ||
| Definition | ||
| [definition] | ||
| CREATE FUNCTION BOOKS.CUSTOMADD(IN ONE INTEGER) RETURNS INTEGER SPECIFIC CUSTOMADD_10162 LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL CALLED ON NULL INPUT RETURN BOOKS.CUSTOMADD(ONE,1) | ||
| 2 | ONE | INTEGER, in |
| 3 | TWO | INTEGER, in |
| [specific name] | ||
| CUSTOMADD_10161 | ||
| Definition | ||
| [definition] | ||
| CREATE FUNCTION BOOKS.CUSTOMADD(IN ONE INTEGER,IN TWO INTEGER) RETURNS INTEGER SPECIFIC CUSTOMADD_10161 LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL CALLED ON NULL INPUT RETURN ONE+TWO | ||
| increment | 1 | |
| minimum value | -2147483648 | |
| maximum value | 2147483647 | |
| cycle | false |
| BIGINT | [data type] | |
| defined with no parameters | ||
| nullable | ||
| auto-incrementable | ||
| searchable except with where .. like | ||
| BINARY | [data type] | |
| defined with LENGTH | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| BIT | [data type] | |
| defined with LENGTH | ||
| nullable | ||
| not auto-incrementable | ||
| searchable except with where .. like | ||
| BLOB | [data type] | |
| defined with LENGTH | ||
| nullable | ||
| not auto-incrementable | ||
| not searchable | ||
| BOOLEAN | [data type] | |
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable except with where .. like | ||
| CHARACTER | [data type] | |
| defined with LENGTH | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| CLOB | [data type] | |
| defined with LENGTH | ||
| nullable | ||
| not auto-incrementable | ||
| not searchable | ||
| DATE | [data type] | |
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable except with where .. like | ||
| DECIMAL | [data type] | |
| defined with PRECISION,SCALE | ||
| nullable | ||
| auto-incrementable | ||
| searchable except with where .. like | ||
| DOUBLE | [data type] | |
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable except with where .. like | ||
| FLOAT | [data type] | |
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable except with where .. like | ||
| INTEGER | [data type] | |
| defined with no parameters | ||
| nullable | ||
| auto-incrementable | ||
| searchable except with where .. like | ||
| NUMERIC | [data type] | |
| defined with PRECISION,SCALE | ||
| nullable | ||
| auto-incrementable | ||
| searchable except with where .. like | ||
| NVARCHAR | [data type] | |
| defined with LENGTH | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| OTHER | [data type] | |
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable except with where .. like | ||
| REAL | [data type] | |
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable except with where .. like | ||
| SMALLINT | [data type] | |
| defined with no parameters | ||
| nullable | ||
| auto-incrementable | ||
| searchable except with where .. like | ||
| TIME | [data type] | |
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable except with where .. like | ||
| TIMESTAMP | [data type] | |
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable except with where .. like | ||
| TINYINT | [data type] | |
| defined with no parameters | ||
| nullable | ||
| auto-incrementable | ||
| searchable except with where .. like | ||
| UUID | [data type] | |
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| VARBINARY | [data type] | |
| defined with LENGTH | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| VARCHAR | [data type] | |
| defined with LENGTH | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| PUBLIC.BOOKS.AGE_TYPE | [user defined data type] | |
| defined with no parameters | ||
| not nullable | ||
| not auto-incrementable | ||
| not searchable | ||
| based on | SMALLINT | |
| PUBLIC.BOOKS."CHARACTER VARYING" | [data type] | |
| defined with no parameters | ||
| not nullable | ||
| not auto-incrementable | ||
| not searchable | ||
| PUBLIC.BOOKS."INTEGER ARRAY" | [data type] | |
| defined with no parameters | ||
| not nullable | ||
| not auto-incrementable | ||
| not searchable | ||
| PUBLIC.BOOKS.NAME_TYPE | [user defined data type] | |
| defined with no parameters | ||
| not nullable | ||
| not auto-incrementable | ||
| not searchable | ||
| based on | NVARCHAR | |
| PUBLIC.BOOKS.VALID_STRING | [data type] | |
| defined with no parameters | ||
| not nullable | ||
| not auto-incrementable | ||
| not searchable | ||
| PUBLIC.BOOKS."VARCHAR(20) ARRAY[10]" | [data type] | |
| defined with no parameters | ||
| not nullable | ||
| not auto-incrementable | ||
| not searchable | ||
| product name | SchemaCrawler |
| product version | 16.1.2 |
| database product name | HSQL Database Engine |
| database product version | 2.5.0 |
| database user name | SA |
| all procedures are callable | true |
| all tables are selectable | true |
| auto commit failure closes all result sets | false |
| catalog separator | . |
| catalog term | CATALOG |
| catalogs | PUBLIC |
| client info properties | files_readonly, hsqldb.applog, hsqldb.cache_file_scale, hsqldb.cache_free_count, hsqldb.cache_rows, hsqldb.cache_size, hsqldb.default_table_type, hsqldb.defrag_limit, hsqldb.digest, hsqldb.files_space, hsqldb.full_log_replay, hsqldb.inc_backup, hsqldb.large_data, hsqldb.lob_compressed, hsqldb.lob_file_scale, hsqldb.lock_file, hsqldb.log_data, hsqldb.log_size, hsqldb.min_reuse, hsqldb.nio_data_file, hsqldb.nio_max_size, hsqldb.result_max_memory_rows, hsqldb.script_format, hsqldb.sqllog, hsqldb.temp_directory, hsqldb.tx, hsqldb.tx_conflict_rollback, hsqldb.tx_interrupt_rollback, hsqldb.tx_level, hsqldb.write_delay, hsqldb.write_delay_millis, jdbc.translate_tti_types, readonly, runtime.gc_interval, sql.avg_scale, sql.char_literal, sql.compare_in_locale, sql.concat_nulls, sql.convert_trunc, sql.double_nan, sql.enforce_names, sql.enforce_refs, sql.enforce_size, sql.enforce_tdc_delete, sql.enforce_tdc_update, sql.enforce_types, sql.ignore_case, sql.live_object, sql.longvar_is_lob, sql.nulls_first, sql.nulls_order, sql.pad_space, sql.ref_integrity, sql.regular_names, sql.restrict_exec, sql.syntax_db2, sql.syntax_mss, sql.syntax_mys, sql.syntax_ora, sql.syntax_pgs, sql.sys_index_names, sql.unique_nulls, textdb.all_quoted, textdb.cache_rows, textdb.cache_scale, textdb.cache_size, textdb.cache_size_scale, textdb.encoding, textdb.fs, textdb.ignore_first, textdb.lvs, textdb.qc, textdb.quoted, textdb.vs |
| data definition causes transaction commit | true |
| data definition ignored in transactions | false |
| database major version | 2 |
| database minor version | 5 |
| default transaction isolation | 2 |
| deletes are detected for TYPE_FORWARD_ONLY result sets | false |
| deletes are detected for TYPE_SCROLL_INSENSITIVE result sets | false |
| deletes are detected for TYPE_SCROLL_SENSITIVE result sets | false |
| does max row size include blobs | true |
| driver major version | 2 |
| driver minor version | 5 |
| extra name characters | |
| generated key always returned | true |
| identifier quote string | " |
| inserts are detected for TYPE_FORWARD_ONLY result sets | false |
| inserts are detected for TYPE_SCROLL_INSENSITIVE result sets | false |
| inserts are detected for TYPE_SCROLL_SENSITIVE result sets | false |
| is catalog at start | true |
| is read only | false |
| JDBC major version | 4 |
| JDBC minor version | 2 |
| locators update copy | false |
| max binary literal length | 0 |
| max catalog name length | 128 |
| max char literal length | 0 |
| max column name length | 128 |
| max columns in group by | 0 |
| max columns in index | 0 |
| max columns in order by | 0 |
| max columns in select | 0 |
| max columns in table | 0 |
| max connections | 0 |
| max cursor name length | 128 |
| max index length | 0 |
| max logical lob size | 1099511627776 |
| max procedure name length | 128 |
| max row size | 0 |
| max schema name length | 128 |
| max statement length | 0 |
| max statements | 0 |
| max table name length | 128 |
| max tables in select | 0 |
| max user name length | 128 |
| null plus non null is null | true |
| nulls are sorted at end | false |
| nulls are sorted at start | true |
| nulls are sorted high | false |
| nulls are sorted low | false |
| numeric functions | ABS, ACOS, ASIN, ATAN, ATAN2, BITAND, BITOR, BITXOR, CEILING, COS, COT, DEGREES, EXP, FLOOR, LOG, LOG10, MOD, PI, POWER, RADIANS, RAND, ROUND, ROUNDMAGIC, SIGN, SIN, SQRT, TAN, TRUNCATE |
| others deletes are visible for TYPE_FORWARD_ONLY result sets | false |
| others deletes are visible for TYPE_SCROLL_INSENSITIVE result sets | false |
| others deletes are visible for TYPE_SCROLL_SENSITIVE result sets | false |
| others inserts are visible for TYPE_FORWARD_ONLY result sets | false |
| others inserts are visible for TYPE_SCROLL_INSENSITIVE result sets | false |
| others inserts are visible for TYPE_SCROLL_SENSITIVE result sets | false |
| others updates are visible for TYPE_FORWARD_ONLY result sets | false |
| others updates are visible for TYPE_SCROLL_INSENSITIVE result sets | false |
| others updates are visible for TYPE_SCROLL_SENSITIVE result sets | false |
| own deletes are visible for TYPE_FORWARD_ONLY result sets | false |
| own deletes are visible for TYPE_SCROLL_INSENSITIVE result sets | false |
| own deletes are visible for TYPE_SCROLL_SENSITIVE result sets | false |
| own inserts are visible for TYPE_FORWARD_ONLY result sets | false |
| own inserts are visible for TYPE_SCROLL_INSENSITIVE result sets | false |
| own inserts are visible for TYPE_SCROLL_SENSITIVE result sets | false |
| own updates are visible for TYPE_FORWARD_ONLY result sets | false |
| own updates are visible for TYPE_SCROLL_INSENSITIVE result sets | false |
| own updates are visible for TYPE_SCROLL_SENSITIVE result sets | false |
| procedure term | PROCEDURE |
| result set holdability | 1 |
| row id lifetime | ROWID_UNSUPPORTED |
| schema term | SCHEMA |
| schemas | BOOKS, FOR_LINT, INFORMATION_SCHEMA, PUBLIC, PUBLISHER SALES, SYSTEM_LOBS |
| search string escape | \ |
| SQL keywords | |
| SQL state type | 2 |
| stores lower case identifiers | false |
| stores lower case quoted identifiers | false |
| stores mixed case identifiers | false |
| stores mixed case quoted identifiers | false |
| stores upper case identifiers | true |
| stores upper case quoted identifiers | false |
| string functions | ASCII, CHAR, CONCAT, DIFFERENCE, HEXTORAW, INSERT, LCASE, LEFT, LENGTH, LOCATE, LTRIM, RAWTOHEX, REPEAT, REPLACE, RIGHT, RTRIM, SOUNDEX, SPACE, SUBSTR, UCASE |
| supports alter table with add column | true |
| supports alter table with drop column | true |
| supports ANSI92 entry level SQL | true |
| supports ANSI92 full SQL | true |
| supports ANSI92 intermediate SQL | true |
| supports batch updates | true |
| supports catalogs in data manipulation | true |
| supports catalogs in index definitions | true |
| supports catalogs in privilege definitions | true |
| supports catalogs in procedure calls | true |
| supports catalogs in table definitions | true |
| supports column aliasing | true |
| supports convert | true |
| supports core SQL grammar | true |
| supports correlated subqueries | true |
| supports data definition and data manipulation transactions | false |
| supports data manipulation transactions only | true |
| supports different table correlation names | false |
| supports expressions in order by | true |
| supports extended SQL grammar | true |
| supports full outer joins | true |
| supports get generated keys | true |
| supports group by | true |
| supports group by beyond select | true |
| supports group by unrelated | true |
| supports integrity enhancement facility | true |
| supports like escape clause | true |
| supports limited outer joins | true |
| supports minimum SQL grammar | true |
| supports mixed case identifiers | false |
| supports mixed case quoted identifiers | true |
| supports multiple open results | true |
| supports multiple result sets | true |
| supports multiple transactions | true |
| supports named parameters | true |
| supports non nullable columns | true |
| supports open cursors across commit | true |
| supports open cursors across rollback | false |
| supports open statements across commit | true |
| supports open statements across rollback | true |
| supports order by unrelated | true |
| supports outer joins | true |
| supports positioned delete | true |
| supports positioned update | true |
| supports ref cursors | false |
| supports result set type for TYPE_FORWARD_ONLY result sets | true |
| supports result set type for TYPE_SCROLL_INSENSITIVE result sets | true |
| supports result set type for TYPE_SCROLL_SENSITIVE result sets | false |
| supports savepoints | true |
| supports schemas in data manipulation | true |
| supports schemas in index definitions | true |
| supports schemas in privilege definitions | true |
| supports schemas in procedure calls | true |
| supports schemas in table definitions | true |
| supports select for update | true |
| supports statement pooling | true |
| supports stored functions using call syntax | true |
| supports stored procedures | true |
| supports subqueries in comparisons | true |
| supports subqueries in exists | true |
| supports subqueries in ins | true |
| supports subqueries in quantifieds | true |
| supports table correlation names | true |
| supports transactions | true |
| supports union | true |
| supports union all | true |
| system functions | DATABASE, IFNULL, USER |
| table types | GLOBAL TEMPORARY, SYSTEM TABLE, TABLE, VIEW |
| time date functions | CURDATE, CURTIME, DATEDIFF, DAYNAME, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, HOUR, MINUTE, MONTH, MONTHNAME, NOW, QUARTER, SECOND, SECONDS_SINCE_MIDNIGHT, TIMESTAMPADD, TIMESTAMPDIFF, TO_CHAR, WEEK, YEAR |
| type info | BIT, TINYINT, BIGINT, VARBINARY, BINARY, UUID, CHARACTER, NUMERIC, DECIMAL, INTEGER, SMALLINT, DOUBLE, FLOAT, REAL, NVARCHAR, VARCHAR, BOOLEAN, DATE, TIME, TIMESTAMP, OTHER, BLOB, CLOB |
| updates are detected for TYPE_FORWARD_ONLY result sets | false |
| updates are detected for TYPE_SCROLL_INSENSITIVE result sets | false |
| updates are detected for TYPE_SCROLL_SENSITIVE result sets | false |
| uses local file per table | false |
| uses local files | false |
| driver name | HSQL Database Engine Driver |
| driver version | 2.5.0 |
| driver class name | org.hsqldb.jdbc.JDBCDriver |
| url | jdbc:hsqldb:hsql://0.0.0.0:56161/schemacrawler56161 |
| is JDBC compliant | true |
| default_schema | [driver property] | |
| not required; choices [false, true] | ||
| value | false | |
| get_column_name | [driver property] | |
| not required; choices [false, true] | ||
| value | true | |
| ifexists | [driver property] | |
| not required; choices [false, true] | ||
| value | false | |
| password | [driver property] | |
| required | ||
| value | NULL | |
| shutdown | [driver property] | |
| not required; choices [false, true] | ||
| value | false | |
| user | [driver property] | |
| required | ||
| value | NULL | |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| ID | DATA |
|---|
| ID | FIRSTNAME | LASTNAME | AGE |
|---|
| Global Count | UPDATE |
|---|---|
| 1 | Abbot |
| 2 | Alexis |
| 3 | Jasmine |
| 4 | NULL |
| 5 | Teagan |
| 6 | Stella |
| 7 | Alden |
| 8 | Daniel |
| 9 | NULL |
| 10 | Yetta |
| 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 |
| ΜΟΝΑΔΙΚΌΣ | ΤΊΤΛΟΣ | ΠΕΡΙΓΡΑΦΉ | ΕΚΔΌΤΗΣ |
|---|
| 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 |
| 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 |
| SALESDATAID | YEARLYAMOUNT |
|---|