- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Which tables in the system are base or "corpus" tables (permanent tables which can not be re-constructed from other tables) and which are indexes (can be reconstructed from other tables) or temporary?
These tables can be reconstructed from other tables:
z00p, z00r, z01, z0101, z0102, z02, z101, z103, z11, z111, z13, z13u, z120, z127, z301, z320, z321, z353, z403, z79, z95, z97, z970, z98, and z980.
These are temporary (result set, session, or lock tables):
z05, z110, z130, z131, z200, z50, z51, z60, z63, z64, and z65. [Note: all of these except the z50 occur only in the VIR01 library.]
The z34 and z69 are OPAC statistics tables; the z35 is used for statistics, especially circ statistics.
The above lists may not be complete but, generally, other tables should be considered as base tables.
- Article last edited: 28-Feb-2016