Table ejbca.UserData 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
username varchar 250
cAId int 10
cardNumber varchar 250  √  null
certificateProfileId int 10
clearPassword varchar 250  √  null
endEntityProfileId int 10
hardTokenIssuerId int 10
keyStorePassword varchar 250  √  null
passwordHash varchar 250  √  null
rowVersion int 10
status int 10
subjectAltName varchar 8192  √  null
subjectDN varchar 400  √  null
subjectEmail varchar 250  √  null
timeCreated bigint 19
timeModified bigint 19
tokenType int 10
type int 10
extendedInformationData longtext 2147483647  √  null
rowProtection longtext 2147483647  √  null

Table contained 253,126 rows at Tue Dec 11 09:25 CET 2018

Indexes:
Column(s) Type Sort Constraint Name
username Primary key Asc PRIMARY
subjectDN Performance Asc userdata_idx10
status Performance Asc userdata_idx11