

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        
6   CITY                              VARCHAR(50)                 
7   STATE                             CHAR(2)                     
8   POSTALCODE                        VARCHAR(10)                 
9   COUNTRY                           VARCHAR(50)                 

Primary Key

PK_AUTHORS                                                 [primary key]
1   ID                                                            

Foreign Keys

Z_FK_AUTHOR                                [foreign key, with no action]
 1  ID <--(0..many) PUBLIC.BOOKS.BOOKAUTHORS.AUTHORID                              



PUBLIC.BOOKS.AUTHORSLIST                                          [view]
------------------------------------------------------------------------



PUBLIC.BOOKS.BOOKAUTHORS                                         [table]
------------------------------------------------------------------------
Relationship between books and their authors, 
along with the latest updated information
1   BOOKID                            INTEGER NOT NULL            
2   AUTHORID                          INTEGER NOT NULL            

Foreign Keys

Z_FK_AUTHOR                                [foreign key, with no action]
 1  AUTHORID (0..many)--> PUBLIC.BOOKS.AUTHORS.ID                              

SYS_FK_10120                               [foreign key, with no action]
 1  BOOKID (0..many)--> PUBLIC.BOOKS.BOOKS.ID                              



PUBLIC.BOOKS.BOOKS                                               [table]
------------------------------------------------------------------------
Details for published books
1   ID                                INTEGER NOT NULL            
                                    Unique (internal) id for book
7   PREVIOUSEDITIONID                 INTEGER                     

Primary Key

PK_BOOKS                                                   [primary key]
1   ID                                                            

Foreign Keys

FK_SALES_BOOK                              [foreign key, with no action]
 1  ID <--(0..many) PUBLIC."PUBLISHER SALES".SALES.BOOKID                              

SYS_FK_10120                               [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                                



PUBLIC.BOOKS."Celebrities"                                       [table]
------------------------------------------------------------------------
1   "Id"                              INTEGER NOT NULL            

Primary Key

"PK_Celebrities"                                           [primary key]
1   "Id"                                                          

Foreign Keys

SYS_FK_10130                               [foreign key, with no action]
 1  "Id" <--(0..1) PUBLIC.BOOKS."Celebrity Updates"."Celebrity Id"                              



PUBLIC.BOOKS."Celebrity Updates"                                 [table]
------------------------------------------------------------------------
1   "Celebrity Id"                    INTEGER NOT NULL            

Primary Key

"PK Celebrity Updates"                                     [primary key]
1   "Celebrity Id"                                                

Foreign Keys

SYS_FK_10130                               [foreign key, with no action]
 1  "Celebrity Id" (0..1)--> PUBLIC.BOOKS."Celebrities"."Id"                              



PUBLIC.BOOKS.COUPONS                                             [table]
------------------------------------------------------------------------
1   ID                                INTEGER NOT NULL            

Primary Key

PK_COUPONS                                                 [primary key]
1   ID                                                            



PUBLIC.BOOKS.CUSTOMERDATA                                        [table]
------------------------------------------------------------------------
1   ID                                INTEGER NOT NULL            

Primary Key

PK_CUSTOMERDATA                                            [primary key]
1   ID                                                            



PUBLIC.BOOKS.CUSTOMERS                                           [table]
------------------------------------------------------------------------
1   ID                                INTEGER NOT NULL            

Primary Key

PK_CUSTOMERS                                               [primary key]
1   ID                                                            



PUBLIC.BOOKS.PUBLISHERS                                          [table]
------------------------------------------------------------------------
List of book publishers
1   ID                                INTEGER NOT NULL            
                                    auto-incremented            
                                    Unique (internal) id for book publisher

Primary Key

SYS_PK_10126                                               [primary key]
1   ID                                                            

Foreign Keys

FK_ΒΙΒΛΊΑ_PUBLISHERS                       [foreign key, with no action]
 1  ID <--(0..many) PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ                              



PUBLIC.BOOKS.ΒΙΒΛΊΑ                                              [table]
------------------------------------------------------------------------
1   ΜΟΝΑΔΙΚΌΣ                         SMALLINT NOT NULL           
4   ΕΚΔΌΤΗΣ                           SMALLINT NOT NULL           

Primary Key

PK_ΒΙΒΛΊΑ                                                  [primary key]
1   ΜΟΝΑΔΙΚΌΣ                                                     

Foreign Keys

FK_ΒΙΒΛΊΑ_PUBLISHERS                       [foreign key, with no action]
 1  ΕΚΔΌΤΗΣ (0..many)--> PUBLIC.BOOKS.PUBLISHERS.ID                              



PUBLIC."PUBLISHER SALES".REGIONS                                 [table]
------------------------------------------------------------------------
3   POSTALCODE                        VARCHAR(10) NOT NULL        
4   COUNTRY                           VARCHAR(50) NOT NULL        

Primary Key

PK_CUSTOMERS                                               [primary key]
3   POSTALCODE                                                    
4   COUNTRY                                                       

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                              



PUBLIC."PUBLISHER SALES".SALES                                   [table]
------------------------------------------------------------------------
1   POSTALCODE                        VARCHAR(10) NOT NULL        
2   COUNTRY                           VARCHAR(50) NOT NULL        
3   BOOKID                            INTEGER                     
7   SALESDATAID                       INTEGER                     

Foreign Keys

FK_SALES_BOOK                              [foreign key, with no action]
 1  BOOKID (0..many)--> PUBLIC.BOOKS.BOOKS.ID                              

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                              



PUBLIC."PUBLISHER SALES".SALESDATA                               [table]
------------------------------------------------------------------------
1   SALESDATAID                       INTEGER                     

Foreign Keys

FK_SALES_SALESDATA                         [foreign key, with no action]
 1  SALESDATAID <--(0..many) PUBLIC."PUBLISHER SALES".SALES.SALESDATAID                              

