Table ejbca.UserData Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
username varchar 250
subjectDN varchar 250  √  null
cAId int 11
subjectAltName varchar 250  √  null
subjectEmail varchar 250  √  null
status int 11
type int 11
clearPassword varchar 250  √  null
passwordHash varchar 250  √  null
timeCreated bigint 20
timeModified bigint 20
endEntityProfileId int 11
certificateProfileId int 11
tokenType int 11
hardTokenIssuerId int 11
extendedInformationData longtext 2147483647  √  null
keyStorePassword varchar 250  √  null

Table contained 25,126 rows at Mon Apr 14 10:52 PDT 2008

Indexes:
Column(s) Type Sort Constraint Name
username Primary key Asc PRIMARY
cAId + timeCreated Performance Asc/Asc userdata_idx2
cAId + timeModified Performance Asc/Asc userdata_idx3
username Performance Asc userdata_idx5