Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| clientidentifier | VARCHAR | 255 | '' |
|
|
OAuth2 client identifier |
||||
| secret | VARCHAR | 64 | '' |
|
|
OAuth2 Client secret |
||||
| expirytime | BIGINT | 19 | null |
|
|
Expiry timestamp |
||||
| revoked | BIT | 3 | 0 |
|
|
Whether the OAuth2 Client secret is revoked |
||||
| timecreated | BIGINT | 19 | null |
|
|
Creation timestamp |
||||
| lastaccessed | BIGINT | 19 | √ | NULL |
|
|
Timestamp when the client secret was last successfully used to authenticate a client |
|||
| lastexpirynotification | BIGINT | 19 | √ | NULL |
|
|
Timestamp when the last secret expiry notification was dispatched for this secret |
|||
| expiryprocessed | BIT | 3 | 0 |
|
|
Whether the natural expiry of the secret has been processed (0 = not processed, which includes secrets that have not yet expired; 1 = processed) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| oautservcliesecr_cli_ix | Performance | Asc | clientidentifier |
| oautservcliesecr_expexp_ix | Performance | Asc/Asc | expiryprocessed + expirytime |