Syndication Projections

In Elastic Path catalog syndication, a projection is a representation of data that is optimised for syndication users to consume.

A projection is needed to segregate catalog data from relational data. All entity projections reside in a single database table in the Elastic Path Commerce Manager schema.

The schema tables for catalog syndication are TCATALOGPROJECTIONS and TCATALOGHISTORY. Data in both tables are identical.

Catalog Projections Table

The TCATALOGPROJECTIONS table contains a row for each historical version.

TYPE

Type: Varchar (64)

The entity type, such as offer.

STORE

Type: Varchar (64)

The store code for the entity.

CODE

Type: Varchar (64)

The unique ID of the projected entity.

VERSION

Type: Bigint

The projection version number.

note

Each row with the same TYPE, CODE, and STORE increments by one.

PROJECTION_DATE_TIME

Type: TIMESTAMP

The default CURRENT_TIMESTAMP when the projection is created.

note

This populates modifiedDateTime field on projections.

DELETED

Type: Boolean/Bit/ Number(1)

The deletion status of an entity. The options are:

• 0: Specifies that the entity is not deleted
• 1: Specifies that the entity is deleted

If the entity is deleted, the CONTENT, HASH, and SCHEMA_VERSION columns are empty.

SCHEMA_VERSION

Type: Varchar (64)

The schema version number for generating the projection.

CONTENT_HASH

Type: Varchar (256)

The SHA-256 hash of the projection content.

CONTENT

Type: mediumtext/CLOB

The contents of the projection, encoded as JSON.

DISABLE_DATE_TIME

Type: TIMESTAMP

The timestamp to start a job to replace the expired projection with a tombstone projection.

Catalog History Table

The TCATALOGHISTORY table contains a row for each catalog entity.

TYPE

Type: Varchar (64)

The entity type, such as offer.

STORE

Type: Varchar (64)

The store code for the entity.

CODE

Type: Varchar (64)

The unique ID of the projected entity.

VERSION

Type: Bigint

The projection version number.

note

Each row with the same TYPE, CODE, and STORE increments by one.

PROJECTION_DATE_TIME

Type: TIMESTAMP

The default CURRENT_TIMESTAMP when the projection is created.

note

This populates modifiedDateTime field on projections.

DELETED

Type: Boolean/Bit/ Number(1)

The deletion status of an entity. The options are:

• 0: Specifies that the entity is not deleted
• 1: Specifies that the entity is deleted. If the entity is deleted, the CONTENT, HASH, and SCHEMA_VERSION columns are empty

SCHEMA_VERSION

Type: Varchar (64)

The schema version number for generating the projection.

CONTENT_HASH

Type: Varchar (256)

The SHA-256 hash of the projection content.

CONTENT

Type: mediumtext/CLOB

The contents of the projection, encoded as JSON.