EN
Español
English
Português
    ASDK_MAIL_LOG

    Contains the relationship between incoming/outgoing emails and their relationship to the case

    Data model

    Fields

    Field Type Description
    config_id INT Identifier of the associated mail configuration, reference the table ASDK_MAIL_CONFIG.cnf_id
    item_type INT Identifier of the type of record (Incident, Change, Problem, Request, Request among others), reference the table ASMS_TYPES.id
    plap_arrivedate DATETIME Date of receipt of the message
    plap_createdate DATETIME Record creation date
    plap_id* INT Unique mail log identifier
    plap_id_asdk* INT Associated case identifier, reference the ASDK_ITEM.id table
    plap_msg_id* VARCHAR (255) Unique message identifier
    plap_msg_subject NVARCHAR (2000) Subject of the message
    type INT Mail log type, (Inbox = 0, Outbox = 1)
    unique_id VARCHAR (255) Unique mail identifier

    Primary Key

    PK_ASDK_MAIL_LOG
    plap_id

    References

    Column Referenced Table Referenced column Name
    config_id dbo.ASDK_MAIL_CONFIG cnf_id FK01_ASDK_MAIL_LOG