projects/games/wheel/  (single app)
dashboard/             (separate app)

games/
├── package.json      (npm workspaces)
└── wheel/
    ├── wheel-core/           (domain layer)
    ├── wheel-infrastructure/ (infrastructure layer)
    ├── wheel-dashboard/      (admin UI)
    └── wheel-instances/      (public UI)

api/
├── Cargo.toml        (Rust workspace)
└── wheel/            (Rust API)

CREATE TABLE configs (
  id_config VARCHAR(64) PRIMARY KEY  -- Hash was PK
);

CREATE TABLE configs (
  id_config UUID PRIMARY KEY,
  hash VARCHAR(64) NOT NULL,
  UNIQUE (tenant_id, hash)  -- Deduplicate by hash
);

Games
└── Wheel
    ├── Profiles
    ├── Instances
    └── Configs

Games API
├── Getting Started
├── Profiles (5 endpoints)
├── Instances (5 endpoints)
├── Prizes (5 endpoints)
├── Configs (4 endpoints)
└── Links (6 endpoints)

instance.configHash  // VARCHAR(64)

instance.configId    // UUID

configRepo.findByHash(hash);  // Only method
configRepo.delete(hash);      // Delete by hash

configRepo.findById(id);       // Primary lookup
configRepo.findByHash(hash);   // For deduplication
configRepo.createOrGet(config); // Auto-deduplicates
configRepo.delete(id);          // Delete by ID

-- Step 1: Backup
CREATE TABLE configs_backup AS SELECT * FROM configs;

-- Step 2: Add new columns
ALTER TABLE configs ADD COLUMN id_config_new UUID DEFAULT gen_random_uuid();
ALTER TABLE configs ADD COLUMN hash_new VARCHAR(64);

-- Step 3: Migrate data
UPDATE configs SET hash_new = id_config;  -- Old PK becomes hash
UPDATE configs SET id_config_new = gen_random_uuid();

-- Step 4: Update foreign keys
ALTER TABLE instances ADD COLUMN config_id_new UUID;
UPDATE instances i 
SET config_id_new = (
  SELECT id_config_new FROM configs c WHERE c.hash_new = i.config
);

-- Step 5: Drop old columns and rename
ALTER TABLE configs DROP COLUMN id_config;
ALTER TABLE configs RENAME COLUMN id_config_new TO id_config;
ALTER TABLE configs RENAME COLUMN hash_new TO hash;

ALTER TABLE instances DROP COLUMN config;
ALTER TABLE instances RENAME COLUMN config_id_new TO config_id;

-- Step 6: Add constraints
ALTER TABLE configs ADD PRIMARY KEY (id_config);
ALTER TABLE configs ADD CONSTRAINT unique_tenant_hash UNIQUE (tenant_id, hash);
ALTER TABLE instances ADD FOREIGN KEY (config_id) REFERENCES configs(id_config);

// First call
const config1 = await configRepo.createOrGet(configData);
// Returns: { id: "uuid-1", hash: "abc123..." }

// Second call with same data
const config2 = await configRepo.createOrGet(configData);
// Returns: { id: "uuid-1", hash: "abc123..." }  // Same ID!

app.{domain}     → wheel-dashboard
{domain}         → wheel-instances
api.{domain}     → api/wheel