

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



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 <-- SALES.BOOKID                                           

SYS_FK_10118                               [foreign key, with no action]
  ID <-- BOOKAUTHORS.BOOKID                                     

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



"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) "Celebrity Updates"."Celebrity Id"                              



"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)--> "Celebrities"."Id"                              



COUPONS                                                          [table]
------------------------------------------------------------------------
  ID                                INTEGER NOT NULL            

Primary Key

PK_COUPONS                                                 [primary key]
  ID                                                            



CUSTOMERS                                                        [table]
------------------------------------------------------------------------
  ID                                INTEGER NOT NULL            

Primary Key

PK_CUSTOMERS                                               [primary key]
  ID                                                            



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) ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ                                



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

Primary Key

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

Foreign Keys

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



Routines
========================================================================



GETBOOKSCOUNT                                     [procedure, no result]
------------------------------------------------------------------------



NEW_PUBLISHER                                     [procedure, no result]
------------------------------------------------------------------------



NEW_PUBLISHER                                     [procedure, no result]
------------------------------------------------------------------------



CONVERT_BLOCK                                     [procedure, no result]
------------------------------------------------------------------------



DELETE_BLOCKS                                     [procedure, no result]
------------------------------------------------------------------------



DELETE_LOB                                        [procedure, no result]
------------------------------------------------------------------------



DELETE_UNUSED                                     [procedure, no result]
------------------------------------------------------------------------



DELETE_UNUSED_LOBS                                [procedure, no result]
------------------------------------------------------------------------



DIVIDE_BLOCK                                      [procedure, no result]
------------------------------------------------------------------------



MERGE_EMPTY_BLOCKS                                [procedure, no result]
------------------------------------------------------------------------



Sequences
========================================================================



PUBLISHER_ID_SEQ                                              [sequence]
------------------------------------------------------------------------



LOB_ID                                                        [sequence]
------------------------------------------------------------------------



Synonyms
========================================================================



PUBLICATIONS                                                   [synonym]
------------------------------------------------------------------------

