Table ejbca.ApprovalData 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
id int 11
approvalid int 11
approvaltype int 11
endentityprofileid int 11
caid int 11
reqadmincertissuerdn varchar 250  √  null
reqadmincertsn varchar 250  √  null
status int 11
approvaldata longtext 2147483647  √  null
requestdata longtext 2147483647  √  null
requestdate bigint 20
expiredate bigint 20
remainingapprovals int 11

Table contained 15 rows at Mon Apr 14 10:52 PDT 2008

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY