KeyStore (ver6.2.1.1)
This table implements a custom PowerSchool keystore.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AliasName | 6.2.1.1 | Varchar2(256) | A name given to a keystore. Unique. Indexed. Required. |
CertificateChain | 6.2.1.1 | BLOB | This is the digital certificate chain, which stores a single certificate or a chain of certificates to be used with integration with third party systems. The certificate bytes are encoded in DER format using X509 encoding. Only X509 certificates are supported. |
EntryType | 6.2.1.1 | Number(10) | Valid values: 1 = It is a key entry type, 2 = It is a certificate entry type. Required. |
Key | 6.2.1.1 | BLOB | This is the actual private key used to generate/sign the certificate. The key bytes are encoded in DER format using PKCS8 encoding. |
KeyStoreID | 6.2.1.1 | Number(19) | Unique identifier for this table. Indexed.Required. |
WhenCreated | 6.2.1.1 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 6.2.1.1 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 6.2.1.1 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 6.2.1.1 | Varchar2(100) | The user login that modified the record. Defaults to database user. |