Certificate management

The following represents the list of certifications to be verified.

ENROLLMENT_STATUS

The following table lists the issued certificates.

Field Name	Data Type	Description
ENROLLMENT_STATUS_ID	BIGINT	The primary key.
CERTIFICATE_ENROL_STATUS	VARCHAR(255)	The certificate enrollment status. The options are Issued, Pending, and Failed.
CERT_ENROL_TRANSACTION_ID	VARCHAR(2048)	The pending certificate response for EST. Sometimes, this field shows the transaction ID for certificate enrollment.
CERT_SUBJECT_IDENTITY	VARCHAR(255)	The subject identity of the certificate.
CERT_SERIAL_NUMBER	VARCHAR(255)	The serial number of the certificate issued.
PRINTER_ID	BIGINT	The reference printer.
DEFAULT_CERT_REVISION_NO	VARCHAR(255)	The revision number of the certificate that is renewed.
DEFAULT_CERT_RENEWAL_DATE	VARCHAR(255)	The renewal date of the certificate.
CERTIFICATE_FRIENDLY_NAME	VARCHAR(255)	The friendly name of the certificate.
CERTIFICATE_USED_FOR	VARCHAR(255)	The association of the named certificate. The options are DEFAULT, HTTPS, WIRELESS, IPSEC, and UNASSIGNED.

CA_CERT_REVOCATION_COMP_LIST

The following table lists information about the revoked certificates.

Field Name	Data Type	Description
ID	BIGINT	The unique identifier.
SERIAL_NUMBER	VARCHAR(255)	The serial number of the certificate present in the revocation list primary key.
CERTIFICATE_SUBJECT	VARCHAR(255)	The subject of the revoked certificate.
REVOCATION_DATE	TIMESTAMP	The date when the certificate is revoked.
ISSUER	VARCHAR(255)	The issuer of the revoked certificate.
REVOCATION_REASON	VARCHAR(255)	The revocation reason.

NAMED_CERTIFICATE_SETTINGS

The following table lists the name and association of named certificate.

Field Name	Data Type	Description
CERT_SETTING_ID	BIGINT	The unique identifier.
FRIENDLY_NAME	VARCHAR(255)	The friendly name of the named certificate.
CERT_USED_FOR	VARCHAR(255)	The association of the named certificate. The options are DEFAULT, HTTPS, WIRELESS, IPSEC, and UNASSIGNED.
CONFIGURATION_COMPONENT_ID	BIGINT	The foreign key associated with ID of the CONFIGURATION_COMPONENT table.
TEMPLATE_ID	BIGINT	The ID of the associated template.

PRINTER_CERTIFICATE

The following table represents the details of the named certificate.

Field Name	Data Type	Description
CERTIFICATE_ID	BIGINT	The unique identifier.
CERTIFICATE_FRIENDLY_NAME	VARCHAR(255)	The friendly name of the certificate.
CERTIFICATE_COMMON_NAME	VARCHAR(255)	The common name of the certificate.
CERTIFICATE_ISSUER_NAME	VARCHAR(255)	The name of the issuer of the certificate.
CERTIFICATE_SIGNING_STATUS	VARCHAR(255)	The signing status of the certificate. The options are SIGNED, INVALID_CERT, NO_CA, REVOKED, and UNKNOWN.
CERTIFICATE_VALID_FROM	TIMESTAMP	The time when the certificate started to be valid.
CERTIFICATE_VALID_TO	TIMESTAMP	The time when the certificate is no longer valid.
CERTIFICATE_SIGNATURE	VARCHAR(8190)	The signature of the certificate.
CERTIFICATE_SERIAL_NUMBER	VARCHAR(255)	The serial number of the certificate.
TYPE	VARCHAR(255)	The type of the certificate. The options are DEFAULT, HTTPS, WIRELESS, IPSEC, and UNASSIGNED.
PRINTER_ID	BIGINT	The foreign key associated with ID of CONFIGURATION_COMPONENT table.

ENROLLED_CERTIFICATE_TYPE

The following table shows the relationship between certificate and enrollment status.

Field Name	Data Type	Description
TYPE_ID	BIGINT	The unique identifier.
ENROLLMENT_STATUS_ID	BIGINT	The foreign key of the ID column of ENROLLMENT_STATUS table.
TYPE	VARCHAR(255)	The type of the certificate. The options are DEFAULT, HTTPS, WIRELESS, IPSEC, and UNASSIGNED.

CA_TEMPLATE

The following table shows the details of the templates selected when setting up the MSCA server using the MSCEWS protocol.

Field Name	Data Type	Description
TEMPLATE_ID	BIGINT	The unique identifier for templates for MSCA Server with MSCEWS (cannot be null).
TEMPLATE_NAME	VARCHAR(255)	The name of templates in the CEP server.
TEMPLATE_OID	VARCHAR(255)	The corresponding SNMP MIB path.