Central database #
Collections: corporations, mappings, files, users, superUsers, mcpTokens, cloneAuditLog, etc.
Per-corporation databases #
Mongoose models in core/dataModels.js. Named by SiteLink corp code.
| Model | Collection | Role |
|---|---|---|
| site | sites | Facility/location |
| unit, unitTypeGroup | units, unitTypeGroups | Inventory |
| reservation | reservations | Bookings |
| descriptor, persona | descriptors, personas | Unit presentation & personas |
| deal, discountPlan | deals, discountPlans | Pricing promotions |
| scaTransaction, r6PayTransactions | — | Payment records |
| revManActiveExplorations, revManRateOverrides | — | Rev-mgmt overlay |
Migration scripts #
Numbered scripts in database/scripts/ (0001–0046). Notable recent:
0046.BackfillBoxshopSalesTotals.2026.07.10.js— backfillstotalPriceon boxshop sales records; batched writes0045.ReconcileRevManIndexes.2026.07.01.js— rev-mgmt index reconciliation across all corp DBs0044.CreateDealsFromDiscountPlans.2026.03.12.js
Run: node ./database/scripts/<script>.js (some support --live dry-run).