Application schema metadata

Schema metadata about tables includes this information:

  • The application module in which a table belongs
  • Data about table triggers, such as whether a primary key is generated, whether inserts or updates are allowed, and so on
  • Data about AlphaKeys, which are system-generated values used as keys
  • Data about AlphaKeys (or Next Keys), which are system-generated values used as keys
  • Data about user extended table (UET) inheritance
  • Data about views generated for multi-site tables
  • Data about application-specific table extensions, such as ERDBGW population for APS

The system refers to this metadata when generating table triggers.

Note:  When you create a new table, first try generating and testing table triggers without adding your table to the metadata. If it works the way you want, do not add it to the metadata. Otherwise, refer to this section and the related topics to determine how to add metadata to adjust the generation.

The document Insert and Update Trigger Generation explains in much greater detail the specifics of this metadata and its use in the system.