EN
Español
English
Português
    ASMS_MAIL_TEMPLATE

    Contains the information of the mail templates configured for the ASMS suite

    Data model

    Fields

    Field Type Description
    body NVARCHAR (MAX) Mail message body
    hide_header BIT Determine whether or not to send header in mail templates
    id* INT Unique mail template identifier
    is_default* BIT Indicates if the template is the default, (True = 1, False = 0)
    is_html* BIT Indicates whether the message body supports HTML, (True = 1, False = 0)
    model_id INT Identifier of the associated model, reference the ASMS_MODEL.id table
    name* NVARCHAR (100) Mail template name
    project_id INT Associated project ID, reference table ASMS_PROJECTS.proj_id
    sender NVARCHAR (2000) Email sender
    sender_name NVARCHAR (2000) Email sender name
    subject NVARCHAR (510) Subject of the email message
    type_id INT Identifier of the type of record (Incident, Change, Problem, Request, Request among others), reference the table ASMS_TYPES.id

    Primary Key

    PK_ASMS_MAIL_TEMPLATE
    id

    References

    Column Referenced Table Referenced column Name
    model_id dbo.ASMS_MODEL id FK03_ASMS_MAIL_TEMPLATE
    project_id dbo.ASMS_PROJECTS proj_id FK02_ASMS_MAIL_TEMPLATE
    type_id dbo.ASMS_TYPES id FK01_ASMS_MAIL_TEMPLATE