Understanding the relationship between forms and database tables

This section contains information about:

• The main data table for a form
• The status history table for a form
• The attachment tables for a form
• Currency columns for a form
• Indexing AR System tables
• SQL view creation for a form

The arschema table holds information about each form, including form name, schema ID and next request ID.

When a regular form is created, three or more of the following tables are created in the database to hold the information (requests) for that form:

• Main data table
• Status history table
• Attachment tables
• Currency table