EN
Español
English
Português
    AMDM_DOUBLE_VALIDATION_CODES

    Stores security code information for double validation

    Data model

    Fields

    Field Type Description
    action_id* INT Identifier of the action that is executed when requesting the security code, reference to the AMDM_SECURITYVALIDATION_ACTION.id table
    expirationdate* DATETIME Expiration date of the security code for double validation
    id* INT Unique identifier of a security code for double validation
    requestdate* DATETIME Date of request for the security code for double validation
    user_id* INT Identifier of the user requesting the security code, reference to the AFW_USERS.user_id table
    validationcode* CHAR (6) Security code for double validation

    Primary Key

    PK_AMDMDOUBLEVALIDATIONCODES
    id

    References

    Column Referenced Table Referenced column Name
    action_id* dbo.AMDM_SECURITYVALIDATION_ACTION id FK02_AMDMDOUBLEVALIDATIONCODE
    user_id* dbo.AFW_USERS user_id FK01_AMDMDOUBLEVALIDATIONCODE