WebSphere Commerce database table: CERT_X509

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


Column Description(s):
Column NameColumn TypeDescription
CTSERNUM CHAR(254) NOT NULL The serial number associated with the certificate.
USERS_ID BIGINT NOT NULL Foreign key that references column USERS_ID in the USERS table. 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 Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000070 CTSERNUM+CTISSORGNM+CTSBJORGNM+CTSBJCMNM Unique Index
SQL050212031211270 USERS_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_232 USERS_ID USERS USERS_ID Cascade

Feedback