CERT_X509

This table is used to map X.509 certificate users to a unique user within the HCL Commerce system.

Column Descriptions:

NameTypeDescription
CTSERNUMCHAR (254) NOT NULLThe serial number associated with the certificate.
USERS_IDBIGINT NOT NULLForeign key that references the USERS.USERS_ID column. This is a unique index.
CTISSORGNMCHAR (200) NOT NULLThe organization that issued this certificate.
CTSBJCMNMCHAR (254) NOT NULLThe name of the individual that holds this certificate.
CTSBJORGNMCHAR (254) NOT NULLThe name of the organization that this individual belongs to.
CTSBJEMCHAR (254)The primary email address of the individual.
CTREQIDCHAR (254)This is meant for Open Buying on the Internet (OBI) purposes, otherwise set to NULL.
CTSTATUSCHAR (4) NOT NULLThis indicates if the certificate is valid (V), expired (E), or revoked (R).
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>USERS_IDPrimary Key
I0000070CTSERNUM+CTISSORGNM+CTSBJORGNM+CTSBJCMNMUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_232USERS_IDUSERSUSERS_IDCascade