

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_10121                               [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_10131                               [foreign key, with no action]
  "Id" <--(1..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_10131                               [foreign key, with no action]
  "Celebrity Id" (1..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                                                            

Foreign Keys

FK_CUSTOMER                                [foreign key, with no action]
  ID <-- CUSTOMERDATA.CUSTOMERID                                



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

Primary Key

SYS_PK_10127                                               [primary key]
  ID                                                            

Foreign Keys

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



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

Primary Key

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

Foreign Keys

FK_ΒΙΒΛΊΑ_PUBLISHERS                       [foreign key, with no action]
  ΕΚΔΌΤΗΣ (1..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]
------------------------------------------------------------------------

