ejbca contains 197 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
AccessRulesData	accessRule	varchar	250	√		null
AccessRulesData	AdminGroupData_accessRules	int	10	√		null
AccessRulesData	isRecursive	tinyint	3
AccessRulesData	pK	int	10
AccessRulesData	rule	int	10
AdminEntityData	AdminGroupData_adminEntities	int	10	√		null
AdminEntityData	cAId	int	10	√		null
AdminEntityData	matchType	int	10
AdminEntityData	matchValue	varchar	250	√		null
AdminEntityData	matchWith	int	10
AdminEntityData	pK	int	10
AdminGroupData	adminGroupName	varchar	250	√		null
AdminGroupData	cAId	int	10
AdminGroupData	pK	int	10
AdminPreferencesData	data	longblob	2147483647	√		null
AdminPreferencesData	id	varchar	250
ApprovalData	approvalData	longtext	2147483647	√		null
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	√		null
ApprovalData	requestDate	bigint	19
ApprovalData	status	int	10
AuthorizationTreeUpdateData	authorizationTreeUpdateNumber	int	10
AuthorizationTreeUpdateData	pK	int	10
CAData	cAId	int	10
CAData	data	text	65535	√		null
CAData	expireTime	bigint	19
CAData	name	varchar	250	√		null
CAData	status	int	10
CAData	subjectDN	varchar	250	√		null
CAData	updateTime	bigint	19
CertificateData	base64Cert	text	65535	√		null
CertificateData	cAFingerprint	varchar	250	√		null
CertificateData	certificateProfileId	int	10	√		null
CertificateData	expireDate	bigint	19
CertificateData	fingerprint	varchar	250
CertificateData	issuerDN	varchar	250	√		null
CertificateData	revocationDate	bigint	19
CertificateData	revocationReason	int	10
CertificateData	serialNumber	varchar	250	√		null
CertificateData	status	int	10
CertificateData	subjectDN	varchar	250	√		null
CertificateData	tag	varchar	250	√		null
CertificateData	type	int	10
CertificateData	updateTime	bigint	19			0
CertificateData	username	varchar	250	√		null
CertificateProfileData	certificateProfileName	varchar	250	√		null
CertificateProfileData	data	longblob	2147483647	√		null
CertificateProfileData	id	int	10
CertReqHistoryData	fingerprint	varchar	250
CertReqHistoryData	issuerDN	varchar	250	√		null
CertReqHistoryData	serialNumber	varchar	250	√		null
CertReqHistoryData	timestamp	bigint	19
CertReqHistoryData	userDataVO	longtext	2147483647	√		null
CertReqHistoryData	username	varchar	250	√		null
CRLData	base64Crl	longtext	2147483647	√		null
CRLData	cAFingerprint	varchar	250	√		null
CRLData	cRLNumber	int	10
CRLData	deltaCRLIndicator	int	10
CRLData	fingerprint	varchar	250
CRLData	issuerDN	varchar	250	√		null
CRLData	nextUpdate	bigint	19
CRLData	thisUpdate	bigint	19
EndEntityProfileData	data	longblob	2147483647	√		null
EndEntityProfileData	id	int	10
EndEntityProfileData	profileName	varchar	250	√		null
GlobalConfigurationData	configurationId	varchar	250
GlobalConfigurationData	data	longblob	2147483647	√		null
HardTokenCertificateMap	certificateFingerprint	varchar	250
HardTokenCertificateMap	tokenSN	varchar	250	√		null
HardTokenData	cTime	bigint	19
HardTokenData	data	longblob	2147483647	√		null
HardTokenData	mTime	bigint	19
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	√		null
HardTokenIssuerData	data	longblob	2147483647	√		null
HardTokenIssuerData	id	int	10
HardTokenProfileData	data	longtext	2147483647	√		null
HardTokenProfileData	id	varchar	80
HardTokenProfileData	name	varchar	250	√		null
HardTokenProfileData	updateCounter	int	10
HardTokenPropertyData	id	varchar	80
HardTokenPropertyData	property	varchar	250
HardTokenPropertyData	value	varchar	250	√		null
KeyRecoveryData	certSN	varchar	100
KeyRecoveryData	issuerDN	varchar	230
KeyRecoveryData	keyData	text	65535	√		null
KeyRecoveryData	markedAsRecoverable	tinyint	3
KeyRecoveryData	username	varchar	250	√		null
LogConfigurationData	id	int	10
LogConfigurationData	logConfiguration	longblob	2147483647	√		null
LogConfigurationData	logEntryRowNumber	int	10
LogEntryData	adminData	varchar	250	√		null
LogEntryData	adminType	int	10
LogEntryData	cAId	int	10
LogEntryData	certificateSNR	varchar	250	√		null
LogEntryData	comment	varchar	250	√		null
LogEntryData	event	int	10
LogEntryData	id	int	10
LogEntryData	module	int	10
LogEntryData	time	bigint	19
LogEntryData	username	varchar	250	√		null
ProtectedLogData	adminData	varchar	250	√		null
ProtectedLogData	adminType	int	10
ProtectedLogData	b64LinkedInEventIdentifiers	text	65535	√		null
ProtectedLogData	b64LinkedInEventsHash	varchar	250	√		null
ProtectedLogData	b64Protection	text	65535	√		null
ProtectedLogData	cAId	int	10
ProtectedLogData	certificateIssuerDN	varchar	250	√		null
ProtectedLogData	certificateSerialNumber	varchar	250	√		null
ProtectedLogData	counter	bigint	19
ProtectedLogData	currentHashAlgorithm	varchar	250	√		null
ProtectedLogData	eventComment	text	65535	√		null
ProtectedLogData	eventId	int	10
ProtectedLogData	eventTime	bigint	19
ProtectedLogData	module	int	10
ProtectedLogData	nodeGUID	int	10
ProtectedLogData	nodeIP	varchar	250	√		null
ProtectedLogData	pk	varchar	250
ProtectedLogData	protectionKeyAlgorithm	varchar	250	√		null
ProtectedLogData	protectionKeyIdentifier	int	10
ProtectedLogData	username	varchar	250	√		null
ProtectedLogExportData	b64LogDataHash	varchar	250	√		null
ProtectedLogExportData	b64PreviosExportHash	varchar	250	√		null
ProtectedLogExportData	b64Signature	text	65535	√		null
ProtectedLogExportData	b64SignatureCertificate	text	65535	√		null
ProtectedLogExportData	currentHashAlgorithm	varchar	250	√		null
ProtectedLogExportData	deleted	tinyint	3
ProtectedLogExportData	exportEndTime	bigint	19
ProtectedLogExportData	exportStartTime	bigint	19
ProtectedLogExportData	pk	varchar	250
ProtectedLogExportData	timeOfExport	bigint	19
ProtectedLogTokenData	b64TokenCertificate	text	65535	√		null
ProtectedLogTokenData	pk	varchar	250
ProtectedLogTokenData	tokenIdentifier	int	10
ProtectedLogTokenData	tokenReference	text	65535	√		null
ProtectedLogTokenData	tokenType	int	10
PublisherData	data	text	65535	√		null
PublisherData	id	int	10
PublisherData	name	varchar	250	√		null
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	timeCreated	bigint	19
PublisherQueueData	tryCounter	int	10
PublisherQueueData	volatileData	text	65535	√		null
ServiceData	data	text	65535	√		null
ServiceData	id	int	10
ServiceData	name	varchar	250	√		null
TableProtectData	dbKey	varchar	250	√		null
TableProtectData	dbType	varchar	250	√		null
TableProtectData	hash	varchar	250	√		null
TableProtectData	hashVersion	int	10
TableProtectData	id	varchar	250
TableProtectData	keyRef	varchar	250	√		null
TableProtectData	keyType	varchar	250	√		null
TableProtectData	protectionAlg	varchar	250	√		null
TableProtectData	signature	varchar	250	√		null
TableProtectData	time	bigint	19
TableProtectData	version	int	10
UserData	cAId	int	10
UserData	cardnumber	varchar	19	√		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	status	int	10
UserData	subjectAltName	text	65535	√		null
UserData	subjectDN	varchar	250	√		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	text	65535	√		null
UserDataSourceData	id	int	10
UserDataSourceData	name	varchar	250	√		null
UserDataSourceData	updateCounter	int	10