Table ejbca.CertificateData Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
fingerprint varchar 250
cAFingerprint varchar 250  √  null
certificateProfileId int 10
endEntityProfileId int 10  √  null
expireDate bigint 19
issuerDN varchar 250
notBefore bigint 19  √  null
revocationDate bigint 19
revocationReason int 10
rowVersion int 10
serialNumber varchar 250
status int 10
subjectAltName varchar 2000  √  null
subjectDN varchar 400
subjectKeyId varchar 250  √  null
tag varchar 250  √  null
type int 10
updateTime bigint 19
username varchar 250  √  null
base64Cert longtext 2147483647  √  null
rowProtection longtext 2147483647  √  null

Table contained 356,230 rows at Tue Dec 11 09:25 CET 2018

Indexes:
Column(s) Type Sort Constraint Name
fingerprint Primary key Asc PRIMARY
subjectKeyId Performance Asc certificatedata_idx11
serialNumber + issuerDN Performance Asc/Asc certificatedata_idx12
username Performance Asc certificatedata_idx2
subjectDN Performance Asc certificatedata_idx4
type Performance Asc certificatedata_idx5
issuerDN + status Performance Asc/Asc certificatedata_idx6
certificateProfileId Performance Asc certificatedata_idx7