SchemaSpy Analysis of ejbca - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Dec 11 09:25 CET 2018
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

ejbca contains 319 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
AccessRulesData accessRule varchar 250
AccessRulesData AdminGroupData_accessRules int 10  √  null
AccessRulesData isRecursive tinyint 3
AccessRulesData pK int 10
AccessRulesData rowProtection longtext 2147483647  √  null
AccessRulesData rowVersion int 10
AccessRulesData rule int 10
AcmeAccountData accountId varchar 250
AcmeAccountData currentKeyId varchar 250
AcmeAccountData rawData longtext 2147483647  √  null
AcmeAccountData rowProtection longtext 2147483647  √  null
AcmeAccountData rowVersion int 10
AcmeAuthorizationData accountId varchar 250
AcmeAuthorizationData authorizationId varchar 250
AcmeAuthorizationData orderId varchar 250
AcmeAuthorizationData rawData longtext 2147483647  √  null
AcmeAuthorizationData rowProtection longtext 2147483647  √  null
AcmeAuthorizationData rowVersion int 10
AcmeChallengeData authorizationId varchar 250
AcmeChallengeData challengeId varchar 250
AcmeChallengeData rawData longtext 2147483647  √  null
AcmeChallengeData rowProtection longtext 2147483647  √  null
AcmeChallengeData rowVersion int 10
AcmeChallengeData type varchar 20
AcmeNonceData nonce varchar 250
AcmeNonceData rowProtection longtext 2147483647  √  null
AcmeNonceData rowVersion int 10
AcmeNonceData timeExpires bigint 19
AcmeOrderData accountId varchar 250
AcmeOrderData fingerprint varchar 255  √  null
AcmeOrderData orderId varchar 250
AcmeOrderData rawData longtext 2147483647  √  null
AcmeOrderData rowProtection longtext 2147483647  √  null
AcmeOrderData rowVersion int 10
AcmeOrderData status varchar 255  √  null
AdminEntityData AdminGroupData_adminEntities int 10  √  null
AdminEntityData cAId int 10
AdminEntityData matchType int 10
AdminEntityData matchValue varchar 250  √  null
AdminEntityData matchWith int 10
AdminEntityData pK int 10
AdminEntityData rowProtection longtext 2147483647  √  null
AdminEntityData rowVersion int 10
AdminEntityData tokenType varchar 250  √  null
AdminGroupData adminGroupName varchar 250
AdminGroupData pK int 10
AdminGroupData rowProtection longtext 2147483647  √  null
AdminGroupData rowVersion int 10
AdminPreferencesData data longblob 2147483647
AdminPreferencesData id varchar 250
AdminPreferencesData rowProtection longtext 2147483647  √  null
AdminPreferencesData rowVersion int 10
ApprovalData approvalData longtext 2147483647
ApprovalData approvalId int 10
ApprovalData approvalType int 10
ApprovalData cAId int 10
ApprovalData endEntityProfileId int 10
ApprovalData expireDate bigint 19
ApprovalData id int 10
ApprovalData remainingApprovals int 10
ApprovalData reqAdminCertIssuerDn varchar 250  √  null
ApprovalData reqAdminCertSn varchar 250  √  null
ApprovalData requestData longtext 2147483647
ApprovalData requestDate bigint 19
ApprovalData rowProtection longtext 2147483647  √  null
ApprovalData rowVersion int 10
ApprovalData status int 10
AuditRecordData additionalDetails longtext 2147483647  √  null
AuditRecordData authToken varchar 250
AuditRecordData customId varchar 250  √  null
AuditRecordData eventStatus varchar 250
AuditRecordData eventType varchar 250
AuditRecordData module varchar 250
AuditRecordData nodeId varchar 250
AuditRecordData pk varchar 250
AuditRecordData rowProtection longtext 2147483647  √  null
AuditRecordData rowVersion int 10
AuditRecordData searchDetail1 varchar 250  √  null
AuditRecordData searchDetail2 varchar 250  √  null
AuditRecordData sequenceNumber bigint 19
AuditRecordData service varchar 250
AuditRecordData timeStamp bigint 19
AuthorizationTreeUpdateData authorizationTreeUpdateNumber int 10
AuthorizationTreeUpdateData pK int 10
AuthorizationTreeUpdateData rowProtection longtext 2147483647  √  null
AuthorizationTreeUpdateData rowVersion int 10
Base64CertData base64Cert longtext 2147483647  √  null
Base64CertData fingerprint varchar 250
Base64CertData rowProtection longtext 2147483647  √  null
Base64CertData rowVersion int 10
BlacklistData data varchar 250  √  null
BlacklistData id int 10
BlacklistData rowProtection longtext 2147483647  √  null
BlacklistData rowVersion int 10
BlacklistData type varchar 250  √  null
BlacklistData updateCounter int 10
BlacklistData value varchar 250  √  null
CAData cAId int 10
CAData data longtext 2147483647
CAData expireTime bigint 19
CAData name varchar 250  √  null
CAData rowProtection longtext 2147483647  √  null
CAData rowVersion int 10
CAData status int 10
CAData subjectDN varchar 250  √  null
CAData updateTime bigint 19
CertificateData base64Cert longtext 2147483647  √  null
CertificateData cAFingerprint varchar 250  √  null
CertificateData certificateProfileId int 10
CertificateData endEntityProfileId int 10  √  null
CertificateData expireDate bigint 19
CertificateData fingerprint varchar 250
CertificateData issuerDN varchar 250
CertificateData notBefore bigint 19  √  null
CertificateData revocationDate bigint 19
CertificateData revocationReason int 10
CertificateData rowProtection longtext 2147483647  √  null
CertificateData rowVersion int 10
CertificateData serialNumber varchar 250
CertificateData status int 10
CertificateData subjectAltName varchar 2000  √  null
CertificateData subjectDN varchar 400
CertificateData subjectKeyId varchar 250  √  null
CertificateData tag varchar 250  √  null
CertificateData type int 10
CertificateData updateTime bigint 19
CertificateData username varchar 250  √  null
CertificateProfileData certificateProfileName varchar 250
CertificateProfileData data longblob 2147483647
CertificateProfileData id int 10
CertificateProfileData rowProtection longtext 2147483647  √  null
CertificateProfileData rowVersion int 10
CertReqHistoryData fingerprint varchar 250
CertReqHistoryData issuerDN varchar 250
CertReqHistoryData rowProtection longtext 2147483647  √  null
CertReqHistoryData rowVersion int 10
CertReqHistoryData serialNumber varchar 250
CertReqHistoryData timestamp bigint 19
CertReqHistoryData userDataVO longtext 2147483647
CertReqHistoryData username varchar 250
CRLData base64Crl longtext 2147483647
CRLData cAFingerprint varchar 250
CRLData cRLNumber int 10
CRLData deltaCRLIndicator int 10
CRLData fingerprint varchar 250
CRLData issuerDN varchar 250
CRLData nextUpdate bigint 19
CRLData rowProtection longtext 2147483647  √  null
CRLData rowVersion int 10
CRLData thisUpdate bigint 19
CryptoTokenData id int 10
CryptoTokenData lastUpdate bigint 19
CryptoTokenData rowProtection longtext 2147483647  √  null
CryptoTokenData rowVersion int 10
CryptoTokenData tokenData longtext 2147483647  √  null
CryptoTokenData tokenName varchar 250
CryptoTokenData tokenProps longtext 2147483647  √  null
CryptoTokenData tokenType varchar 250
EndEntityProfileData data longblob 2147483647
EndEntityProfileData id int 10
EndEntityProfileData profileName varchar 250
EndEntityProfileData rowProtection longtext 2147483647  √  null
EndEntityProfileData rowVersion int 10
GlobalConfigurationData configurationId varchar 250
GlobalConfigurationData data longblob 2147483647
GlobalConfigurationData rowProtection longtext 2147483647  √  null
GlobalConfigurationData rowVersion int 10
HardTokenCertificateMap certificateFingerprint varchar 250
HardTokenCertificateMap rowProtection longtext 2147483647  √  null
HardTokenCertificateMap rowVersion int 10
HardTokenCertificateMap tokenSN varchar 250
HardTokenData cTime bigint 19
HardTokenData data longblob 2147483647  √  null
HardTokenData mTime bigint 19
HardTokenData rowProtection longtext 2147483647  √  null
HardTokenData rowVersion int 10
HardTokenData significantIssuerDN varchar 250  √  null
HardTokenData tokenSN varchar 250
HardTokenData tokenType int 10
HardTokenData username varchar 250  √  null
HardTokenIssuerData adminGroupId int 10
HardTokenIssuerData alias varchar 250
HardTokenIssuerData data longblob 2147483647
HardTokenIssuerData id int 10
HardTokenIssuerData rowProtection longtext 2147483647  √  null
HardTokenIssuerData rowVersion int 10
HardTokenProfileData data longtext 2147483647  √  null
HardTokenProfileData id int 10
HardTokenProfileData name varchar 250
HardTokenProfileData rowProtection longtext 2147483647  √  null
HardTokenProfileData rowVersion int 10
HardTokenProfileData updateCounter int 10
HardTokenPropertyData id varchar 80
HardTokenPropertyData property varchar 250
HardTokenPropertyData rowProtection longtext 2147483647  √  null
HardTokenPropertyData rowVersion int 10
HardTokenPropertyData value varchar 250  √  null
InternalKeyBindingData certificateId varchar 250  √  null
InternalKeyBindingData cryptoTokenId int 10
InternalKeyBindingData id int 10
InternalKeyBindingData keyBindingType varchar 250
InternalKeyBindingData keyPairAlias varchar 250
InternalKeyBindingData lastUpdate bigint 19
InternalKeyBindingData name varchar 250
InternalKeyBindingData rawData longtext 2147483647  √  null
InternalKeyBindingData rowProtection longtext 2147483647  √  null
InternalKeyBindingData rowVersion int 10
InternalKeyBindingData status varchar 250
KeyRecoveryData certSN varchar 80
KeyRecoveryData cryptoTokenId int 10 0
KeyRecoveryData issuerDN varchar 250
KeyRecoveryData keyAlias varchar 250  √  null
KeyRecoveryData keyData longtext 2147483647
KeyRecoveryData markedAsRecoverable tinyint 3
KeyRecoveryData publicKeyId varchar 250  √  null
KeyRecoveryData rowProtection longtext 2147483647  √  null
KeyRecoveryData rowVersion int 10
KeyRecoveryData username varchar 250  √  null
NoConflictCertificateData base64Cert longtext 2147483647  √  null
NoConflictCertificateData cAFingerprint varchar 250  √  null
NoConflictCertificateData certificateProfileId int 10
NoConflictCertificateData endEntityProfileId int 10  √  null
NoConflictCertificateData expireDate bigint 19
NoConflictCertificateData fingerprint varchar 250  √  null
NoConflictCertificateData id varchar 250
NoConflictCertificateData issuerDN varchar 250
NoConflictCertificateData notBefore bigint 19  √  null
NoConflictCertificateData revocationDate bigint 19
NoConflictCertificateData revocationReason int 10
NoConflictCertificateData rowProtection longtext 2147483647  √  null
NoConflictCertificateData rowVersion int 10
NoConflictCertificateData serialNumber varchar 250
NoConflictCertificateData status int 10
NoConflictCertificateData subjectAltName varchar 2000  √  null
NoConflictCertificateData subjectDN varchar 400
NoConflictCertificateData subjectKeyId varchar 250  √  null
NoConflictCertificateData tag varchar 250  √  null
NoConflictCertificateData type int 10
NoConflictCertificateData updateTime bigint 19
NoConflictCertificateData username varchar 250  √  null
PeerData connectorState int 10
PeerData data longtext 2147483647  √  null
PeerData id int 10
PeerData name varchar 250
PeerData rowProtection longtext 2147483647  √  null
PeerData rowVersion int 10
PeerData url varchar 250
ProfileData id int 10
ProfileData profileName varchar 250
ProfileData profileType varchar 250
ProfileData rawData longtext 2147483647  √  null
ProfileData rowProtection longtext 2147483647  √  null
ProfileData rowVersion int 10
PublisherData data longtext 2147483647  √  null
PublisherData id int 10
PublisherData name varchar 250  √  null
PublisherData rowProtection longtext 2147483647  √  null
PublisherData rowVersion int 10
PublisherData updateCounter int 10
PublisherQueueData fingerprint varchar 250  √  null
PublisherQueueData lastUpdate bigint 19
PublisherQueueData pk varchar 250
PublisherQueueData publisherId int 10
PublisherQueueData publishStatus int 10
PublisherQueueData publishType int 10
PublisherQueueData rowProtection longtext 2147483647  √  null
PublisherQueueData rowVersion int 10
PublisherQueueData timeCreated bigint 19
PublisherQueueData tryCounter int 10
PublisherQueueData volatileData longtext 2147483647  √  null
RoleData id int 10
RoleData nameSpace varchar 250  √  null
RoleData rawData longtext 2147483647  √  null
RoleData roleName varchar 250
RoleData rowProtection longtext 2147483647  √  null
RoleData rowVersion int 10
RoleMemberData description varchar 250  √  null
RoleMemberData primaryKey int 10
RoleMemberData roleId int 10
RoleMemberData rowProtection longtext 2147483647  √  null
RoleMemberData rowVersion int 10
RoleMemberData tokenIssuerId int 10
RoleMemberData tokenMatchKey int 10
RoleMemberData tokenMatchOperator int 10
RoleMemberData tokenMatchValue varchar 2000  √  null
RoleMemberData tokenType varchar 250
ServiceData data longtext 2147483647  √  null
ServiceData id int 10
ServiceData name varchar 250
ServiceData nextRunTimeStamp bigint 19
ServiceData rowProtection longtext 2147483647  √  null
ServiceData rowVersion int 10
ServiceData runTimeStamp bigint 19
UserData cAId int 10
UserData cardNumber varchar 250  √  null
UserData certificateProfileId int 10
UserData clearPassword varchar 250  √  null
UserData endEntityProfileId int 10
UserData extendedInformationData longtext 2147483647  √  null
UserData hardTokenIssuerId int 10
UserData keyStorePassword varchar 250  √  null
UserData passwordHash varchar 250  √  null
UserData rowProtection longtext 2147483647  √  null
UserData rowVersion int 10
UserData status int 10
UserData subjectAltName varchar 8192  √  null
UserData subjectDN varchar 400  √  null
UserData subjectEmail varchar 250  √  null
UserData timeCreated bigint 19
UserData timeModified bigint 19
UserData tokenType int 10
UserData type int 10
UserData username varchar 250
UserDataSourceData data longtext 2147483647  √  null
UserDataSourceData id int 10
UserDataSourceData name varchar 250
UserDataSourceData rowProtection longtext 2147483647  √  null
UserDataSourceData rowVersion int 10
UserDataSourceData updateCounter int 10