EN
Español
English
Português
    ASMS_FIELDS

    Contains the information of the additional fields configured for the ASMS suite

    Data model

    Fields

    Field Type Description
    builtin_id INT Factory additional field identifier, reference table ASMS_FIELDS_BUILTIN.id
    caption NVARCHAR (100) Additional field identifier
    catalog_id INT Identifier of the associated catalog (if it is a catalog type field), reference the table AFW_CATALOG.cata_id
    datasource_id INT Identifier of the associated datasource (if the data source is a web service), references the ASMS_FIELDS_DATASOURCE.id table
    description* NVARCHAR (500) Description of the additional field
    field_order INT Describes the order in which the additional field is displayed
    field_type_id* INT Field type identifier (Combo, Date, Text, Checkbox, Long Text, Numeric Text, etc.)
    has_dependencies BIT Indicates that the additional field has additional dependent fields
    id* INT Unique identifier of the additional field
    item_type_id* INT Identifier of the type of record (Incident, Change, Problem, Request, Request among others), reference the table ASMS_TYPES.id
    model_id INT Identifier of the associated model, reference the ASMS_MODEL.id table
    name* NVARCHAR (100) Name of the additional field
    project_id INT Associated project ID, reference table ASMS_PROJECTS.proj_id

    Primary Key

    PK_ASMS_FIELDS
    id

    References

    Column Referenced Table Referenced column Name
    builtin_id Bod. ASMS_FIELDS_BUILTIN id FK03_ASMS_FIELDS
    datasource_id dbo.ASMS_FIELDS_DATASOURCE id FK05_ASMS_FIELDS
    item_type_id* dbo.ASMS_TYPES id FK04_ASMS_FIELDS
    model_id dbo.ASMS_MODEL id FK01_ASMS_FIELDS
    project_id dbo.ASMS_PROJECTS proj_id FK02_ASMS_FIELDS