EN
Español
English
Português
    ADM_CREDENTIAL

    Table that stores credential settings

    Data model

    Fields

    Field Type Description
    additional_data NVARCHAR (MAX) Additional properties of the created credential is stored in json format
    creation_date* DATETIME Date of creation
    creator_user* INT Authoring User
    credential_type* INT Associated Credential Type
    description* NVARCHAR (50) Short Credential Description
    id* INT Unique identifier of the table
    password* NVARCHAR (510) Credential Password
    update_date DATETIME Date of update
    updater_user INT Update User
    username* NVARCHAR (510) Username

    Primary Key

    PK_ADM_CREDENTIAL
    id

    References

    Column Referenced Table Referenced column Name
    creator_user* dbo.AFW_USERS user_id FK01_ADM_CREDENTIAL
    updater_user dbo.AFW_USERS user_id FK02_ADM_CREDENTIAL