EN
Español
English
Português
    ASS_ARTICLE

    Contains information from Knowledge Base articles

    Data model

    Fields

    Field Type Description
    author_id* INT Identifier of the user who authored the article, references the table AFW_USERS.user_id
    class_id INT Article Source Type, 0 Internal (Embedded), 1 External (Url)
    closed_date DATETIME Date the item entered closed status
    content NVARCHAR (MAX) Current Article Content
    created_date DATETIME Article creation date
    description NVARCHAR (510) Article Overview
    group_id* INT Identifier of the specialist group to which the responsible user belongs, reference the table AFW_GROUPS.grou_id
    hit FLOAT Identify the total number of views of the item
    id* INT Unique Item Identifier
    identifier NVARCHAR (510) Alphanumeric code identifying the item
    integration_id INT Integration record identifier related to the item, reference the ASMS_INTEGRATIONS.ID table
    interface_id NVARCHAR (200) Identifier of the source system related to the article, this is given by integration
    is_public INT Identify whether or not the item is public to the customer (0 = not public, 1 = public)
    keyword NVARCHAR (510) List of keywords related to the article
    modified_date DATETIME Last Date of Article Modification
    modifier_id* INT Identifier of the last user who modified the article, references the table AFW_USERS.user_id
    previous_status_id INT Previous status identifier related to the item, reference the table ASMS_STATUS.stat_id
    project_id* INT Project ID related to the article, reference the table ASMS_PROJECTS.proj_id
    rating FLOAT Identify the average grade of the item
    reason_id INT Identifier of the reason for the current status related to the item, reference the table ASMS_STATUS_REASON.reas_id
    responsible_id* INT Responsible user ID assigned to the item, reference table AFW_USERS.user_id
    state_id* INT Identifier of the current status related to the item, reference the table ASMS_STATUS.stat_id
    title* NVARCHAR (510) Article Title
    type_id* INT Item model type identifier, reference table ASMS_MODEL.id
    url NVARCHAR (2000) If the source of the article is external, it represents the url where the article is hosted

    Primary Key

    PK_ASS_ARTICLE
    id

    References

    Column Referenced Table Referenced column Name
    author_id* dbo.AFW_USERS user_id FK06_ASS_ARTICLE
    group_id* dbo.AFW_GROUPS grou_id FK03_ASS_ARTICLE
    modifier_id* dbo.AFW_USERS user_id FK07_ASS_ARTICLE
    project_id* dbo.ASMS_PROJECTS proj_id FK08_ASS_ARTICLE
    reason_id dbo.ASMS_STATUS_REASON reas_id FK04_ASS_ARTICLE
    responsible_id* dbo.AFW_USERS user_id FK02_ASS_ARTICLE
    state_id* dbo.ASMS_STATUS stat_id FK01_ASS_ARTICLE
    type_id* dbo.ASMS_MODEL id FK05_ASS_ARTICLE