Page Comparison

...

• AO_4025C4_CONFIGURATION_DAO

  • App configuration data. You don't have to migrate this, you can just use the Easy Forms admin tool to setup configuration on your new instance

    • CREATED

      • timestamp

    • DESCRIPTOR

      • JSON descriptor like

        Code Block
        {"notifyWorkboxEditors":true,"notifyWorkboxUsers":false,"notifyWorkboxUsersList":"","notifyEmailIncludeData":false,"notifyEmailEditors":false,"notifyEmailUsers":false,"notifyEmailUsersList":"","notifyHipChatServer":"api.hipchat.com","notifyHipChatRoomToken":"","notifyWebhookUrl":""}

    • ID

      • PK id

    • UPDATED

      • timestamp

• AO_4025C4_FORM

  • Defines forms (not submitted form data)

  • CREATED_BY, UPDATED_BY contain user keys that may need to be transformed

  • PAGE_ID contains page IDs that may need to be transformed

    • CREATED

      • timestamp

    • CREATED_BY

      • user key

    • DESCRIPTOR

      • JSON descriptor like

        Code Block
        {"fields":[{"label":"Between 1 and 10 (inclusive)", "field_type":"number", "required":true, "field_options":...

      • FIELD_ORDER

        • ids of FORM_FIELD rows, comma separated, in order

      • HIP_CHAT_ROOM_TOKEN

      • ID

        • PK id

      • NAME

      • PAGE_ID

      • REPORTS _UNRESTRICTED

      • TITLE

      • UPDATED

        • timestamp

      • UPDATED_BY

        • user key

• AO_4025C4_FORM_FIELD

  • Defines fields in forms, FK to the form table (not submitted form data)

    • CID

      • client ID

    • CREATED

      • timestamp

    • DELETED

      • TRUE if deleted

    • FIELD_OPTIONS

      • JSON data like

        Code Block
        {"min":"1", "max":"10", "description":"", "integer_only":false}

    • FORM_ID

      • FK id of parent form

    • ID

      • PK id

    • LABEL

    • PLUGIN_VERSION

    • REQUIRED

    • TYPE

      • number, text, etc.

    • UID

    • UPDATED

      • timestamp

• AO_4025C4_SUBMISSION

  • User submissions for the forms

  • USER_KEY contain user keys that may need to be transformed

  • Data migration is only necessary if you want to preserve old submissions

• AO_4025C4_SUBMISSSION_FIELD

  • User submissions for fields on the forms, FK to the submission table

...