Table ejbca.CertificateData 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
fingerprint varchar 250
issuerDN varchar 250  √  null
subjectDN varchar 250  √  null
cAFingerprint varchar 250  √  null
status int 11
type int 11
serialNumber varchar 250  √  null
expireDate bigint 20
revocationDate bigint 20
revocationReason int 11
base64Cert text 65535  √  null
username varchar 250  √  null

Table contained 26,922 rows at Mon Apr 14 10:52 PDT 2008

Indexes:
Column(s) Type Sort Constraint Name Anomalies
fingerprint Primary key Asc PRIMARY  
issuerDN + serialNumber Must be unique Asc/Asc cert_issuer_serno These unique columns are also nullable