Where is the schema configuration in the database?

Get Help
1

Where is the schema configuration info stored in the database?

2

Hi @fedoras,

Thanks for your question!

Schema Config data for each discipline is stored primarily in three localization tables that control how table and field metadata appears per discipline and language. The main table-level records live in SpLocaleContainer, field- or relationship-level records live in SpLocaleContainerItem, and localized labels and usage text live in SpLocaleItemStr.

In practice, this means each discipline has its own table-level schema config entries, each table entry has item rows for fields and relationships, and the human-readable name and description strings are stored separately for localization.

  • SpLocaleContainer: one record per configured table per discipline, including table-level settings like formatting and visibility
  • SpLocaleContainerItem: records for individual fields and relationships within each configured table, including required and hidden settings
  • SpLocaleItemStr: localized name and description text for both table-level and item-level schema config entries

Pick lists in the Schema Config are stored in PickList and PickListItem. PickList defines the pick list itself, including type and source metadata, while PickListItem stores the actual selectable values when the pick list type uses explicit items. Schema Config references these pick lists through pick list name fields, so field formatting choices in Schema Config connect directly to pick list definitions stored in these database tables.