Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| SecurityId | INT | 10 | √ | null |
|
|
||
| UserId | INT | 10 | null |
|
|
|||
| SecurityToken | VARCHAR | 50 | null |
|
|
|||
| IssuedDate | DATETIME | 19 | null |
|
|
UTC |
||
| AbsoluteExpirationDate | DATETIME | 19 | null |
|
|
UTC |
||
| VerificationKey | TEXT | 65535 | null |
|
|
|||
| IsEnabled | BIT | 1 | null |
|
|
|||
| CreatedBy | VARCHAR | 50 | null |
|
|
|||
| CreateDate | DATETIME | 19 | null |
|
|
UTC |
||
| UpdatedBy | VARCHAR | 50 | null |
|
|
|||
| UpdateDate | DATETIME | 19 | null |
|
|
UTC |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | SecurityId |
| token | Performance | Asc | SecurityToken |
Diagram producer might be missing
No diagrams were produced please see application output for any errors