A repository can have the following types of snapshot table views:
- Main Snapshot Table: It consists of all the attributes in the repository that are designated as "relational". Each repository can have only one main snapshot table.
- Category Attribute Snapshot Table: A category attribute snapshot table view is sometimes called a "vertical snapshot table", because instead of the attributes making up the columns of the table, they make up the rows. This allows you to overcome the database limitation of allowing only 1022 columns, thereby freeing EnterWorks repositories to have an unlimited number of category attributes in the snapshot tables.
- Multi-language Snapshot Table: A multi-language snapshot table stores the values of multi-language attributes.
Typically, when the main snapshot table view is referenced, it is called simply "the snapshot table". The category attribute and multi-language snapshot tables are ancillary tables. If a main snapshot table exists, the category attributes and multi-language snapshot tables can be created to extend the abilities of the main snapshot table.