Schema_docs

adminadmin — module #20 (reopened 2026-07-09 — approvals extraction) agents OLDagents — module #28, Phase 5 of 6 of the agents-v2/v3 build aiai — Phase 13 (module #6, cross-cutting) approvalsapprovals — module #21, the cross-cutting tenant-side approval-workflow engine billingbilling — module #18, the SETTLE half of the financial layer consumerconsumer — new module (2026-07-11), platform-level consumer identity crmcrm — Phase 5 (module #5, first product module) filesfiles — module #26, the generic file-metadata registry identity OLD36 tables, 410 columns — AGENT_SKILL DROP (2026-07-17, Identity's 6th reopen, Phase 6 of 6 of the agents-v2/v3 inventoryinventory — Phase 12 (module #12) multi locmulti_loc — Phase 4 (module #4) notificationsnotifications — module #29 (2026-07-19), the first STALE-BUT-UNBUILT module revival nursery refnursery_ref — Phase 2 (Nursery Vertical Extraction, new schema) nurserynursery — Phase 2 (Nursery Vertical Extraction, new schema) offersoffers — new module (2026-07-11), merchant-issued discount/promo offers — THE AI module of this build ordersorders — module #15, completing the sell path paymentspayments — module #19, the money-MOVEMENT layer platform2026-06-28 (identity Batch A actor model): 4 of the 8 identity-deferred FK columns below are retargeted to ide pospos — module #14, first BUILT module of the sell path after pricing pricingpricing — Phase 14 (module #13, first module of the sell path) purchasingpurchasing — module #16, the BUY path (completes the supply loop) READMEPer-module schema definitions — one file per module (<module>.md), created at step 2 of the module runbook. Ho receivingreceiving — module #22, the physical goods-receipt layer (extracted from purchasing) returnsreturns — module #27, the customer RMA (return merchandise authorization) layer rewardsrewards — new module (2026-07-11), per-merchant points/loyalty program semanticssemantics — new schema (agents-v2/v3 build, Phase 3 of 6) sharedshared — Phase 3 (module #3) signalssignals — new schema (agents-v2/v3 build, Phase 4 of 6, HIGHEST RISK) taxtax — module #17, the first module with zero v1 precedent