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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000070 | CTSERNUM, CTISSORGNM, CTSBJORGNM, CTSBJCMNM | Unique Index |
SQL030416034906580 | USERS_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_232 | USERS_ID | USERS | USERS_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|