SEOTOKENUSGTYPE

This table is used to associate a primary token for every usage type defined in a store. This also holds information as to whether a token is static or not.

Column Descriptions:

NameTypeDescription
TOKENUSGTYPE_IDBIGINT NOT NULLThe token usage type ID. This is the primary key.
TOKENUSGTYPEVARCHAR (64) NOT NULLThe usage type associated with the token. For example, Product or Privacy.
PRIMARYTOKENVARCHAR (254) NOT NULLThe primary token associated with the usage. For example, ProductToken or PrivacyToken.
STOREENT_IDINTEGER NOT NULLThe reference number of the store entity the token belongs to.
ISSTATICSMALLINT NOT NULL DEFAULT 0Flag to indicate whether the token is associated to a static URL.
  • 0-False
  • 1-True
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TOKENUSGTYPE_IDPrimary Key
I0001425TOKENUSGTYPE+STOREENT_IDUnique Index
I0001426STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3711STOREENT_IDSTOREENTSTOREENT_IDCascade