Repository Docs & Knowledge Base

Consolidated Spensara documentation repository (722 Markdown & architecture documents in ../repository)

Built Word Documents (.docx): Spensara Overview (.docx) Capability Assessment (.docx) Brink POS Ingestion Analysis (.docx) The Borg Ingestion Architecture (.docx)

Warehouse Model (93)

Analytical data warehouse schemas, curated tables, and Redshift/Athena data models.

warehouse-model/docs/features/ETL/warehouse-data/curated-model/pos_modifiers.md 27,297 bytes · Updated Oct 23, 2026 10:44 AM EDT

Raw File

curated.pos_modifiers

Purpose

This table stores modifier-group definitions and their flattened item membership in the current POS-oriented curated contract. It is useful for understanding what options can be added to items, how many are allowed, and what pricing or weighting rules apply.

The table preserves a wide legacy column layout, so each numbered slot represents a source-positioned member, price, or rule rather than a normalized child table.

Schema contract

The deployed SQL under backend/Kds.Ai.Warehouse/Sql/Bootstrap/Tenant/Curated/ is the source of truth for the current column names, types, and nullability.

Column groups

Business properties describe the business entity, event, fact, or reference record represented by the table.
Technical and ETL properties describe warehouse lineage, surrogate keys, source reconciliation, tenant scoping, slowly changing dimension controls, and ingestion metadata.

Business properties

Column	Type	Nullable	Business Meaning
`id`	`INTEGER`	Yes	Modifier group identifier.
`longname`	`VARCHAR(40)`	Yes	Longer modifier-group name.
`free`	`INTEGER`	Yes	Number of modifiers included at no charge.
`item01`	`INTEGER`	Yes	Modifier group member in slot 01.
`item02`	`INTEGER`	Yes	Modifier group member in slot 02.
`item03`	`INTEGER`	Yes	Modifier group member in slot 03.
`item04`	`INTEGER`	Yes	Modifier group member in slot 04.
`item05`	`INTEGER`	Yes	Modifier group member in slot 05.
`item06`	`INTEGER`	Yes	Modifier group member in slot 06.
`item07`	`INTEGER`	Yes	Modifier group member in slot 07.
`item08`	`INTEGER`	Yes	Modifier group member in slot 08.
`item09`	`INTEGER`	Yes	Modifier group member in slot 09.
`item10`	`INTEGER`	Yes	Modifier group member in slot 10.
`item11`	`INTEGER`	Yes	Modifier group member in slot 11.
`item12`	`INTEGER`	Yes	Modifier group member in slot 12.
`item13`	`INTEGER`	Yes	Modifier group member in slot 13.
`item14`	`INTEGER`	Yes	Modifier group member in slot 14.
`item15`	`INTEGER`	Yes	Modifier group member in slot 15.
`item16`	`INTEGER`	Yes	Modifier group member in slot 16.
`item17`	`INTEGER`	Yes	Modifier group member in slot 17.
`item18`	`INTEGER`	Yes	Modifier group member in slot 18.
`item19`	`INTEGER`	Yes	Modifier group member in slot 19.
`item20`	`INTEGER`	Yes	Modifier group member in slot 20.
`item21`	`INTEGER`	Yes	Modifier group member in slot 21.
`item22`	`INTEGER`	Yes	Modifier group member in slot 22.
`item23`	`INTEGER`	Yes	Modifier group member in slot 23.
`item24`	`INTEGER`	Yes	Modifier group member in slot 24.
`item25`	`INTEGER`	Yes	Modifier group member in slot 25.
`item26`	`INTEGER`	Yes	Modifier group member in slot 26.
`item27`	`INTEGER`	Yes	Modifier group member in slot 27.
`item28`	`INTEGER`	Yes	Modifier group member in slot 28.
`item29`	`INTEGER`	Yes	Modifier group member in slot 29.
`item30`	`INTEGER`	Yes	Modifier group member in slot 30.
`item31`	`INTEGER`	Yes	Modifier group member in slot 31.
`item32`	`INTEGER`	Yes	Modifier group member in slot 32.
`item33`	`INTEGER`	Yes	Modifier group member in slot 33.
`item34`	`INTEGER`	Yes	Modifier group member in slot 34.
`item35`	`INTEGER`	Yes	Modifier group member in slot 35.
`item36`	`INTEGER`	Yes	Modifier group member in slot 36.
`item37`	`INTEGER`	Yes	Modifier group member in slot 37.
`item38`	`INTEGER`	Yes	Modifier group member in slot 38.
`item39`	`INTEGER`	Yes	Modifier group member in slot 39.
`item40`	`INTEGER`	Yes	Modifier group member in slot 40.
`item41`	`INTEGER`	Yes	Modifier group member in slot 41.
`item42`	`INTEGER`	Yes	Modifier group member in slot 42.
`item43`	`INTEGER`	Yes	Modifier group member in slot 43.
`item44`	`INTEGER`	Yes	Modifier group member in slot 44.
`item45`	`INTEGER`	Yes	Modifier group member in slot 45.
`item46`	`INTEGER`	Yes	Modifier group member in slot 46.
`item47`	`INTEGER`	Yes	Modifier group member in slot 47.
`item48`	`INTEGER`	Yes	Modifier group member in slot 48.
`item49`	`INTEGER`	Yes	Modifier group member in slot 49.
`item50`	`INTEGER`	Yes	Modifier group member in slot 50.
`item51`	`INTEGER`	Yes	Modifier group member in slot 51.
`item52`	`INTEGER`	Yes	Modifier group member in slot 52.
`item53`	`INTEGER`	Yes	Modifier group member in slot 53.
`item54`	`INTEGER`	Yes	Modifier group member in slot 54.
`price01`	`BIGINT`	Yes	Price override for slot 01.
`price02`	`BIGINT`	Yes	Price override for slot 02.
`price03`	`BIGINT`	Yes	Price override for slot 03.
`price04`	`BIGINT`	Yes	Price override for slot 04.
`price05`	`BIGINT`	Yes	Price override for slot 05.
`price06`	`BIGINT`	Yes	Price override for slot 06.
`price07`	`BIGINT`	Yes	Price override for slot 07.
`price08`	`BIGINT`	Yes	Price override for slot 08.
`price09`	`BIGINT`	Yes	Price override for slot 09.
`price10`	`BIGINT`	Yes	Price override for slot 10.
`price11`	`BIGINT`	Yes	Price override for slot 11.
`price12`	`BIGINT`	Yes	Price override for slot 12.
`price13`	`BIGINT`	Yes	Price override for slot 13.
`price14`	`BIGINT`	Yes	Price override for slot 14.
`price15`	`BIGINT`	Yes	Price override for slot 15.
`price16`	`BIGINT`	Yes	Price override for slot 16.
`price17`	`BIGINT`	Yes	Price override for slot 17.
`price18`	`BIGINT`	Yes	Price override for slot 18.
`price19`	`BIGINT`	Yes	Price override for slot 19.
`price20`	`BIGINT`	Yes	Price override for slot 20.
`price21`	`BIGINT`	Yes	Price override for slot 21.
`price22`	`BIGINT`	Yes	Price override for slot 22.
`price23`	`BIGINT`	Yes	Price override for slot 23.
`price24`	`BIGINT`	Yes	Price override for slot 24.
`price25`	`BIGINT`	Yes	Price override for slot 25.
`price26`	`BIGINT`	Yes	Price override for slot 26.
`price27`	`BIGINT`	Yes	Price override for slot 27.
`price28`	`BIGINT`	Yes	Price override for slot 28.
`price29`	`BIGINT`	Yes	Price override for slot 29.
`price30`	`BIGINT`	Yes	Price override for slot 30.
`price31`	`BIGINT`	Yes	Price override for slot 31.
`price32`	`BIGINT`	Yes	Price override for slot 32.
`price33`	`BIGINT`	Yes	Price override for slot 33.
`price34`	`BIGINT`	Yes	Price override for slot 34.
`price35`	`BIGINT`	Yes	Price override for slot 35.
`price36`	`BIGINT`	Yes	Price override for slot 36.
`price37`	`BIGINT`	Yes	Price override for slot 37.
`price38`	`BIGINT`	Yes	Price override for slot 38.
`price39`	`BIGINT`	Yes	Price override for slot 39.
`price40`	`BIGINT`	Yes	Price override for slot 40.
`price41`	`BIGINT`	Yes	Price override for slot 41.
`price42`	`BIGINT`	Yes	Price override for slot 42.
`price43`	`BIGINT`	Yes	Price override for slot 43.
`price44`	`BIGINT`	Yes	Price override for slot 44.
`price45`	`BIGINT`	Yes	Price override for slot 45.
`price46`	`BIGINT`	Yes	Price override for slot 46.
`price47`	`BIGINT`	Yes	Price override for slot 47.
`price48`	`BIGINT`	Yes	Price override for slot 48.
`price49`	`BIGINT`	Yes	Price override for slot 49.
`price50`	`BIGINT`	Yes	Price override for slot 50.
`price51`	`BIGINT`	Yes	Price override for slot 51.
`price52`	`BIGINT`	Yes	Price override for slot 52.
`price53`	`BIGINT`	Yes	Price override for slot 53.
`price54`	`BIGINT`	Yes	Price override for slot 54.
`ownerid`	`INTEGER`	Yes	Owning configuration or location identifier.
`usernumber`	`INTEGER`	Yes	User-visible modifier-group number.
`shortname`	`VARCHAR(15)`	Yes	Short modifier-group name.
`minimum`	`INTEGER`	Yes	Minimum number of modifiers required.
`maximum`	`INTEGER`	Yes	Maximum number of modifiers allowed.
`flowreq`	`VARCHAR(1)`	Yes	Flag indicating whether modifier flow is required.
`substitute`	`INTEGER`	Yes	Substitute-rule identifier or code.
`weight01`	`INTEGER`	Yes	Weighting or sort weight for slot 01.
`weight02`	`INTEGER`	Yes	Weighting or sort weight for slot 02.
`weight03`	`INTEGER`	Yes	Weighting or sort weight for slot 03.
`weight04`	`INTEGER`	Yes	Weighting or sort weight for slot 04.
`weight05`	`INTEGER`	Yes	Weighting or sort weight for slot 05.
`weight06`	`INTEGER`	Yes	Weighting or sort weight for slot 06.
`weight07`	`INTEGER`	Yes	Weighting or sort weight for slot 07.
`weight08`	`INTEGER`	Yes	Weighting or sort weight for slot 08.
`weight09`	`INTEGER`	Yes	Weighting or sort weight for slot 09.
`weight10`	`INTEGER`	Yes	Weighting or sort weight for slot 10.
`weight11`	`INTEGER`	Yes	Weighting or sort weight for slot 11.
`weight12`	`INTEGER`	Yes	Weighting or sort weight for slot 12.
`weight13`	`INTEGER`	Yes	Weighting or sort weight for slot 13.
`weight14`	`INTEGER`	Yes	Weighting or sort weight for slot 14.
`weight15`	`INTEGER`	Yes	Weighting or sort weight for slot 15.
`weight16`	`INTEGER`	Yes	Weighting or sort weight for slot 16.
`weight17`	`INTEGER`	Yes	Weighting or sort weight for slot 17.
`weight18`	`INTEGER`	Yes	Weighting or sort weight for slot 18.
`weight19`	`INTEGER`	Yes	Weighting or sort weight for slot 19.
`weight20`	`INTEGER`	Yes	Weighting or sort weight for slot 20.
`weight21`	`INTEGER`	Yes	Weighting or sort weight for slot 21.
`weight22`	`INTEGER`	Yes	Weighting or sort weight for slot 22.
`weight23`	`INTEGER`	Yes	Weighting or sort weight for slot 23.
`weight24`	`INTEGER`	Yes	Weighting or sort weight for slot 24.
`weight25`	`INTEGER`	Yes	Weighting or sort weight for slot 25.
`weight26`	`INTEGER`	Yes	Weighting or sort weight for slot 26.
`weight27`	`INTEGER`	Yes	Weighting or sort weight for slot 27.
`weight28`	`INTEGER`	Yes	Weighting or sort weight for slot 28.
`weight29`	`INTEGER`	Yes	Weighting or sort weight for slot 29.
`weight30`	`INTEGER`	Yes	Weighting or sort weight for slot 30.
`weight31`	`INTEGER`	Yes	Weighting or sort weight for slot 31.
`weight32`	`INTEGER`	Yes	Weighting or sort weight for slot 32.
`weight33`	`INTEGER`	Yes	Weighting or sort weight for slot 33.
`weight34`	`INTEGER`	Yes	Weighting or sort weight for slot 34.
`weight35`	`INTEGER`	Yes	Weighting or sort weight for slot 35.
`weight36`	`INTEGER`	Yes	Weighting or sort weight for slot 36.
`weight37`	`INTEGER`	Yes	Weighting or sort weight for slot 37.
`weight38`	`INTEGER`	Yes	Weighting or sort weight for slot 38.
`weight39`	`INTEGER`	Yes	Weighting or sort weight for slot 39.
`weight40`	`INTEGER`	Yes	Weighting or sort weight for slot 40.
`weight41`	`INTEGER`	Yes	Weighting or sort weight for slot 41.
`weight42`	`INTEGER`	Yes	Weighting or sort weight for slot 42.
`weight43`	`INTEGER`	Yes	Weighting or sort weight for slot 43.
`weight44`	`INTEGER`	Yes	Weighting or sort weight for slot 44.
`weight45`	`INTEGER`	Yes	Weighting or sort weight for slot 45.
`weight46`	`INTEGER`	Yes	Weighting or sort weight for slot 46.
`weight47`	`INTEGER`	Yes	Weighting or sort weight for slot 47.
`weight48`	`INTEGER`	Yes	Weighting or sort weight for slot 48.
`weight49`	`INTEGER`	Yes	Weighting or sort weight for slot 49.
`weight50`	`INTEGER`	Yes	Weighting or sort weight for slot 50.
`weight51`	`INTEGER`	Yes	Weighting or sort weight for slot 51.
`weight52`	`INTEGER`	Yes	Weighting or sort weight for slot 52.
`weight53`	`INTEGER`	Yes	Weighting or sort weight for slot 53.
`weight54`	`INTEGER`	Yes	Weighting or sort weight for slot 54.
`pricelvl01`	`INTEGER`	Yes	Price-level override for slot 01.
`pricelvl02`	`INTEGER`	Yes	Price-level override for slot 02.
`pricelvl03`	`INTEGER`	Yes	Price-level override for slot 03.
`pricelvl04`	`INTEGER`	Yes	Price-level override for slot 04.
`pricelvl05`	`INTEGER`	Yes	Price-level override for slot 05.
`pricelvl06`	`INTEGER`	Yes	Price-level override for slot 06.
`pricelvl07`	`INTEGER`	Yes	Price-level override for slot 07.
`pricelvl08`	`INTEGER`	Yes	Price-level override for slot 08.
`pricelvl09`	`INTEGER`	Yes	Price-level override for slot 09.
`pricelvl10`	`INTEGER`	Yes	Price-level override for slot 10.
`pricelvl11`	`INTEGER`	Yes	Price-level override for slot 11.
`pricelvl12`	`INTEGER`	Yes	Price-level override for slot 12.
`pricelvl13`	`INTEGER`	Yes	Price-level override for slot 13.
`pricelvl14`	`INTEGER`	Yes	Price-level override for slot 14.
`pricelvl15`	`INTEGER`	Yes	Price-level override for slot 15.
`pricelvl16`	`INTEGER`	Yes	Price-level override for slot 16.
`pricelvl17`	`INTEGER`	Yes	Price-level override for slot 17.
`pricelvl18`	`INTEGER`	Yes	Price-level override for slot 18.
`pricelvl19`	`INTEGER`	Yes	Price-level override for slot 19.
`pricelvl20`	`INTEGER`	Yes	Price-level override for slot 20.
`pricelvl21`	`INTEGER`	Yes	Price-level override for slot 21.
`pricelvl22`	`INTEGER`	Yes	Price-level override for slot 22.
`pricelvl23`	`INTEGER`	Yes	Price-level override for slot 23.
`pricelvl24`	`INTEGER`	Yes	Price-level override for slot 24.
`pricelvl25`	`INTEGER`	Yes	Price-level override for slot 25.
`pricelvl26`	`INTEGER`	Yes	Price-level override for slot 26.
`pricelvl27`	`INTEGER`	Yes	Price-level override for slot 27.
`pricelvl28`	`INTEGER`	Yes	Price-level override for slot 28.
`pricelvl29`	`INTEGER`	Yes	Price-level override for slot 29.
`pricelvl30`	`INTEGER`	Yes	Price-level override for slot 30.
`pricelvl31`	`INTEGER`	Yes	Price-level override for slot 31.
`pricelvl32`	`INTEGER`	Yes	Price-level override for slot 32.
`pricelvl33`	`INTEGER`	Yes	Price-level override for slot 33.
`pricelvl34`	`INTEGER`	Yes	Price-level override for slot 34.
`pricelvl35`	`INTEGER`	Yes	Price-level override for slot 35.
`pricelvl36`	`INTEGER`	Yes	Price-level override for slot 36.
`pricelvl37`	`INTEGER`	Yes	Price-level override for slot 37.
`pricelvl38`	`INTEGER`	Yes	Price-level override for slot 38.
`pricelvl39`	`INTEGER`	Yes	Price-level override for slot 39.
`pricelvl40`	`INTEGER`	Yes	Price-level override for slot 40.
`pricelvl41`	`INTEGER`	Yes	Price-level override for slot 41.
`pricelvl42`	`INTEGER`	Yes	Price-level override for slot 42.
`pricelvl43`	`INTEGER`	Yes	Price-level override for slot 43.
`pricelvl44`	`INTEGER`	Yes	Price-level override for slot 44.
`pricelvl45`	`INTEGER`	Yes	Price-level override for slot 45.
`pricelvl46`	`INTEGER`	Yes	Price-level override for slot 46.
`pricelvl47`	`INTEGER`	Yes	Price-level override for slot 47.
`pricelvl48`	`INTEGER`	Yes	Price-level override for slot 48.
`pricelvl49`	`INTEGER`	Yes	Price-level override for slot 49.
`pricelvl50`	`INTEGER`	Yes	Price-level override for slot 50.
`pricelvl51`	`INTEGER`	Yes	Price-level override for slot 51.
`pricelvl52`	`INTEGER`	Yes	Price-level override for slot 52.
`pricelvl53`	`INTEGER`	Yes	Price-level override for slot 53.
`pricelvl54`	`INTEGER`	Yes	Price-level override for slot 54.
`prmethod01`	`INTEGER`	Yes	Price method for slot 01.
`prmethod02`	`INTEGER`	Yes	Price method for slot 02.
`prmethod03`	`INTEGER`	Yes	Price method for slot 03.
`prmethod04`	`INTEGER`	Yes	Price method for slot 04.
`prmethod05`	`INTEGER`	Yes	Price method for slot 05.
`prmethod06`	`INTEGER`	Yes	Price method for slot 06.
`prmethod07`	`INTEGER`	Yes	Price method for slot 07.
`prmethod08`	`INTEGER`	Yes	Price method for slot 08.
`prmethod09`	`INTEGER`	Yes	Price method for slot 09.
`prmethod10`	`INTEGER`	Yes	Price method for slot 10.
`prmethod11`	`INTEGER`	Yes	Price method for slot 11.
`prmethod12`	`INTEGER`	Yes	Price method for slot 12.
`prmethod13`	`INTEGER`	Yes	Price method for slot 13.
`prmethod14`	`INTEGER`	Yes	Price method for slot 14.
`prmethod15`	`INTEGER`	Yes	Price method for slot 15.
`prmethod16`	`INTEGER`	Yes	Price method for slot 16.
`prmethod17`	`INTEGER`	Yes	Price method for slot 17.
`prmethod18`	`INTEGER`	Yes	Price method for slot 18.
`prmethod19`	`INTEGER`	Yes	Price method for slot 19.
`prmethod20`	`INTEGER`	Yes	Price method for slot 20.
`prmethod21`	`INTEGER`	Yes	Price method for slot 21.
`prmethod22`	`INTEGER`	Yes	Price method for slot 22.
`prmethod23`	`INTEGER`	Yes	Price method for slot 23.
`prmethod24`	`INTEGER`	Yes	Price method for slot 24.
`prmethod25`	`INTEGER`	Yes	Price method for slot 25.
`prmethod26`	`INTEGER`	Yes	Price method for slot 26.
`prmethod27`	`INTEGER`	Yes	Price method for slot 27.
`prmethod28`	`INTEGER`	Yes	Price method for slot 28.
`prmethod29`	`INTEGER`	Yes	Price method for slot 29.
`prmethod30`	`INTEGER`	Yes	Price method for slot 30.
`prmethod31`	`INTEGER`	Yes	Price method for slot 31.
`prmethod32`	`INTEGER`	Yes	Price method for slot 32.
`prmethod33`	`INTEGER`	Yes	Price method for slot 33.
`prmethod34`	`INTEGER`	Yes	Price method for slot 34.
`prmethod35`	`INTEGER`	Yes	Price method for slot 35.
`prmethod36`	`INTEGER`	Yes	Price method for slot 36.
`prmethod37`	`INTEGER`	Yes	Price method for slot 37.
`prmethod38`	`INTEGER`	Yes	Price method for slot 38.
`prmethod39`	`INTEGER`	Yes	Price method for slot 39.
`prmethod40`	`INTEGER`	Yes	Price method for slot 40.
`prmethod41`	`INTEGER`	Yes	Price method for slot 41.
`prmethod42`	`INTEGER`	Yes	Price method for slot 42.
`prmethod43`	`INTEGER`	Yes	Price method for slot 43.
`prmethod44`	`INTEGER`	Yes	Price method for slot 44.
`prmethod45`	`INTEGER`	Yes	Price method for slot 45.
`prmethod46`	`INTEGER`	Yes	Price method for slot 46.
`prmethod47`	`INTEGER`	Yes	Price method for slot 47.
`prmethod48`	`INTEGER`	Yes	Price method for slot 48.
`prmethod49`	`INTEGER`	Yes	Price method for slot 49.
`prmethod50`	`INTEGER`	Yes	Price method for slot 50.
`prmethod51`	`INTEGER`	Yes	Price method for slot 51.
`prmethod52`	`INTEGER`	Yes	Price method for slot 52.
`prmethod53`	`INTEGER`	Yes	Price method for slot 53.
`prmethod54`	`INTEGER`	Yes	Price method for slot 54.
`subindex`	`INTEGER`	Yes	Substitute or subgroup index.
`qstsmode`	`INTEGER`	Yes	Question-set mode or flow mode.
`refill`	`VARCHAR(1)`	Yes	Flag indicating refill behavior within the modifier group.
`maxrefills`	`INTEGER`	Yes	Maximum number of refills allowed.
`defrdmod`	`VARCHAR(1)`	Yes	Flag controlling default required modifier behavior.
`nosub01`	`INTEGER`	Yes	No-substitute rule for slot 01.
`nosub02`	`INTEGER`	Yes	No-substitute rule for slot 02.
`nosub03`	`INTEGER`	Yes	No-substitute rule for slot 03.
`nosub04`	`INTEGER`	Yes	No-substitute rule for slot 04.
`nosub05`	`INTEGER`	Yes	No-substitute rule for slot 05.
`nosub06`	`INTEGER`	Yes	No-substitute rule for slot 06.
`nosub07`	`INTEGER`	Yes	No-substitute rule for slot 07.
`nosub08`	`INTEGER`	Yes	No-substitute rule for slot 08.
`nosub09`	`INTEGER`	Yes	No-substitute rule for slot 09.
`nosub10`	`INTEGER`	Yes	No-substitute rule for slot 10.
`nosub11`	`INTEGER`	Yes	No-substitute rule for slot 11.
`nosub12`	`INTEGER`	Yes	No-substitute rule for slot 12.
`nosub13`	`INTEGER`	Yes	No-substitute rule for slot 13.
`nosub14`	`INTEGER`	Yes	No-substitute rule for slot 14.
`nosub15`	`INTEGER`	Yes	No-substitute rule for slot 15.
`nosub16`	`INTEGER`	Yes	No-substitute rule for slot 16.
`nosub17`	`INTEGER`	Yes	No-substitute rule for slot 17.
`nosub18`	`INTEGER`	Yes	No-substitute rule for slot 18.
`nosub19`	`INTEGER`	Yes	No-substitute rule for slot 19.
`nosub20`	`INTEGER`	Yes	No-substitute rule for slot 20.
`nosub21`	`INTEGER`	Yes	No-substitute rule for slot 21.
`nosub22`	`INTEGER`	Yes	No-substitute rule for slot 22.
`nosub23`	`INTEGER`	Yes	No-substitute rule for slot 23.
`nosub24`	`INTEGER`	Yes	No-substitute rule for slot 24.
`nosub25`	`INTEGER`	Yes	No-substitute rule for slot 25.
`nosub26`	`INTEGER`	Yes	No-substitute rule for slot 26.
`nosub27`	`INTEGER`	Yes	No-substitute rule for slot 27.
`nosub28`	`INTEGER`	Yes	No-substitute rule for slot 28.
`nosub29`	`INTEGER`	Yes	No-substitute rule for slot 29.
`nosub30`	`INTEGER`	Yes	No-substitute rule for slot 30.
`nosub31`	`INTEGER`	Yes	No-substitute rule for slot 31.
`nosub32`	`INTEGER`	Yes	No-substitute rule for slot 32.
`nosub33`	`INTEGER`	Yes	No-substitute rule for slot 33.
`nosub34`	`INTEGER`	Yes	No-substitute rule for slot 34.
`nosub35`	`INTEGER`	Yes	No-substitute rule for slot 35.
`nosub36`	`INTEGER`	Yes	No-substitute rule for slot 36.
`nosub37`	`INTEGER`	Yes	No-substitute rule for slot 37.
`nosub38`	`INTEGER`	Yes	No-substitute rule for slot 38.
`nosub39`	`INTEGER`	Yes	No-substitute rule for slot 39.
`nosub40`	`INTEGER`	Yes	No-substitute rule for slot 40.
`nosub41`	`INTEGER`	Yes	No-substitute rule for slot 41.
`nosub42`	`INTEGER`	Yes	No-substitute rule for slot 42.
`nosub43`	`INTEGER`	Yes	No-substitute rule for slot 43.
`nosub44`	`INTEGER`	Yes	No-substitute rule for slot 44.
`nosub45`	`INTEGER`	Yes	No-substitute rule for slot 45.
`nosub46`	`INTEGER`	Yes	No-substitute rule for slot 46.
`nosub47`	`INTEGER`	Yes	No-substitute rule for slot 47.
`nosub48`	`INTEGER`	Yes	No-substitute rule for slot 48.
`nosub49`	`INTEGER`	Yes	No-substitute rule for slot 49.
`nosub50`	`INTEGER`	Yes	No-substitute rule for slot 50.
`nosub51`	`INTEGER`	Yes	No-substitute rule for slot 51.
`nosub52`	`INTEGER`	Yes	No-substitute rule for slot 52.
`nosub53`	`INTEGER`	Yes	No-substitute rule for slot 53.
`nosub54`	`INTEGER`	Yes	No-substitute rule for slot 54.
`type`	`INTEGER`	Yes	Modifier-group type code.
`hideprice`	`VARCHAR(1)`	Yes	Flag hiding prices in some modifier views.
`modifier_group_name`	`VARCHAR(255)`	Yes	Readable business name of the modifier group.
`modifier_option_name_summary`	`VARCHAR(65535)`	Yes	Readable summary of the modifier options contained in the wide-slot row.
`min_select`	`INTEGER`	Yes	Canonical minimum number of options that can be selected from the group.
`max_select`	`INTEGER`	Yes	Canonical maximum number of options that can be selected from the group.
`is_active`	`BOOLEAN`	Yes	Canonical flag indicating whether the modifier group is active in the curated model.

Technical and ETL properties

Column	Type	Nullable	Technical Meaning	Notes
`modifier_group_key`	`BIGINT`	Yes	Stable warehouse key for the modifier group entity.
`source_system`	`VARCHAR(100)`	Yes	Canonical name of the source platform that produced the modifier group row.
`source_modifier_group_id`	`VARCHAR(199)`	Yes	Original modifier group identifier from the source platform.
`tenant_key`	`BIGINT`	Yes	Stable warehouse key for the tenant, brand, or client that owns the modifier group.
`tenant_name`	`VARCHAR(255)`	Yes	Readable tenant, brand, or client name associated with the modifier group.
`effective_from_utc`	`TIMESTAMP`	Yes	UTC timestamp from which the current modifier-group version is valid.
`effective_to_utc`	`TIMESTAMP`	Yes	UTC timestamp until which the current modifier-group version is valid.
`is_current`	`BOOLEAN`	Yes	Canonical flag indicating whether the row is the current modifier-group version.
`_etl_batch_id`	`VARCHAR(256)`	Yes	ETL batch lineage identifier.
`_etl_source_type`	`VARCHAR(100)`	Yes	Source adapter type used by ETL.
`_etl_ingested_at`	`TIMESTAMP`	No	Warehouse ingestion timestamp for the curated row.	Required ingestion audit timestamp.