Group Defaults

Enterprise Database Server groups are modeled in SQL according to the following rules and default mappings:

  • Occurring groups are modeled as separate tables. For more information, see Embedded Data Set and Occurring Item Defaults earlier in this section.

  • Nonoccurring groups are not modeled. However, all nonoccurring, nongroup items contained in the group are modeled as columns in the containing table. Nonoccurring items contained in nested nonoccurring groups are also modeled as columns in the containing table.

  • Occurring items in nonoccurring groups are modeled as separate tables. For more information, see Embedded Data Set and Occurring Item Defaults earlier in this section.