CERT_X509

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

Column Descriptions:

Name	Type	Description
CTSERNUM	CHAR (254) NOT NULL	The serial number associated with the certificate.
USERS_ID	BIGINT NOT NULL	Foreign key that references the USERS.USERS_ID column. This is a unique index.
CTISSORGNM	CHAR (200) NOT NULL	The organization that issued this certificate.
CTSBJCMNM	CHAR (254) NOT NULL	The name of the individual that holds this certificate.
CTSBJORGNM	CHAR (254) NOT NULL	The name of the organization that this individual belongs to.
CTSBJEM	CHAR (254)	The primary email address of the individual.
CTREQID	CHAR (254)	This is meant for Open Buying on the Internet (OBI) purposes, otherwise set to NULL.
CTSTATUS	CHAR (4) NOT NULL	This indicates if the certificate is valid (V), expired (E), or revoked (R).
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>	USERS_ID	Primary Key
I0000070	CTSERNUM+CTISSORGNM+CTSBJORGNM+CTSBJCMNM	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_232	USERS_ID	USERS	USERS_ID	Cascade

Related reference
Member data model
Authentication data model