/** * Pipeline Configuration — Space 36 (HOLETRON) * * Equivalent mapping of all table IDs, state row IDs, priority/type row IDs, * and agent user IDs needed to run ChainHandoffService in Space 36. * * Generated from production database queries on 2026-03-03. * * Source of truth: * - Ticket States dictionary: table 2968 (8 rows) * - Priority dictionary: table 2967 (4 rows) * - Type dictionary: table 2966 (8 rows) * - Users CRM table: table 970 (5 rows with system_user_id) * - AI Agents table: table 1584 (33 rows) * - System `users` table: SQL users WHERE user_type='agent' */ // ============================================================================= // SPACE 11 (Development) — Current hardcoded values in ChainHandoffService.js // ============================================================================= // Provided here for reference so diffs are easy to spot. export const SPACE_11_CONFIG = { TICKETS_TABLE_ID: 1708, AGENT_ACTIVITY_TABLE_ID: 1701, AI_AGENTS_TABLE_ID: 1784, STATE: { BACKLOG: 24275, // "backlog" ASSIGNED: 43436, // "assigned" IN_PROGRESS: 24276, // "in progress" REVIEW: 24277, // "review" CONTROL: 43437, // "control" DONE: 24278, // "done" REJECTED: 43438, // "rejected" // Note: Space 11 has no ON_HOLD state }, PRIORITY: { CRITICAL: 24274, // "critical" }, TYPE: { TASK: 24269, // "task" }, // Users CRM table (1782) row_id → system user_id USERS_TABLE_ROW_TO_USER_ID: { 26283: 19, // Developer Ralph 26284: 22, // Frontend QA 26285: 21, // Frontend Developer 26286: 28, // Document Agent 26287: 20, // Developer 26288: 24, // Architect 36612: 18, // Orchestrator }, }; // ============================================================================= // SPACE 36 (HOLETRON) — Full pipeline configuration // ============================================================================= export const SPACE_36_CONFIG = { // ---- Core Table IDs ---- TICKETS_TABLE_ID: 3207, AGENT_ACTIVITY_TABLE_ID: 3070, AI_AGENTS_TABLE_ID: 1584, QUALITY_REPORTS_TABLE_ID: 3071, ADR_PROJECTS_TABLE_ID: 3069, // ---- Dictionary Tables ---- TICKET_STATES_TABLE_ID: 2968, PRIORITY_TABLE_ID: 2967, TYPE_TABLE_ID: 2966, USERS_TABLE_ID: 970, // ---- Ticket States (row IDs from table 2968) ---- // Sorted by order field; slug in column 21756, order in 21757 STATE: { BACKLOG: 57081, // order 1 — "backlog" — #6b7280 — "В очереди" ASSIGNED: 57082, // order 2 — "assigned" — #6366f1 — "Назначено исполнителю" IN_PROGRESS: 57083, // order 3 — "in progress" — #3b82f6 — "В работе" REVIEW: 57084, // order 4 — "review" — #a855f7 — "На проверке" CONTROL: 57085, // order 5 — "control" — #f59e0b — "Контроль качества" DONE: 57086, // order 6 — "done" — #22c55e — "Завершено" (is_final: true) ON_HOLD: 57087, // order 7 — "on hold" — #f59e0b — "Приостановлено" REJECTED: 57088, // order 8 — "rejected" — #ef4444 — "Отклонено" (is_final: true) }, // ---- Priority (row IDs from table 2967) ---- // Slug in column 21752, order/level in 21753 PRIORITY: { LOW: 57077, // order 1 — "low" — #6b7280 MEDIUM: 57078, // order 2 — "medium" — #f59e0b HIGH: 57079, // order 3 — "high" — #f97316 CRITICAL: 57080, // order 4 — "critical" — #ef4444 }, // ---- Ticket Type (row IDs from table 2966) ---- // Slug in column 21748, icon in 21749 TYPE: { BUG: 57069, // "bug" — icon: bug — #ef4444 TASK: 57070, // "task" — icon: check — #22c55e STORY: 57071, // "story" — icon: book — #3b82f6 SPIKE: 57072, // "spike" — icon: microscope — #a855f7 PRODUCTION: 57073, // "production" — icon: factory — #f59e0b LOGISTICS: 57074, // "logistics" — icon: truck — #6366f1 MARKETING: 57075, // "marketing" — icon: megaphone — #ec4899 WEBSITE: 57076, // "website" — icon: globe — #14b8a6 }, // ---- Agent User IDs (system `users` table, shared across spaces) ---- // These are the same integer user IDs used by AgentWorkerService. // The `users.managed_by_agent_table_id` for Space-36-native agents is 1584. AGENT_USERS: { ORCHESTRATOR: 18, // orchestrator@hltrn.cc — managed_by row 31112 (table 1784) DEV_RALPH: 19, // developer-ralph@hltrn.cc — managed_by row 31113 (table 1784) DEVELOPER: 20, // developer@hltrn.cc — managed_by row 33483 (table 1784) FRONTEND: 21, // frontend@hltrn.cc — managed_by row 31114 (table 1784) FRONTEND_QA: 22, // frontend-qa@hltrn.cc — managed_by row 33485 (table 1784) TEST_RUNNER: 23, // test-runner@hltrn.cc — managed_by row 31115 (table 1784) ARCHITECT: 24, // architect@hltrn.cc — managed_by row 33491 (table 1784) TABLE_ARCHITECT: 25, // table-architect@hltrn.cc — managed_by row 33487 (table 1784) WIDGET_DEVELOPER: 26, // widget-developer@hltrn.cc — managed_by row 33488 (table 1784) DOCUMENT_AGENT: 28, // document-agent@hltrn.cc — managed_by row 33489 (table 1784) MARKETER: 51, // marketer@hltrn.cc — managed_by row 44465 (table 1784) NIKICH: 53, // nikich@hltrn.cc — managed_by row 54430 (table 1784) FITNESS_COACH: 54, // fitness-coach@agents.godcrm.local — managed_by row 75107 (table 1784) PES: 2392, // pes@hltrn.cc — managed_by row 70373 (table 1584) ← Space 36 native }, // ---- Users CRM Table (970) row_id → system user_id ---- // The Tickets table (3207) column "assigned_to" (col 25140) is a select // referencing table 970 with valueColumn = "system_user_id". // When the UI stores a row_id from table 970, this map resolves it to // the integer user_id that AgentWorkerService expects. USERS_TABLE_ROW_TO_USER_ID: { 10811: 1, // GERATRON (Dev User, owner) — system_user_id from users.id 10815: 7, // NIKITRON (nikitron2392@gmail.com, owner) 57126: 18, // Orchestrator (orchestrator@hltrn.cc, admin) 74566: 24, // Architect (architect@hltrn.cc, admin) 74567: 25, // Table Architect (table-architect@hltrn.cc, viewer) }, // ---- AI Agents Table (1584) — Agent Row IDs ---- // These are the row_ids in the AI Agents table for Space 36. // Original/Holetron business agents (rows 57101–57109): AGENT_ROWS: { // --- Holetron business agents --- HOLETRON: 57101, // Main orchestrator for Holetron business PRODUCTION_MANAGER: 57102, LOGISTICS_COORDINATOR: 57103, MARKETING_MANAGER: 57104, SALES_MANAGER: 57105, WEBSITE_DEVELOPER: 57106, HR_MANAGER: 57107, QUALITY_INSPECTOR: 57108, FINANCE_ANALYST: 57109, // --- Pipeline / dev agents (rows 69310–69328) --- WORKSPACE_MANAGER: 69310, ARCHITECT: 69311, GEMINI_ASSISTANT: 69312, ADR_WRITER: 69313, FRONTEND: 69314, ORCHESTRATOR: 69315, GPT_ASSISTANT: 69316, TABLE_ARCHITECT: 69317, MARKETING_STRATEGIST: 69318, DOCUMENT_AGENT: 69319, DEVELOPER_RALPH: 69320, WIDGET_DEVELOPER: 69321, FRONTEND_QA: 69322, FRONTEND_DEBUGGER: 69323, SYSADMIN: 69324, DEVELOPER: 69325, TEST_RUNNER: 69326, AGENT_TEMPLATE: 69327, NIKICH: 69328, // --- Additional --- PES: 70373, }, // ---- Default values for dispatchSubtask ---- DEFAULTS: { PRIORITY: 57079, // "high" (Space 11 uses 24274 = "critical") TYPE: 57070, // "task" (Space 11 uses 24269 = "task") }, // ---- Ticket Column IDs (table_columns for table 3207) ---- // The JSONB `data` in table_rows uses column_name as keys (not column IDs), // but these are useful for API calls and column-level operations. TICKET_COLUMNS: { type: 25137, adr_ref: 25138, priority: 23683, state: 25139, assigned_to: 25140, what: 23680, why: 23682, acceptance_criteria: 25141, test_steps: 25142, created_date: 25143, completed_date: 25144, phase: 25145, scheduled_date: 25146, due_date: 23685, progress: 25147, depends_on: 25148, chain_id: 25149, cycle: 25150, calendar_event: 25151, }, // ---- Agent Activity Column IDs (table_columns for table 3070) ---- ACTIVITY_COLUMNS: { agent_id: 22590, task_id: 22591, action: 22592, timestamp: 22593, details: 22594, success: 22595, duration_ms: 22596, tokens_used: 22597, cost_usd: 22598, error_message: 22599, }, // ---- Quality Reports Column IDs (table_columns for table 3071) ---- QUALITY_COLUMNS: { task_id: 22600, report_type: 22601, status: 22602, tests_total: 22603, tests_passed: 22604, tests_failed: 22605, tests_skipped: 22606, coverage_percent: 22607, any_count: 22608, lighthouse_score: 22609, bundle_size_kb: 22610, security_issues: 22611, a11y_violations: 22612, details: 22613, created_at: 22614, }, // ---- ADR Projects Column IDs (table_columns for table 3069) ---- ADR_COLUMNS: { adr_number: 22581, title: 22582, status: 22583, priority: 22584, assigned_orchestrator: 22585, start_date: 22586, end_date: 22587, completion_percentage: 22588, notes: 22589, }, }; // ============================================================================= // Convenience: Side-by-side comparison table // ============================================================================= // // | Concept | Space 11 (Dev) | Space 36 (HOLETRON) | // |----------------------|-----------------|---------------------| // | Tickets table | 1708 | 3207 | // | Agent Activity table | 1701 | 3070 | // | AI Agents table | 1784 | 1584 | // | Quality Reports | N/A | 3071 | // | ADR Projects | N/A | 3069 | // | Users CRM table | 1782 | 970 | // | States dictionary | N/A | 2968 | // | Priority dictionary | N/A | 2967 | // | Type dictionary | N/A | 2966 | // | | | | // | STATE.BACKLOG | 24275 | 57081 | // | STATE.ASSIGNED | 43436 | 57082 | // | STATE.IN_PROGRESS | 24276 | 57083 | // | STATE.REVIEW | 24277 | 57084 | // | STATE.CONTROL | 43437 | 57085 | // | STATE.DONE | 24278 | 57086 | // | STATE.ON_HOLD | N/A | 57087 | // | STATE.REJECTED | 43438 | 57088 | // | | | | // | PRIORITY.LOW | N/A | 57077 | // | PRIORITY.MEDIUM | N/A | 57078 | // | PRIORITY.HIGH | N/A | 57079 | // | PRIORITY.CRITICAL | 24274 | 57080 | // | | | | // | TYPE.TASK (default) | 24269 | 57070 | // | TYPE.BUG | N/A | 57069 | // | TYPE.STORY | N/A | 57071 | // | TYPE.SPIKE | N/A | 57072 | // | TYPE.PRODUCTION | N/A | 57073 | // | TYPE.LOGISTICS | N/A | 57074 | // | TYPE.MARKETING | N/A | 57075 | // | TYPE.WEBSITE | N/A | 57076 | // ============================================================================= export default SPACE_36_CONFIG;