SEOTOKENUSGTYPE

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:

Name Type Description
TOKENUSGTYPE_ID BIGINT NOT NULL The token usage type ID. This is the primary key.
TOKENUSGTYPE VARCHAR (64) NOT NULL The usage type associated with the token. For example, Product or Privacy.
PRIMARYTOKEN VARCHAR (254) NOT NULL The primary token associated with the usage. For example, ProductToken or PrivacyToken.
STOREENT_ID INTEGER NOT NULL The reference number of the store entity the token belongs to.
ISSTATIC SMALLINT NOT NULL DEFAULT 0 Flag to indicate whether the token is associated to a static URL.

  • 0-False

  • 1-True

OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


Indexes:

Name Column Names Type
<SYSTEM-GENERATED> TOKENUSGTYPE_ID Primary Key
I0001425 TOKENUSGTYPE+STOREENT_ID Unique Index
I0001426 STOREENT_ID Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_3711 STOREENT_ID STOREENT STOREENT_ID Cascade