| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| username |
varchar |
250 |
|
|
|
|
|
| subjectDN |
varchar |
250 |
√ |
|
null |
|
|
| cAId |
int |
10 |
|
|
|
|
|
| subjectAltName |
text |
65535 |
√ |
|
null |
|
|
| subjectEmail |
varchar |
250 |
√ |
|
null |
|
|
| status |
int |
10 |
|
|
|
|
|
| type |
int |
10 |
|
|
|
|
|
| clearPassword |
varchar |
250 |
√ |
|
null |
|
|
| passwordHash |
varchar |
250 |
√ |
|
null |
|
|
| timeCreated |
bigint |
19 |
|
|
|
|
|
| timeModified |
bigint |
19 |
|
|
|
|
|
| endEntityProfileId |
int |
10 |
|
|
|
|
|
| certificateProfileId |
int |
10 |
|
|
|
|
|
| tokenType |
int |
10 |
|
|
|
|
|
| hardTokenIssuerId |
int |
10 |
|
|
|
|
|
| extendedInformationData |
longtext |
2147483647 |
√ |
|
null |
|
|
| keyStorePassword |
varchar |
250 |
√ |
|
null |
|
|
| cardnumber |
varchar |
19 |
√ |
|
null |
|
|
Table contained 2,795,312 rows at Wed Nov 11 10:37 CET 2009
|