EN
Español
English
Português
    AVS_AUDIT_FILE_LIST

    Stores the additional data for AVS audit file listing events

    Data model

    Fields

    Field Type Description
    action* INT Share ID code
    audit_device_id* INT Unique identifier of the associated materialized device
    audit_group_support_id INT Unique identifier of the associated materialized support group
    audit_user_id* INT Unique identifier of the associated materialized user
    creation_date* DATETIME Record creation date
    date_key* INT Key with date information
    directory* NVARCHAR (8000) Listed folder path
    message NVARCHAR (8000) Additional listing messages, possibly error messages
    source* BIT Indicates where the file listing was made
    time_key* INT Key with time information

    Primary Key

    PK01_AVS_AUDIT_FILE_LIST
    audit_user_id, audit_device_id, action, date_key, time_key

    References

    Column Referenced Table Referenced column Name
    audit_device_id* dbo.AVS_AUDIT_DEVICE id FK02_AVS_AUDIT_FILE_LIST
    audit_group_support_id dbo.AVS_AUDIT_GROUP_SUPPORT id FK03_AVS_AUDIT_FILE_LIST
    audit_user_id* dbo.AVS_AUDIT_USERS id FK01_AVS_AUDIT_FILE_LIST