

Tables
========================================================================



PUBLIC.BOOKS.AUTHORS                                             [table]
------------------------------------------------------------------------
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                   



PUBLIC.BOOKS.AUTHORSLIST                                          [view]
------------------------------------------------------------------------
1   ID                                INTEGER                     
2   FIRSTNAME                         VARCHAR(20)                 
3   LASTNAME                          VARCHAR(20)                 



PUBLIC.BOOKS.BOOKAUTHORS                                         [table]
------------------------------------------------------------------------
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                   



PUBLIC.BOOKS.BOOKS                                               [table]
------------------------------------------------------------------------
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                   



PUBLIC.BOOKS.COUPONS                                             [table]
------------------------------------------------------------------------
1   ID                                INTEGER NOT NULL            
2   DATA                              CLOB                        
3   COUPONS                           ARRAY                       
4   BOOKS                             ARRAY                       

Primary Key

PK_COUPONS                                                 [primary key]
1   ID                                ascending                   

Indexes

SYS_IDX_PK_COUPONS_10093                                  [unique index]
1   ID                                ascending                   



PUBLIC.BOOKS.CUSTOMERDATA                                        [table]
------------------------------------------------------------------------
1   ID                                INTEGER NOT NULL            
2   DATA                              VARCHAR(20)                 

Primary Key

PK_CUSTOMERDATA                                            [primary key]
1   ID                                ascending                   

Indexes

SYS_IDX_PK_CUSTOMERDATA_10104                             [unique index]
1   ID                                ascending                   



PUBLIC.BOOKS.CUSTOMERS                                           [table]
------------------------------------------------------------------------
1   ID                                INTEGER NOT NULL            
2   FIRSTNAME                         VARCHAR(100) NOT NULL       
3   LASTNAME                          VARCHAR(100) NOT NULL       
4   AGE                               SMALLINT                    

Primary Key

PK_CUSTOMERS                                               [primary key]
1   ID                                ascending                   

Indexes

SYS_IDX_PK_CUSTOMERS_10098                                [unique index]
1   ID                                ascending                   



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



PUBLIC.BOOKS.PUBLISHERS                                          [table]
------------------------------------------------------------------------
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                   



PUBLIC.BOOKS.ΒΙΒΛΊΑ                                              [table]
------------------------------------------------------------------------
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                   



PUBLIC.FOR_LINT.EXTRA_PK                                         [table]
------------------------------------------------------------------------
Extra table with just a primary key
1   WRITERID                          BIGINT NOT NULL             
2   PUBLICATIONID                     INTEGER NOT NULL            
3   ID                                INTEGER NOT NULL            

Primary Key

PK_EXTRA_PK                                                [primary key]
3   ID                                ascending                   

Foreign Keys

FK_PUBLICATION_JOIN                        [foreign key, with no action]
 1  PUBLICATIONID (0..many)--> PUBLIC.FOR_LINT.PUBLICATIONS.ID                              

FK_WRITER_JOIN                             [foreign key, with no action]
 1  WRITERID (0..many)--> PUBLIC.FOR_LINT.WRITERS.ID                              

Indexes

SYS_IDX_FK_WRITER_JOIN_10201                          [non-unique index]
1   WRITERID                          ascending                   

SYS_IDX_PK_EXTRA_PK_10197                                 [unique index]
3   ID                                ascending                   

SYS_IDX_FK_PUBLICATION_JOIN_10203                     [non-unique index]
2   PUBLICATIONID                     ascending                   



PUBLIC.FOR_LINT."Global Counts"                                  [table]
------------------------------------------------------------------------
1   "Global Count"                    INTEGER                     



PUBLIC.FOR_LINT.PUBLICATIONS                                     [table]
------------------------------------------------------------------------
1   ID                                INTEGER NOT NULL            
2   TITLE                             VARCHAR(255) NOT NULL       
                                    Publication title           
3   DESCRIPTION                       VARCHAR(255)                
4   WRITERID                          BIGINT NOT NULL             
5   PUBLICATIONDATE                   DATE                        
6   PRICE                             DOUBLE(64, 0)               
7   "UPDATE"                          CLOB                        
8   PRESS_RELEASE                     CLOB                        

Primary Key

PK_PUBLICATIONS                                            [primary key]
1   ID                                ascending                   

Foreign Keys

FK_PUBLICATION_JOIN                        [foreign key, with no action]
 1  ID <--(0..many) PUBLIC.FOR_LINT.EXTRA_PK.PUBLICATIONID                              

FK_PUBLICATION                             [foreign key, with no action]
 1  ID <--(0..many) PUBLIC.FOR_LINT.PUBLICATIONWRITERS.PUBLICATIONID                              

FK_WRITERS_PUBLICATION                     [foreign key, with no action]
 1  ID <--(0..many) PUBLIC.FOR_LINT.WRITERS.PUBLICATION_ID                              

FK_PUBLICATIONS_WRITER                     [foreign key, with no action]
 1  WRITERID (0..many)--> PUBLIC.FOR_LINT.WRITERS.ID                              

Indexes

SYS_IDX_FK_PUBLICATIONS_WRITER_10182                  [non-unique index]
4   WRITERID                          ascending                   

SYS_IDX_PK_PUBLICATIONS_10178                             [unique index]
1   ID                                ascending                   



PUBLIC.FOR_LINT.PUBLICATIONWRITERS                               [table]
------------------------------------------------------------------------
1   PUBLICATIONID                     INTEGER NOT NULL            
2   WRITERID                          BIGINT NOT NULL             

Foreign Keys

FK_PUBLICATION                             [foreign key, with no action]
 1  PUBLICATIONID (0..many)--> PUBLIC.FOR_LINT.PUBLICATIONS.ID                              

FK_WRITER                                  [foreign key, with no action]
 1  WRITERID (0..many)--> PUBLIC.FOR_LINT.WRITERS.ID                              

Indexes

SYS_IDX_FK_WRITER_10189                               [non-unique index]
2   WRITERID                          ascending                   

SYS_IDX_FK_PUBLICATION_10191                          [non-unique index]
1   PUBLICATIONID                     ascending                   



PUBLIC.FOR_LINT.SELFREFERENCE                                    [table]
------------------------------------------------------------------------
1   ID                                INTEGER NOT NULL            
2   TITLE                             VARCHAR(255) NOT NULL       

Primary Key

PK_SELFREFERENCE                                           [primary key]
1   ID                                ascending                   

Foreign Keys

FK_SELFREFERENCE                           [foreign key, with no action]
 1  ID <--(0..1) ID                                               

Indexes

SYS_IDX_PK_SELFREFERENCE_10207                            [unique index]
1   ID                                ascending                   

SYS_IDX_FK_SELFREFERENCE_10210                        [non-unique index]
1   ID                                ascending                   



PUBLIC.FOR_LINT.WRITERS                                          [table]
------------------------------------------------------------------------
1   ID                                BIGINT NOT NULL             
2   FIRSTNAME                         VARCHAR(20) NOT NULL        
3   LASTNAME                          VARCHAR(20) NOT NULL        
4   ADDRESS1                          VARCHAR(255)                
5   ADDRESS2                          VARCHAR(255) NOT NULL       
6   CITY                              VARCHAR(50)                 
7   STATE                             VARCHAR(2)                  
8   POSTALCODE                        VARCHAR(10)                 
9   COUNTRY                           VARCHAR(50)                 
10  PHONE1                            VARCHAR(10)                 
11  PHONE2                            VARCHAR(15)                 
12  EMAIL1                            VARCHAR(10)                 
13  EMAIL2                            INTEGER                     
14  FAX                               VARCHAR(10)                 
15  FAX3                              INTEGER                     
16  HOMEEMAIL11                       VARCHAR(10)                 
17  HOMEEMAIL12                       VARCHAR(10)                 
18  PUBLICATION_ID                    BIGINT NOT NULL             

Primary Key

PK_WRITERS                                                 [primary key]
1   ID                                ascending                   

Foreign Keys

FK_WRITERS_PUBLICATION                     [foreign key, with no action]
 1  PUBLICATION_ID (0..many)--> PUBLIC.FOR_LINT.PUBLICATIONS.ID                              

FK_WRITER_JOIN                             [foreign key, with no action]
 1  ID <--(0..many) PUBLIC.FOR_LINT.EXTRA_PK.WRITERID                              

FK_PUBLICATIONS_WRITER                     [foreign key, with no action]
 1  ID <--(0..many) PUBLIC.FOR_LINT.PUBLICATIONS.WRITERID                              

FK_WRITER                                  [foreign key, with no action]
 1  ID <--(0..many) PUBLIC.FOR_LINT.PUBLICATIONWRITERS.WRITERID                              

Indexes

SYS_IDX_PK_WRITERS_10168                                  [unique index]
1   ID                                ascending                   

SYS_IDX_FK_WRITERS_PUBLICATION_10213                  [non-unique index]
18  PUBLICATION_ID                    ascending                   

IDX_A1_WRITERS                                        [non-unique index]
6   CITY                              ascending                   
7   STATE                             ascending                   

IDX_U_WRITERS                                             [unique index]
12  EMAIL1                            ascending                   
9   COUNTRY                           ascending                   

IDX_B_WRITERS                                         [non-unique index]
3   LASTNAME                          ascending                   
2   FIRSTNAME                         ascending                   

IDX_A_WRITERS                                         [non-unique index]
6   CITY                              ascending                   
7   STATE                             ascending                   
8   POSTALCODE                        ascending                   
9   COUNTRY                           ascending                   



PUBLIC."PUBLISHER SALES".REGIONS                                 [table]
------------------------------------------------------------------------
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                   



PUBLIC."PUBLISHER SALES".SALES                                   [table]
------------------------------------------------------------------------
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                   



PUBLIC."PUBLISHER SALES".SALESDATA                               [table]
------------------------------------------------------------------------
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                   

