

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                                ascending                   

Foreign Keys

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

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



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

Primary Key

PK_COUPONS                                                 [primary key]
  ID                                ascending                   



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

Primary Key

PK_CUSTOMERS                                               [primary key]
  ID                                ascending                   



"Global Counts"                                                  [table]
------------------------------------------------------------------------



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

Primary Key

SYS_PK_10106                                               [primary key]
  ID                                ascending                   

Foreign Keys

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



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

Primary Key

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

Foreign Keys

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



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



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

