Table ejbca.PublisherQueueData 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
timeCreated bigint 19
lastUpdate bigint 19
publishStatus int 10
tryCounter int 10
publishType int 10
fingerprint varchar 250  √  null
publisherId int 10
volatileData text 65535  √  null

Table contained 13,107 rows at Wed Nov 11 10:37 CET 2009

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc PRIMARY
publisherId + publishStatus Performance Asc/Asc publisherqueue_idx1
fingerprint Performance Asc publisherqueue_idx2
publisherId + publishStatus + timeCreated Performance Asc/Asc/Asc publisherqueue_idx3