Table ejbca.CRLData 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
base64Crl longtext 2147483647
cAFingerprint varchar 250
cRLNumber int 10
deltaCRLIndicator int 10
issuerDN varchar 250
nextUpdate bigint 19
rowProtection longtext 2147483647  √  null
rowVersion int 10
thisUpdate bigint 19

Table contained 8,109 rows at Tue Dec 11 09:25 CET 2018

Indexes:
Column(s) Type Sort Constraint Name
fingerprint Primary key Asc PRIMARY
cRLNumber + issuerDN Must be unique Asc/Asc crldata_idx3
issuerDN + deltaCRLIndicator + cRLNumber Performance Asc/Asc/Asc crldata_idx4