Schema_modules

schema adminSchema locked 2026-06-10. 11 tables, 145 cols: tenant_business_profile (17), tenant_branding (12), compliance_ schema aiSchema locked 2026-06-11. 4 tables, 71 cols: import_job (17), import_file (15), import_record (21), ai_request schema auditSchema locked 2026-06-10. 7 tables, 118 cols: audit_log (22), data_subject_request (17), data_breach_incident schema billingSchema locked 2026-06-10. 8 tables, 113 cols: ar_account (12), ar_charge (19), ar_payment (17), ar_payment_app schema consumerconsumer — Consumer Layer (post-v1.0) schema crm8 tables, 108 cols. (+1 search_vector on crm.customer added 2026-06-11 — Search FTS touch.) Owns the tenant's schema customer appTables pending design — see docs/modules/08_customer_app.md for feature-level context. Owns consumer-owned cro schema filesSchema locked 2026-06-11. 3 tables, 43 cols: file (19), file_access_grant (16), file_storage_usage (8). schema identityLocked at 11 tables. Source of truth for users, roles, permissions, site assignments, SSO providers, invitatio schema integrationsSchema locked 2026-06-11. 9 tables, 127 cols: connector (13), connector_credential (13), sync_run (18), sync_r schema inventoryLocked at 21 tables, 238 cols (232 at lock 2026-06-09; +2 cols added 2026-06-10 for POS guarantee support — ha schema multi locLocked at 1 table for v1.0 (site, 21 columns). Owns the site concept — a physical nursery property — and defin schema notificationsSchema locked 2026-06-10. 11 tables, 166 cols: notification_template (13), notification (26), delivery_attempt schema offersSchema locked 2026-06-12. 4 tables, 68 cols: offer (27), offer_code (13), offer_assignment (15), offer_redempt schema ordersSchema locked 2026-06-10. 7 tables, 133 cols: order_header (37), order_line (26), order_payment (20), order_fu schema paymentsSchema locked 2026-06-10. 8 tables, 112 cols: stripe_connect_account (14), payment_intent (25), payment_refund schema platformLocked at 16 tables per PROJECT_DECISIONS "Platform Module (Locked 2026-06-09)". Table names and one-line desc schema posSchema locked 2026-06-10. 19 tables, 280 cols (+1 col added 2026-06-10: tip_amount_cents on pos.sale; +1 col a schema pricing4 tables, 56 cols (revised: price_list_assignment +2 cols for assignment_scope + customer_group_id). Owns pre- schema productionTables pending design — see docs/modules/07_production.md for feature-level context (propagation, crop lots, m schema purchasingSchema locked 2026-06-10 — 16 tables, 341 columns. Doc-only touch 2026-06-11: purchase_receipt.shipment_photo_ schema reportingSchema locked 2026-06-11. 3 tables, 43 cols: report_snapshot_run (16), inventory_valuation_snapshot (12), peri schema rewardsSchema locked 2026-06-12. 6 tables, 89 cols: loyalty_program (12), earning_rule (17), tier_level (12), reward_ schema searchSchema locked 2026-06-11. Zero tables — delivered as 6 FTS touches to locked modules. See PROJECT_DECISIONS "S schema sharedLocked at 7 tables. Global reference data — vocabularies and small dictionaries shared by every tenant. Seeded