CERTIFICATES
Stores certificates created by CREATE CERTIFICATE.
| Column Name | Data Type | Description |
|---|---|---|
|
OID |
INTEGER |
The object identifier. |
|
NAME |
VARCHAR |
The name of the certificate. |
|
OWNER |
INTEGER |
The owner of the object. |
|
SIGNED_BY |
INTEGER |
The OID of the signing certificate. |
|
PRIVATE_KEY |
INTEGER |
The OID of the certificate's private key. |
|
START_DATE |
TIMESTAMPTZ |
When the certificate becomes valid. |
|
EXPIRATION_DATE |
TIMESTAMPTZ |
When the certificate expires. |
|
ISSUER |
VARCHAR |
The signing CA. |
|
SUBJECT |
VARCHAR |
The entity for which the certificate is issued. |
|
SERIAL |
VARCHAR |
The certificate's serial number. |
|
x509v3_EXTENSIONS |
VARCHAR |
Lists additional attributes specified during the certificate's creation. For more information on extensions, see the OpenSSL documentation. |
|
CERTIFICATE_TEXT |
VARCHAR |
The contents of the certificate. |