| PK-base | base | primary key index on base |
| PK-books | books | primary key index on books |
| PK-books_view | books_view | primary key index on books_view |
| PK-base | child | primary key index on base |
| PK-currency | currency | primary key index on currency |
| PK-customers | customers | primary key index on customers |
| PK-books | fiction | primary key index on books |
| PK-base | grandchild | primary key index on base |
| PK-base | greatgrandchild | primary key index on base |
| PK-base | greatgreatgrandchild | primary key index on base |
| PK-ivattribute | ivattribute | primary key index on ivattribute |
| PK-ivclass | ivclass | primary key index on ivclass |
| PK-onloan | onloan | primary key index on onloan |
| FK-onloan-bookno | onloan | foreign key index on onloan to books |
| FK-onloan-custno | onloan | foreign key index on onloan to customers |
| PK-books | reference | primary key index on books |
| PK-shelf | shelf | primary key index on shelf |
| PK-shelvesinaisle | shelvesinaisle | primary key index on shelvesinaisle |
| PK-uses_domains | uses_domains | primary key index on uses_domains |