

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



"PUBLIC"."BOOKS"."AUTHORS"                                       [table]
------------------------------------------------------------------------
Contact details for book authors
  "ID"                              INTEGER NOT NULL            
  "FIRSTNAME"                       VARCHAR(20) NOT NULL        
  "LASTNAME"                        VARCHAR(20) NOT NULL        
  "CITY"                            VARCHAR(50)                 
  "STATE"                           CHARACTER(2)                
  "POSTALCODE"                      VARCHAR(10)                 
  "COUNTRY"                         VARCHAR(50)                 
                                    default 'USA'               

Primary Key

"PK_AUTHORS"                                               [primary key]
  "ID"                                                          

Foreign Keys

"Z_FK_AUTHOR"                              [foreign key, with no action]
  "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
  "BOOKID"                          INTEGER NOT NULL            
  "AUTHORID"                        INTEGER NOT NULL            

Foreign Keys

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

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



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

Primary Key

"PK_BOOKS"                                                 [primary key]
  "ID"                                                          

Foreign Keys

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

"SYS_FK_10118"                             [foreign key, with no action]
  "ID" <--(0..many) "PUBLIC"."BOOKS"."BOOKAUTHORS"."BOOKID"                              

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



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

Primary Key

"PK_Celebrities"                                           [primary key]
  "Id"                                                          

Foreign Keys

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



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

Primary Key

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

Foreign Keys

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



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

Primary Key

"PK_COUPONS"                                               [primary key]
  "ID"                                                          



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

Primary Key

"PK_CUSTOMERDATA"                                          [primary key]
  "ID"                                                          



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

Primary Key

"PK_CUSTOMERS"                                             [primary key]
  "ID"                                                          



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

Primary Key

"SYS_PK_10124"                                             [primary key]
  "ID"                                                          

Foreign Keys

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



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

Primary Key

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

Foreign Keys

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



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



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

Foreign Keys

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

"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"                              



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

Foreign Keys

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

