Database Table: CERT_X509

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

Column Name Column Type Column Description
CTISSORGNM CHARACTER (200)
NOT NULL
The organization that issued this certificate.
CTREQID CHARACTER (254)
NULL
This is meant for Open Buying on the Internet (OBI) purposes, otherwise set to NULL.
CTSBJCMNM CHARACTER (254)
NOT NULL
The name of the individual that holds this certificate.
CTSBJEM CHARACTER (254)
NULL
The primary email address of the individual.
CTSBJORGNM CHARACTER (254)
NOT NULL
The name of the organization that this individual belongs to.
CTSERNUM CHARACTER (254)
NOT NULL
The serial number associated with the certificate.
CTSTATUS CHARACTER (4)
NOT NULL
This indicates if the certificate is valid (V), expired (E), or revoked (R).
USERS_ID BIGINT
NOT NULL
Foreign key that references column USERS_ID in the USERS table. This is a unique index.
Indexes:
Index Name Indexed Column Names Index Type
I0000070 CTSERNUM, CTISSORGNM, CTSBJORGNM, CTSBJCMNM Unique Index
SQL030416034906580 USERS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_232 USERS_ID USERS USERS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable