Table ejbca.LogEntryData 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
id int 10
adminType int 10
adminData varchar 250  √  null
cAId int 10
module int 10
time bigint 19
username varchar 250  √  null
certificateSNR varchar 250  √  null
event int 10
comment varchar 250  √  null

Table contained 25,771,502 rows at Wed Nov 11 10:37 CET 2009

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
time Performance Asc logentry_idx1
cAId Performance Asc logentry_idx2
event Performance Asc logentry_idx3
username Performance Asc logentry_idx4