Considerations for Creating Tables

You use SBM Composer to create primary and auxiliary tables for your applications. Fields in the primary table are used to collect information about primary items, such as the item ID and owner. Fields in auxiliary tables are used to collect other information, such as a company name or customer address. SBM Composer provides an extensive set of system and custom field types for the purpose of collecting information for primary and auxiliary items.

Before configuring a primary table, carefully consider its purpose, what types of information you want to display in state forms, and what data you want to collect in transition forms. Consider who can see the information in state forms and who can provide the data in transition forms.

New tables you add to the application are defined as auxiliary tables and typically contain information that supports the items in the primary table. Before configuring an auxiliary table, decide what type of auxiliary information is important to include in the application to support the workflow.