Details of Example Database

 

System Information

generated by SchemaCrawler 16.15.7
generated on 2021-09-16 21:28:15

 

 

SchemaCrawler_Diagram Details of Example Database generated by SchemaCrawler 16.15.7 generated on 2021-09-16 21:28:15 authors_f521e766 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) • SYS_IDX_PK_AUTHORS_10111 (ID) [unique index] • IDX_B_AUTHORS (LASTNAME, FIRSTNAME) [non-unique index] • IDX_A_AUTHORS (CITY, STATE, POSTALCODE, COUNTRY) [non-unique index] bookauthors_ead84c5d 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) • SYS_IDX_Z_FK_AUTHOR_10134 (AUTHORID) [non-unique index] • SYS_IDX_SYS_FK_10128_10132 (BOOKID) [non-unique index] • UIDX_BOOKAUTHORS (BOOKID, AUTHORID) [unique index] bookauthors_ead84c5d:w->authors_f521e766:e Z_FK_AUTHOR books_f4a675c8 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 • SYS_IDX_PK_BOOKS_10119 (ID) [unique index] • SYS_IDX_U_PREVIOUSEDITION_10125 (PREVIOUSEDITIONID) [unique index] • SYS_IDX_FK_PREVIOUSEDITION_10123 (PREVIOUSEDITIONID) [non-unique index] bookauthors_ead84c5d:w->books_f4a675c8:e SYS_FK_10128 authorslist_9ccb3c04 PUBLIC.BOOKS.AUTHORSLIST [view] ID INTEGER FIRSTNAME VARCHAR(20) LASTNAME VARCHAR(20) books_f4a675c8:w->books_f4a675c8:e FK_PREVIOUSEDITION coupons_54c3042b PUBLIC.BOOKS.COUPONS [table] ID INTEGER NOT NULL DATA CLOB COUPONS INTEGER ARRAY BOOKS VARCHAR(20) ARRAY[10] • SYS_IDX_PK_COUPONS_10093 (ID) [unique index] customerdata_b0af83c6 PUBLIC.BOOKS.CUSTOMERDATA [table] ID INTEGER NOT NULL DATA VALID_STRING(20) • SYS_IDX_PK_CUSTOMERDATA_10104 (ID) [unique index] customers_f705d773 PUBLIC.BOOKS.CUSTOMERS [table] ID INTEGER NOT NULL FIRSTNAME NAME_TYPE NOT NULL LASTNAME NAME_TYPE NOT NULL AGE AGE_TYPE • SYS_IDX_PK_CUSTOMERS_10098 (ID) [unique index] globalcounts_7fcacf9f PUBLIC.BOOKS."Global Counts" [table] "Global Count" INTEGER "UPDATE" VARCHAR(20) publishers_8037d535 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 • SYS_IDX_SYS_PK_10106_10107 (ID) [unique index] βιβλία_3cecb755 PUBLIC.BOOKS.ΒΙΒΛΊΑ [table] ΜΟΝΑΔΙΚΌΣ SMALLINT NOT NULL ΤΊΤΛΟΣ VARCHAR(255) NOT NULL ΠΕΡΙΓΡΑΦΉ VARCHAR(255) ΕΚΔΌΤΗΣ SMALLINT NOT NULL • SYS_IDX_FK_ΒΙΒΛΊΑ_PUBLISHERS_10144 (ΕΚΔΌΤΗΣ) [non-unique index] • SYS_IDX_PK_ΒΙΒΛΊΑ_10140 (ΜΟΝΑΔΙΚΌΣ) [unique index] βιβλία_3cecb755:w->publishers_8037d535:e FK_ΒΙΒΛΊΑ_PUBLISHERS extra_pk_6ff01a79 PUBLIC.FOR_LINT.EXTRA_PK [table] Extra table with just a primary key WRITERID BIGINT NOT NULL PUBLICATIONID INTEGER NOT NULL ID INTEGER NOT NULL • SYS_IDX_FK_WRITER_JOIN_10201 (WRITERID) [non-unique index] • SYS_IDX_PK_EXTRA_PK_10197 (ID) [unique index] • SYS_IDX_FK_PUBLICATION_JOIN_10203 (PUBLICATIONID) [non-unique index] publications_6ef89996 PUBLIC.FOR_LINT.PUBLICATIONS [table] ID INTEGER NOT NULL TITLE VARCHAR(255) NOT NULL Publication title DESCRIPTION VARCHAR(255) WRITERID BIGINT NOT NULL PUBLICATIONDATE DATE PRICE DOUBLE(64, 0) "UPDATE" CLOB PRESS_RELEASE CLOB • SYS_IDX_FK_PUBLICATIONS_WRITER_10182 (WRITERID) [non-unique index] • SYS_IDX_PK_PUBLICATIONS_10178 (ID) [unique index] extra_pk_6ff01a79:w->publications_6ef89996:e FK_PUBLICATION_JOIN writers_3778840f PUBLIC.FOR_LINT.WRITERS [table] ID BIGINT NOT NULL FIRSTNAME VARCHAR(20) NOT NULL LASTNAME VARCHAR(20) NOT NULL ADDRESS1 VARCHAR(255) ADDRESS2 VARCHAR(255) NOT NULL CITY VARCHAR(50) STATE VARCHAR(2) POSTALCODE VARCHAR(10) COUNTRY VARCHAR(50) PHONE1 VARCHAR(10) PHONE2 VARCHAR(15) EMAIL1 VARCHAR(10) EMAIL2 INTEGER FAX VARCHAR(10) FAX3 INTEGER HOMEEMAIL11 VARCHAR(10) HOMEEMAIL12 VARCHAR(10) PUBLICATION_ID BIGINT NOT NULL • SYS_IDX_PK_WRITERS_10168 (ID) [unique index] • SYS_IDX_FK_WRITERS_PUBLICATION_10213 (PUBLICATION_ID) [non-unique index] • IDX_A1_WRITERS (CITY, STATE) [non-unique index] • IDX_U_WRITERS (EMAIL1, COUNTRY) [unique index] • IDX_B_WRITERS (LASTNAME, FIRSTNAME) [non-unique index] • IDX_A_WRITERS (CITY, STATE, POSTALCODE, COUNTRY) [non-unique index] extra_pk_6ff01a79:w->writers_3778840f:e FK_WRITER_JOIN globalcounts_3c0c9230 PUBLIC.FOR_LINT."Global Counts" [table] "Global Count" INTEGER publications_6ef89996:w->writers_3778840f:e FK_PUBLICATIONS_WRITER publicationwriters_f68ea883 PUBLIC.FOR_LINT.PUBLICATIONWRITERS [table] PUBLICATIONID INTEGER NOT NULL WRITERID BIGINT NOT NULL • SYS_IDX_FK_WRITER_10189 (WRITERID) [non-unique index] • SYS_IDX_FK_PUBLICATION_10191 (PUBLICATIONID) [non-unique index] publicationwriters_f68ea883:w->publications_6ef89996:e FK_PUBLICATION publicationwriters_f68ea883:w->writers_3778840f:e FK_WRITER writers_3778840f:w->publications_6ef89996:e FK_WRITERS_PUBLICATION selfreference_836b0b2e PUBLIC.FOR_LINT.SELFREFERENCE [table] ID INTEGER NOT NULL TITLE VARCHAR(255) NOT NULL • SYS_IDX_PK_SELFREFERENCE_10207 (ID) [unique index] • SYS_IDX_FK_SELFREFERENCE_10210 (ID) [non-unique index] selfreference_836b0b2e:w->selfreference_836b0b2e:e FK_SELFREFERENCE regions_dbf65bbf 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 • SYS_IDX_PK_CUSTOMERS_10227 (POSTALCODE, COUNTRY) [unique index] sales_751e68cc 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 • SYS_IDX_FK_SALES_SALESDATA_10241 (SALESDATAID) [non-unique index] • SYS_IDX_FK_SALES_REGIONS_10239 (POSTALCODE, COUNTRY) [non-unique index] sales_751e68cc:w->regions_dbf65bbf:e FK_SALES_REGIONS sales_751e68cc:w->regions_dbf65bbf:e FK_SALES_REGIONS salesdata_1193fa76 PUBLIC."PUBLISHER SALES".SALESDATA [table] SALESDATAID INTEGER YEARLYAMOUNT DOUBLE(64, 0) • SYS_IDX_UQ_CUSTOMERS_10233 (SALESDATAID) [unique index] sales_751e68cc:w->salesdata_1193fa76:e FK_SALES_SALESDATA

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
PK_AUTHORS [primary key]
ID
Foreign Keys
Z_FK_AUTHOR [foreign key, with no action]
ID ←(0..many) PUBLIC.BOOKS.BOOKAUTHORS.AUTHORID
Indexes
SYS_IDX_PK_AUTHORS_10111 [unique index]
ID ascending
IDX_B_AUTHORS [non-unique index]
LASTNAME ascending
FIRSTNAME ascending
IDX_A_AUTHORS [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_UPPERCASE_STATE [check constraint]
STATE
BOOKS.AUTHORS.STATE=UPPER(BOOKS.AUTHORS.STATE)
SYS_CT_10108 [check constraint]
ID
BOOKS.AUTHORS.ID IS NOT NULL
SYS_CT_10109 [check constraint]
FIRSTNAME
BOOKS.AUTHORS.FIRSTNAME IS NOT NULL
SYS_CT_10110 [check constraint]
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]
SA → OTHERUSER
_SYSTEM → SA (grantable)
TRIGGER [privilege]
_SYSTEM → SA (grantable)
UPDATE [privilege]
_SYSTEM → SA (grantable)

 

PUBLIC.BOOKS.AUTHORSLIST [view]
ID INTEGER
FIRSTNAME VARCHAR(20)
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
Table Usage
PUBLIC.BOOKS.AUTHORS [table]

 

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
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
Indexes
SYS_IDX_Z_FK_AUTHOR_10134 [non-unique index]
AUTHORID ascending
SYS_IDX_SYS_FK_10128_10132 [non-unique index]
BOOKID ascending
UIDX_BOOKAUTHORS [unique index]
BOOKID ascending
AUTHORID ascending
Table Constraints
SYS_CT_10126 [check constraint]
BOOKID
BOOKS.BOOKAUTHORS.BOOKID IS NOT NULL
SYS_CT_10127 [check constraint]
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)

 

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
PK_BOOKS [primary key]
ID
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
Indexes
SYS_IDX_PK_BOOKS_10119 [unique index]
ID ascending
SYS_IDX_U_PREVIOUSEDITION_10125 [unique index]
PREVIOUSEDITIONID ascending
SYS_IDX_FK_PREVIOUSEDITION_10123 [non-unique index]
PREVIOUSEDITIONID ascending
Table Constraints
U_PREVIOUSEDITION [unique constraint]
PREVIOUSEDITIONID
SYS_CT_10116 [check constraint]
ID
BOOKS.BOOKS.ID IS NOT NULL
SYS_CT_10117 [check constraint]
TITLE
BOOKS.BOOKS.TITLE IS NOT NULL
SYS_CT_10118 [check constraint]
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)

 

PUBLIC.BOOKS.COUPONS [table]
ID INTEGER NOT NULL
DATA CLOB
COUPONS INTEGER ARRAY
BOOKS VARCHAR(20) ARRAY[10]
Primary Key
PK_COUPONS [primary key]
ID
Indexes
SYS_IDX_PK_COUPONS_10093 [unique index]
ID ascending
Table Constraints
SYS_CT_10092 [check constraint]
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)

 

PUBLIC.BOOKS.CUSTOMERDATA [table]
ID INTEGER NOT NULL
DATA VALID_STRING(20)
Primary Key
PK_CUSTOMERDATA [primary key]
ID
Indexes
SYS_IDX_PK_CUSTOMERDATA_10104 [unique index]
ID ascending
Table Constraints
SYS_CT_10103 [check constraint]
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)

 

PUBLIC.BOOKS.CUSTOMERS [table]
ID INTEGER NOT NULL
FIRSTNAME NAME_TYPE NOT NULL
LASTNAME NAME_TYPE NOT NULL
AGE AGE_TYPE
Primary Key
PK_CUSTOMERS [primary key]
ID
Indexes
SYS_IDX_PK_CUSTOMERS_10098 [unique index]
ID ascending
Table Constraints
SYS_CT_10095 [check constraint]
ID
BOOKS.CUSTOMERS.ID IS NOT NULL
SYS_CT_10096 [check constraint]
FIRSTNAME
BOOKS.CUSTOMERS.FIRSTNAME IS NOT NULL
SYS_CT_10097 [check constraint]
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)

 

PUBLIC.BOOKS."Global Counts" [table]
"Global Count" INTEGER
"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)

 

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
SYS_PK_10106 [primary key]
ID
Foreign Keys
FK_ΒΙΒΛΊΑ_PUBLISHERS [foreign key, with no action]
ID ←(0..many) PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ
Indexes
SYS_IDX_SYS_PK_10106_10107 [unique index]
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)

 

PUBLIC.BOOKS.ΒΙΒΛΊΑ [table]
ΜΟΝΑΔΙΚΌΣ SMALLINT NOT NULL
ΤΊΤΛΟΣ VARCHAR(255) NOT NULL
ΠΕΡΙΓΡΑΦΉ VARCHAR(255)
ΕΚΔΌΤΗΣ SMALLINT NOT NULL
Primary Key
PK_ΒΙΒΛΊΑ [primary key]
ΜΟΝΑΔΙΚΌΣ
Foreign Keys
FK_ΒΙΒΛΊΑ_PUBLISHERS [foreign key, with no action]
ΕΚΔΌΤΗΣ (0..many)→ PUBLIC.BOOKS.PUBLISHERS.ID
Indexes
SYS_IDX_FK_ΒΙΒΛΊΑ_PUBLISHERS_10144 [non-unique index]
ΕΚΔΌΤΗΣ ascending
SYS_IDX_PK_ΒΙΒΛΊΑ_10140 [unique index]
ΜΟΝΑΔΙΚΌΣ ascending
Table Constraints
SYS_CT_10137 [check constraint]
ΜΟΝΑΔΙΚΌΣ
BOOKS.ΒΙΒΛΊΑ.ΜΟΝΑΔΙΚΌΣ IS NOT NULL
SYS_CT_10138 [check constraint]
ΤΊΤΛΟΣ
BOOKS.ΒΙΒΛΊΑ.ΤΊΤΛΟΣ IS NOT NULL
SYS_CT_10139 [check constraint]
ΕΚΔΌΤΗΣ
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)

 

PUBLIC.FOR_LINT.EXTRA_PK [table]
Extra table with just a primary key
WRITERID BIGINT NOT NULL
PUBLICATIONID INTEGER NOT NULL
ID INTEGER NOT NULL
Primary Key
PK_EXTRA_PK [primary key]
ID
Foreign Keys
FK_PUBLICATION_JOIN [foreign key, with no action]
PUBLICATIONID (0..many)→ PUBLIC.FOR_LINT.PUBLICATIONS.ID
FK_WRITER_JOIN [foreign key, with no action]
WRITERID (0..many)→ PUBLIC.FOR_LINT.WRITERS.ID
Indexes
SYS_IDX_FK_WRITER_JOIN_10201 [non-unique index]
WRITERID ascending
SYS_IDX_PK_EXTRA_PK_10197 [unique index]
ID ascending
SYS_IDX_FK_PUBLICATION_JOIN_10203 [non-unique index]
PUBLICATIONID ascending
Table Constraints
SYS_CT_10194 [check constraint]
WRITERID
FOR_LINT.EXTRA_PK.WRITERID IS NOT NULL
SYS_CT_10195 [check constraint]
PUBLICATIONID
FOR_LINT.EXTRA_PK.PUBLICATIONID IS NOT NULL
SYS_CT_10196 [check constraint]
ID
FOR_LINT.EXTRA_PK.ID 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)

 

PUBLIC.FOR_LINT."Global Counts" [table]
"Global Count" INTEGER
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)

 

PUBLIC.FOR_LINT.PUBLICATIONS [table]
ID INTEGER NOT NULL
TITLE VARCHAR(255) NOT NULL
Publication title
DESCRIPTION VARCHAR(255)
WRITERID BIGINT NOT NULL
PUBLICATIONDATE DATE
PRICE DOUBLE(64, 0)
"UPDATE" CLOB
PRESS_RELEASE CLOB
Primary Key
PK_PUBLICATIONS [primary key]
ID
Foreign Keys
FK_PUBLICATION_JOIN [foreign key, with no action]
ID ←(0..many) PUBLIC.FOR_LINT.EXTRA_PK.PUBLICATIONID
FK_PUBLICATIONS_WRITER [foreign key, with no action]
WRITERID (0..many)→ PUBLIC.FOR_LINT.WRITERS.ID
FK_PUBLICATION [foreign key, with no action]
ID ←(0..many) PUBLIC.FOR_LINT.PUBLICATIONWRITERS.PUBLICATIONID
FK_WRITERS_PUBLICATION [foreign key, with no action]
ID ←(0..many) PUBLIC.FOR_LINT.WRITERS.PUBLICATION_ID
Indexes
SYS_IDX_FK_PUBLICATIONS_WRITER_10182 [non-unique index]
WRITERID ascending
SYS_IDX_PK_PUBLICATIONS_10178 [unique index]
ID ascending
Table Constraints
SYS_CT_10175 [check constraint]
ID
FOR_LINT.PUBLICATIONS.ID IS NOT NULL
SYS_CT_10176 [check constraint]
TITLE
FOR_LINT.PUBLICATIONS.TITLE IS NOT NULL
SYS_CT_10177 [check constraint]
WRITERID
FOR_LINT.PUBLICATIONS.WRITERID 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)

 

PUBLIC.FOR_LINT.PUBLICATIONWRITERS [table]
PUBLICATIONID INTEGER NOT NULL
WRITERID BIGINT NOT NULL
Foreign Keys
FK_PUBLICATION [foreign key, with no action]
PUBLICATIONID (0..many)→ PUBLIC.FOR_LINT.PUBLICATIONS.ID
FK_WRITER [foreign key, with no action]
WRITERID (0..many)→ PUBLIC.FOR_LINT.WRITERS.ID
Indexes
SYS_IDX_FK_WRITER_10189 [non-unique index]
WRITERID ascending
SYS_IDX_FK_PUBLICATION_10191 [non-unique index]
PUBLICATIONID ascending
Table Constraints
SYS_CT_10184 [check constraint]
PUBLICATIONID
FOR_LINT.PUBLICATIONWRITERS.PUBLICATIONID IS NOT NULL
SYS_CT_10185 [check constraint]
WRITERID
FOR_LINT.PUBLICATIONWRITERS.WRITERID 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)

 

PUBLIC.FOR_LINT.SELFREFERENCE [table]
ID INTEGER NOT NULL
TITLE VARCHAR(255) NOT NULL
Primary Key
PK_SELFREFERENCE [primary key]
ID
Foreign Keys
FK_SELFREFERENCE [foreign key, with no action]
ID ←(0..1) ID
Indexes
SYS_IDX_PK_SELFREFERENCE_10207 [unique index]
ID ascending
SYS_IDX_FK_SELFREFERENCE_10210 [non-unique index]
ID ascending
Table Constraints
SYS_CT_10205 [check constraint]
ID
FOR_LINT.SELFREFERENCE.ID IS NOT NULL
SYS_CT_10206 [check constraint]
TITLE
FOR_LINT.SELFREFERENCE.TITLE 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)

 

PUBLIC.FOR_LINT.WRITERS [table]
ID BIGINT NOT NULL
FIRSTNAME VARCHAR(20) NOT NULL
LASTNAME VARCHAR(20) NOT NULL
ADDRESS1 VARCHAR(255)
ADDRESS2 VARCHAR(255) NOT NULL
CITY VARCHAR(50)
STATE VARCHAR(2)
POSTALCODE VARCHAR(10)
COUNTRY VARCHAR(50)
PHONE1 VARCHAR(10)
PHONE2 VARCHAR(15)
EMAIL1 VARCHAR(10)
EMAIL2 INTEGER
FAX VARCHAR(10)
FAX3 INTEGER
HOMEEMAIL11 VARCHAR(10)
HOMEEMAIL12 VARCHAR(10)
PUBLICATION_ID BIGINT NOT NULL
Primary Key
PK_WRITERS [primary key]
ID
Foreign Keys
FK_WRITER_JOIN [foreign key, with no action]
ID ←(0..many) PUBLIC.FOR_LINT.EXTRA_PK.WRITERID
FK_PUBLICATIONS_WRITER [foreign key, with no action]
ID ←(0..many) PUBLIC.FOR_LINT.PUBLICATIONS.WRITERID
FK_WRITER [foreign key, with no action]
ID ←(0..many) PUBLIC.FOR_LINT.PUBLICATIONWRITERS.WRITERID
FK_WRITERS_PUBLICATION [foreign key, with no action]
PUBLICATION_ID (0..many)→ PUBLIC.FOR_LINT.PUBLICATIONS.ID
Indexes
SYS_IDX_PK_WRITERS_10168 [unique index]
ID ascending
SYS_IDX_FK_WRITERS_PUBLICATION_10213 [non-unique index]
PUBLICATION_ID ascending
IDX_A1_WRITERS [non-unique index]
CITY ascending
STATE ascending
IDX_U_WRITERS [unique index]
EMAIL1 ascending
COUNTRY ascending
IDX_B_WRITERS [non-unique index]
LASTNAME ascending
FIRSTNAME ascending
IDX_A_WRITERS [non-unique index]
CITY ascending
STATE ascending
POSTALCODE ascending
COUNTRY ascending
Table Constraints
CHECK_UPPERCASE_STATE [check constraint]
STATE
FOR_LINT.WRITERS.STATE=UPPER(FOR_LINT.WRITERS.STATE)
SYS_CT_10163 [check constraint]
ID
FOR_LINT.WRITERS.ID IS NOT NULL
SYS_CT_10164 [check constraint]
FIRSTNAME
FOR_LINT.WRITERS.FIRSTNAME IS NOT NULL
SYS_CT_10165 [check constraint]
LASTNAME
FOR_LINT.WRITERS.LASTNAME IS NOT NULL
SYS_CT_10166 [check constraint]
ADDRESS2
FOR_LINT.WRITERS.ADDRESS2 IS NOT NULL
SYS_CT_10167 [check constraint]
PUBLICATION_ID
FOR_LINT.WRITERS.PUBLICATION_ID 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)

 

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
PK_CUSTOMERS [primary key]
POSTALCODE
COUNTRY
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
Indexes
SYS_IDX_PK_CUSTOMERS_10227 [unique index]
POSTALCODE ascending
COUNTRY ascending
Table Constraints
SYS_CT_10223 [check constraint]
CITY
"PUBLISHER SALES".REGIONS.CITY IS NOT NULL
SYS_CT_10224 [check constraint]
STATE
"PUBLISHER SALES".REGIONS.STATE IS NOT NULL
SYS_CT_10225 [check constraint]
POSTALCODE
"PUBLISHER SALES".REGIONS.POSTALCODE IS NOT NULL
SYS_CT_10226 [check constraint]
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)

 

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
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
Indexes
SYS_IDX_FK_SALES_SALESDATA_10241 [non-unique index]
SALESDATAID ascending
SYS_IDX_FK_SALES_REGIONS_10239 [non-unique index]
POSTALCODE ascending
COUNTRY ascending
Table Constraints
SYS_CT_10234 [check constraint]
POSTALCODE
"PUBLISHER SALES".SALES.POSTALCODE IS NOT NULL
SYS_CT_10235 [check constraint]
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)

 

PUBLIC."PUBLISHER SALES".SALESDATA [table]
SALESDATAID INTEGER
YEARLYAMOUNT DOUBLE(64, 0)
Foreign Keys
FK_SALES_SALESDATA [foreign key, with no action]
SALESDATAID ←(0..many) PUBLIC."PUBLISHER SALES".SALES.SALESDATAID
Indexes
SYS_IDX_UQ_CUSTOMERS_10233 [unique index]
SALESDATAID ascending
Table Constraints
UQ_CUSTOMERS [unique constraint]
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)

 

 

Data Types

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."INTEGER ARRAY" [user defined data type]
defined with no parameters
not nullable
not auto-incrementable
not searchable
based on

 

PUBLIC.BOOKS.NAME_TYPE [user defined data type]
defined with no parameters
not nullable
not auto-incrementable
not searchable
based on

 

PUBLIC.BOOKS.VALID_STRING [user defined data type]
defined with no parameters
not nullable
not auto-incrementable
not searchable
based on

 

PUBLIC.BOOKS."VARCHAR(20) ARRAY[10]" [user defined data type]
defined with no parameters
not nullable
not auto-incrementable
not searchable
based on