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 Self-Managed 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.