EN
Español
English
Português
    AAM_DEVICE_RECORD_ACT_REQ

    Activity Log Table

    Data model

    Fields

    Field Type Description
    activity_description VARCHAR (200) Description of the activity carried out
    activity_record_type_id* INT Type of activity
    device_id* INT Device table identifier [AAM_device].[id]
    device_name VARCHAR (500) Device Name
    device_software_id INT Device Software Table ID
    id* INT Primary Key Table Identifier
    request_date* DATETIME Date on which the activity was recorded
    task_detail_id INT Agent task table ID [AAM_AGENT_TASK_DETAIL].[id]
    user_id INT User Table Identifier [AFW_USERS].[id]
    user_name VARCHAR (500) Username

    Primary Key

    PK_AAM_DEVICE_RECORD_ACT_REQ
    id

    References

    Column Referenced Table Referenced column Name
    activity_record_type_id* Bod. AAM_DEVICE_REC_ACT_TYPE id FK02_AAM_DEVICE_RECORD_ACT_REQ
    task_detail_id Bod. AAM_AGENT_TASK_DETAIL id FK01_AAM_DEVICE_RECORD_ACT_REQ