OATH
The TIDMA_OATH table lists the specific attributes of OATH credentials. It holds the information in which authentication mode OATH credentials work, which hashing algorithm is used, and of how many digits the token consists. The counter/time is also stored in this table.
The TIDMA_OATH table is an extension of the TIDMA_CREDENTIAL, which lists attributes that are valid for all credentials.
Database table TIDMA_OATH
| DB attribute | Java data type (max. size), defaults | Description |
|---|---|---|
| authentication_method_id | Long, not NULL | The ID of the OATH authentication method to use.1: HOTP; 2: TOTP |
| counter | Long, not NULL | The counter for tokens. This is increased on each successful authentication. |
| credential_id | Long, not NULL | Primary key (uniquely identifies each individual credential). Foreign key that links to information in the table TIDMA_CREDENTIAL. |
| digits | Integer, not NULL | The length of the generated token. Possible options: 6; 7; 8 |
| hashing_algorithm_id | Long, not NULL | The ID of the OATH hashing algorithm to use. Possible options: 1: SHA1; 2: SHA256; 3: SHA512 |
| is_shared | Boolean, not null | Flag to make sure the credential is only shared once. |
| period | Long, not NULL | The time window (in seconds) how long a TOTP token is valid. |
| time_drift | Long, nullable | Detected clock drift for the token in terms of the number of time steps. |