EN
Español
English
Português
    AFW_AUDIT

    Entity Mapping Audit Information

    Data model

    Fields

    Field Type Description
    audi_additional NVARCHAR (2000) Additional data
    audi_application_id* INT App ID, reference to AFW_APPLICATIONS.appl_id
    audi_end_date DATETIME End Date
    audi_id* INT Audit ID
    audi_ip_dest NVARCHAR (100) IP of the destination machine
    audi_machine_dest NVARCHAR (60) Name of the target machine
    audi_machine_source NVARCHAR (100) Machine Origin of Action
    audi_permission_id* INT Permission ID, reference to AFW_PERMISSIONS.perm_id
    audi_start_date* DATETIME Start Date
    audi_user_id* INT User ID, reference to AFW_USERS.user_id

    Primary Key

    PK_AFW_AUDIT
    audi_id

    References

    Column Referenced Table Referenced column Name
    audi_application_id* Bod. AFW_APPLICATIONS appl_id FK01_AFW_AUDIT
    audi_permission_id* Bod. AFW_PERMISSIONS perm_id FK02_AFW_AUDIT
    audi_user_id* dbo.AFW_USERS user_id FK03_AFW_AUDIT