CERTIFICATES
Stores certificates created by CREATE CERTIFICATE.
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. |