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
    caption NVARCHAR (100) Additional field identifier
    catalog_id INT Associated catalog ID (if it is a catalog type field)
    datasource_id INT Identifier of the associated datasource (if the data source is a web service)
    description* NVARCHAR (500) Description of the additional field
    enable_predictive_search BIT Indicates that the additional field accepts predictive search
    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, Requirement, Request among others)
    model_id INT Associated model identifier
    name* NVARCHAR (100) Name of the additional field
    project_id INT Associated project 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