Table ejbca.ProtectedLogData 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
pk varchar 250
adminType int 10
adminData varchar 250  √  null
cAId int 10
module int 10
eventTime bigint 19
username varchar 250  √  null
certificateSerialNumber varchar 250  √  null
certificateIssuerDN varchar 250  √  null
eventId int 10
eventComment text 65535  √  null
nodeGUID int 10
counter bigint 19
nodeIP varchar 250  √  null
b64LinkedInEventIdentifiers text 65535  √  null
b64LinkedInEventsHash varchar 250  √  null
currentHashAlgorithm varchar 250  √  null
protectionKeyIdentifier int 10
protectionKeyAlgorithm varchar 250  √  null
b64Protection text 65535  √  null

Table contained 569 rows at Wed Nov 11 10:37 CET 2009

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc PRIMARY
nodeGUID + counter Performance Asc/Asc protectedlogdata_idx1
nodeGUID + eventTime + b64Protection Performance Asc/Asc/Asc protectedlogdata_idx2
username + cAId + module Performance Asc/Asc/Asc protectedlogdata_idx3
eventTime + cAId + module Performance Asc/Asc/Asc protectedlogdata_idx4