EN
Español
English
Português
    ASMS_FORM

    Contains information for the form designer

    Data model

    Fields

    Field Type Description
    description* NVARCHAR (500) Form Description
    id* INT Unique Form Identifier
    is_active* BIT Indicates whether the form is active, (0 = inactive, 1 = active)
    item_type_id* INT Case type identifier, reference table ASMS_TYPES.id
    layout NVARCHAR (MAX) Form configuration data in Json format
    model_id INT Identifier of the model associated with the form, references the ASMS_MODEL.id table
    name* NVARCHAR (100) Name identifying the form
    project_id INT Related project ID, reference table ASMS_PROJECTS.proj_id

    Primary Key

    PK_ASMS_FORM
    id

    References

    Column Referenced Table Referenced column Name
    item_type_id* dbo.ASMS_TYPES id FK03_ASMS_FORM
    model_id dbo.ASMS_MODEL id FK01_ASMS_FORM
    project_id dbo.ASMS_PROJECTS proj_id FK02_ASMS_FORM