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
issuerDN varchar 250  √  null
subjectDN varchar 250  √  null
cAFingerprint varchar 250  √  null
status int 10
type int 10
serialNumber varchar 250  √  null
expireDate bigint 19
revocationDate bigint 19
revocationReason int 10
base64Cert text 65535  √  null
username varchar 250  √  null
tag varchar 250  √  null
certificateProfileId int 10  √  null
updateTime bigint 19 0

Table contained 2,851,077 rows at Wed Nov 11 10:37 CET 2009

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