Main Snapshot Table

Each repository can have only one main snapshot table. It has the same name as the repository. It consists of all the attributes in the repository that are designated as “relational”. To designate an attribute as relational, using the EnterWorks Classic UI, edit the repository’s attribute properties and set the Relational checkbox for the desired attribute. To create an index for the snapshot table for an attribute, set its Create Index checkbox. (For more information on making an attribute relational or building an index for it, see the EnterWorks 10 Administration Guide.)

Open the CZ Vehicle Staging Repository's Properties for Editing

Designate Attributes as Relational and Create an Index for an Attribute

Each of the snapshot table’s columns are labeled with the restricted name of their corresponding attribute. The restricted name of an attribute is a human-friendly name that makes the attribute easier for a user to identify. (For more information on restricted attribute names, see the EnterWorks 10 Administration Guide.)

The first few columns in a snapshot table are system bookkeeping columns. They are:

• InternalRecordId: This is the ID of the attribute’s repository record.
• Created: When the repository record was created.
• Last_Updated: The last time the repository record was updated for any reason, including validation.
• Data_Last_Updated: The last date any attribute in the repository record was last updated.
• Snapshot_Last_Updated: The last time the snapshot record was updated. This may not match the Data_Last_Updated value if a change is made to one of the repository record’s attributes that is NOT in the snapshot table or if the snapshot table has been regenerated.

The attribute columns follow the system columns and are arranged alphabetically.