EN
Español
English
Português
    ASMS_RULES

    Contains ASMS rule configuration information

    Data model

    Fields

    Field Type Description
    activa INT Identify if the rule is active
    clone_change* BIT Identifies if a rule has been cloned and in the cloning process the model has changed
    common_id INT External rule ID
    condiciones NVARCHAR (510) Set of conditions expressed in terms C1 … Cn
    description NVARCHAR (500) Description of the rule
    fl_dat_inserted DATETIME Rule Creation Date
    fl_dat_modified DATETIME Last Rule Modification Date
    fl_int_project_id INT Rule project ID
    label NVARCHAR (8000) Set of conditions expressed in natural language
    model_id INT Rule model identifier
    name NVARCHAR (510) Rule Name
    rule_id* INT Unique identifier of the table
    rule_order* INT Order of execution of the rule
    rule_type INT Rule Type
    table_id INT Identifier of the concept to which the rule applies
    text NVARCHAR (8000) Set of conditions expressed in the development language
    user_change_id INT Identifies the user who has performed the activation process of the cloned rule

    Primary Key

    PK_ASMS_RULES
    rule_id

    References

    Column Referenced Table Referenced column Name
    fl_int_project_id dbo.ASMS_PROJECTS proj_id FK02_ASMS_RULES
    model_id dbo.ASMS_MODEL id FK01_ASMS_RULES
    table_id dbo.ASMS_TYPES id FK03_ASMS_RULES
    user_change_id dbo.AFW_USERS user_id FK04_ASMS_RULES