SchemaSpy Analysis of ejbca - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Apr 14 10:52 PDT 2008
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
ejbca contains 183 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
AdminGroupData_accessRules AccessRulesData int 11  √  null
AdminGroupData_adminEntities AdminEntityData int 11  √  null
accessRule AccessRulesData varchar 250  √  null
adminData LogEntryData varchar 250  √  null
adminData ProtectedLogData varchar 250  √  null
adminGroupId HardTokenIssuerData int 11
adminGroupName AdminGroupData varchar 250  √  null
adminType LogEntryData int 11
adminType ProtectedLogData int 11
alias HardTokenIssuerData varchar 250  √  null
approvaldata ApprovalData longtext 2147483647  √  null
approvalid ApprovalData int 11
approvaltype ApprovalData int 11
authorizationTreeUpdateNumber AuthorizationTreeUpdateData int 11
b64LinkedInEventIdentifiers ProtectedLogData text 65535  √  null
b64LinkedInEventsHash ProtectedLogData varchar 250  √  null
b64LogDataHash ProtectedLogExportData varchar 250  √  null
b64PreviosExportHash ProtectedLogExportData varchar 250  √  null
b64Protection ProtectedLogData text 65535  √  null
b64Signature ProtectedLogExportData text 65535  √  null
b64SignatureCertificate ProtectedLogExportData text 65535  √  null
b64TokenCertificate ProtectedLogTokenData text 65535  √  null
base64Cert CertificateData text 65535  √  null
base64Crl CRLData longtext 2147483647  √  null
cAFingerprint CRLData varchar 250  √  null
cAFingerprint CertificateData varchar 250  √  null
cAId AdminGroupData int 11
cAId CAData int 11
cAId UserData int 11
cRLNumber CRLData int 11
cTime HardTokenData bigint 20
caId LogEntryData int 11
caId ProtectedLogData int 11
caid ApprovalData int 11
certSN KeyRecoveryData varchar 100
certificateFingerprint HardTokenCertificateMap varchar 250
certificateIssuerDN ProtectedLogData varchar 250  √  null
certificateProfileId UserData int 11
certificateProfileName CertificateProfileData varchar 250  √  null
certificateSNR LogEntryData varchar 250  √  null
certificateSerialNumber ProtectedLogData varchar 250  √  null
clearPassword UserData varchar 250  √  null
comment LogEntryData varchar 250  √  null
configurationId GlobalConfigurationData varchar 250
counter ProtectedLogData bigint 20
currentHashAlgorithm ProtectedLogData varchar 250  √  null
currentHashAlgorithm ProtectedLogExportData varchar 250  √  null
data AdminPreferencesData longblob 2147483647  √  null
data CAData text 65535  √  null
data CertificateProfileData longblob 2147483647  √  null
data EndEntityProfileData longblob 2147483647  √  null
data GlobalConfigurationData longblob 2147483647  √  null
data HardTokenData longblob 2147483647  √  null
data HardTokenIssuerData longblob 2147483647  √  null
data HardTokenProfileData longtext 2147483647  √  null
data PublisherData text 65535  √  null
data ServiceData text 65535  √  null
data UserDataSourceData text 65535  √  null
dbKey TableProtectData varchar 250  √  null
dbType TableProtectData varchar 250  √  null
deleted ProtectedLogExportData tinyint 4
deltaCRLIndicator CRLData int 11
endEntityProfileId UserData int 11
endentityprofileid ApprovalData int 11
event LogEntryData int 11
eventComment ProtectedLogData text 65535  √  null
eventId ProtectedLogData int 11
eventTime ProtectedLogData bigint 20
expireDate CertificateData bigint 20
expireTime CAData bigint 20
expiredate ApprovalData bigint 20
exportEndTime ProtectedLogExportData bigint 20
exportStartTime ProtectedLogExportData bigint 20
extendedInformationData UserData longtext 2147483647  √  null
fingerprint CRLData varchar 250
fingerprint CertReqHistoryData varchar 250
fingerprint CertificateData varchar 250
hardTokenIssuerId UserData int 11
hash TableProtectData varchar 250  √  null
hashVersion TableProtectData int 11
id AdminPreferencesData varchar 250
id ApprovalData int 11
id CertificateProfileData int 11
id EndEntityProfileData int 11
id HardTokenIssuerData int 11
id HardTokenProfileData varchar 80
id HardTokenPropertyData varchar 80
id LogConfigurationData int 11
id LogEntryData int 11
id PublisherData int 11
id ServiceData int 11
id TableProtectData varchar 250
id UserDataSourceData int 11
isRecursive AccessRulesData tinyint 4
issuerDN CRLData varchar 250  √  null
issuerDN CertReqHistoryData varchar 250  √  null
issuerDN CertificateData varchar 250  √  null
issuerDN KeyRecoveryData varchar 230
keyData KeyRecoveryData text 65535  √  null
keyRef TableProtectData varchar 250  √  null
keyStorePassword UserData varchar 250  √  null
keyType TableProtectData varchar 250  √  null
logConfiguration LogConfigurationData longblob 2147483647  √  null
logEntryRowNumber LogConfigurationData int 11
mTime HardTokenData bigint 20
markedAsRecoverable KeyRecoveryData tinyint 4
matchType AdminEntityData int 11
matchValue AdminEntityData varchar 250  √  null
matchWith AdminEntityData int 11
module LogEntryData int 11
module ProtectedLogData int 11
name CAData varchar 250  √  null
name HardTokenProfileData varchar 250  √  null
name PublisherData varchar 250  √  null
name ServiceData varchar 250  √  null
name UserDataSourceData varchar 250  √  null
nextUpdate CRLData bigint 20
nodeGUID ProtectedLogData int 11
nodeIP ProtectedLogData varchar 250  √  null
pK AccessRulesData int 11
pK AdminEntityData int 11
pK AdminGroupData int 11
pK AuthorizationTreeUpdateData int 11
passwordHash UserData varchar 250  √  null
pk ProtectedLogData varchar 250
pk ProtectedLogExportData varchar 250
pk ProtectedLogTokenData varchar 250
profileName EndEntityProfileData varchar 250  √  null
property HardTokenPropertyData varchar 250
protectionAlg TableProtectData varchar 250  √  null
protectionKeyAlgorithm ProtectedLogData varchar 250  √  null
protectionKeyIdentifier ProtectedLogData int 11
remainingapprovals ApprovalData int 11
reqadmincertissuerdn ApprovalData varchar 250  √  null
reqadmincertsn ApprovalData varchar 250  √  null
requestdata ApprovalData longtext 2147483647  √  null
requestdate ApprovalData bigint 20
revocationDate CertificateData bigint 20
revocationReason CertificateData int 11
rule AccessRulesData int 11
serialNumber CertReqHistoryData varchar 250  √  null
serialNumber CertificateData varchar 250  √  null
signature TableProtectData varchar 250  √  null
significantIssuerDN HardTokenData varchar 250  √  null
status ApprovalData int 11
status CAData int 11
status CertificateData int 11
status UserData int 11
subjectAltName UserData varchar 250  √  null
subjectDN CAData varchar 250  √  null
subjectDN CertificateData varchar 250  √  null
subjectDN UserData varchar 250  √  null
subjectEmail UserData varchar 250  √  null
thisUpdate CRLData bigint 20
time LogEntryData bigint 20
time TableProtectData bigint 20
timeCreated UserData bigint 20
timeModified UserData bigint 20
timeOfExport ProtectedLogExportData bigint 20
timestamp CertReqHistoryData bigint 20
tokenIdentifier ProtectedLogTokenData int 11
tokenReference ProtectedLogTokenData text 65535  √  null
tokenSN HardTokenCertificateMap varchar 250  √  null
tokenSN HardTokenData varchar 250
tokenType HardTokenData int 11
tokenType ProtectedLogTokenData int 11
tokenType UserData int 11
type CertificateData int 11
type UserData int 11
updateCounter HardTokenProfileData int 11
updateCounter PublisherData int 11
updateCounter UserDataSourceData int 11
updateTime CAData bigint 20
userDataVO CertReqHistoryData longtext 2147483647  √  null
username CertReqHistoryData varchar 250  √  null
username CertificateData varchar 250  √  null
username HardTokenData varchar 250  √  null
username KeyRecoveryData varchar 250  √  null
username LogEntryData varchar 250  √  null
username ProtectedLogData varchar 250  √  null
username UserData varchar 250
value HardTokenPropertyData varchar 250  √  null
version TableProtectData int 11