Files
Apple ef3473db21 snapshot: NODE1 production state 2026-02-09
Complete snapshot of /opt/microdao-daarion/ from NODE1 (144.76.224.179).
This represents the actual running production code that has diverged
significantly from the previous main branch.

Key changes from old main:
- Gateway (http_api.py): expanded from ~40KB to 164KB with full agent support
- Router: new /v1/agents/{id}/infer endpoint with vision + DeepSeek routing
- Behavior Policy: SOWA v2.2 (3-level: FULL/ACK/SILENT)
- Agent Registry: config/agent_registry.yml as single source of truth
- 13 agents configured (was 3)
- Memory service integration
- CrewAI teams and roles

Excluded from snapshot: venv/, .env, data/, backups, .tgz archives

Co-authored-by: Cursor <cursoragent@cursor.com>
2026-02-09 08:46:46 -08:00

830 lines
38 KiB
HTML
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
<!doctype html>
<html lang="en" class="no-js">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
<link rel="canonical" href="https://IvanTytar.github.io/microdao-daarion/foundation/microdao_Data_Model_UPDATE_v1/">
<link rel="icon" href="../../assets/images/favicon.png">
<meta name="generator" content="mkdocs-1.5.3, mkdocs-material-9.5.18">
<title>microdao_Data_Model_UPDATE_v1.md - DAARION Documentation</title>
<link rel="stylesheet" href="../../assets/stylesheets/main.66ac8b77.min.css">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto:300,300i,400,400i,700,700i%7CRoboto+Mono:400,400i,700,700i&display=fallback">
<style>:root{--md-text-font:"Roboto";--md-code-font:"Roboto Mono"}</style>
<script>__md_scope=new URL("../..",location),__md_hash=e=>[...e].reduce((e,_)=>(e<<5)-e+_.charCodeAt(0),0),__md_get=(e,_=localStorage,t=__md_scope)=>JSON.parse(_.getItem(t.pathname+"."+e)),__md_set=(e,_,t=localStorage,a=__md_scope)=>{try{t.setItem(a.pathname+"."+e,JSON.stringify(_))}catch(e){}}</script>
</head>
<body dir="ltr">
<input class="md-toggle" data-md-toggle="drawer" type="checkbox" id="__drawer" autocomplete="off">
<input class="md-toggle" data-md-toggle="search" type="checkbox" id="__search" autocomplete="off">
<label class="md-overlay" for="__drawer"></label>
<div data-md-component="skip">
<a href="#microdao_data_model_update_v1md" class="md-skip">
Skip to content
</a>
</div>
<div data-md-component="announce">
</div>
<header class="md-header md-header--shadow" data-md-component="header">
<nav class="md-header__inner md-grid" aria-label="Header">
<a href="../.." title="DAARION Documentation" class="md-header__button md-logo" aria-label="DAARION Documentation" data-md-component="logo">
<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24"><path d="M12 8a3 3 0 0 0 3-3 3 3 0 0 0-3-3 3 3 0 0 0-3 3 3 3 0 0 0 3 3m0 3.54C9.64 9.35 6.5 8 3 8v11c3.5 0 6.64 1.35 9 3.54 2.36-2.19 5.5-3.54 9-3.54V8c-3.5 0-6.64 1.35-9 3.54Z"/></svg>
</a>
<label class="md-header__button md-icon" for="__drawer">
<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24"><path d="M3 6h18v2H3V6m0 5h18v2H3v-2m0 5h18v2H3v-2Z"/></svg>
</label>
<div class="md-header__title" data-md-component="header-title">
<div class="md-header__ellipsis">
<div class="md-header__topic">
<span class="md-ellipsis">
DAARION Documentation
</span>
</div>
<div class="md-header__topic" data-md-component="header-topic">
<span class="md-ellipsis">
microdao_Data_Model_UPDATE_v1.md
</span>
</div>
</div>
</div>
<script>var media,input,key,value,palette=__md_get("__palette");if(palette&&palette.color){"(prefers-color-scheme)"===palette.color.media&&(media=matchMedia("(prefers-color-scheme: light)"),input=document.querySelector(media.matches?"[data-md-color-media='(prefers-color-scheme: light)']":"[data-md-color-media='(prefers-color-scheme: dark)']"),palette.color.media=input.getAttribute("data-md-color-media"),palette.color.scheme=input.getAttribute("data-md-color-scheme"),palette.color.primary=input.getAttribute("data-md-color-primary"),palette.color.accent=input.getAttribute("data-md-color-accent"));for([key,value]of Object.entries(palette.color))document.body.setAttribute("data-md-color-"+key,value)}</script>
<label class="md-header__button md-icon" for="__search">
<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24"><path d="M9.5 3A6.5 6.5 0 0 1 16 9.5c0 1.61-.59 3.09-1.56 4.23l.27.27h.79l5 5-1.5 1.5-5-5v-.79l-.27-.27A6.516 6.516 0 0 1 9.5 16 6.5 6.5 0 0 1 3 9.5 6.5 6.5 0 0 1 9.5 3m0 2C7 5 5 7 5 9.5S7 14 9.5 14 14 12 14 9.5 12 5 9.5 5Z"/></svg>
</label>
<div class="md-search" data-md-component="search" role="dialog">
<label class="md-search__overlay" for="__search"></label>
<div class="md-search__inner" role="search">
<form class="md-search__form" name="search">
<input type="text" class="md-search__input" name="query" aria-label="Search" placeholder="Search" autocapitalize="off" autocorrect="off" autocomplete="off" spellcheck="false" data-md-component="search-query" required>
<label class="md-search__icon md-icon" for="__search">
<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24"><path d="M9.5 3A6.5 6.5 0 0 1 16 9.5c0 1.61-.59 3.09-1.56 4.23l.27.27h.79l5 5-1.5 1.5-5-5v-.79l-.27-.27A6.516 6.516 0 0 1 9.5 16 6.5 6.5 0 0 1 3 9.5 6.5 6.5 0 0 1 9.5 3m0 2C7 5 5 7 5 9.5S7 14 9.5 14 14 12 14 9.5 12 5 9.5 5Z"/></svg>
<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24"><path d="M20 11v2H8l5.5 5.5-1.42 1.42L4.16 12l7.92-7.92L13.5 5.5 8 11h12Z"/></svg>
</label>
<nav class="md-search__options" aria-label="Search">
<button type="reset" class="md-search__icon md-icon" title="Clear" aria-label="Clear" tabindex="-1">
<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24"><path d="M19 6.41 17.59 5 12 10.59 6.41 5 5 6.41 10.59 12 5 17.59 6.41 19 12 13.41 17.59 19 19 17.59 13.41 12 19 6.41Z"/></svg>
</button>
</nav>
</form>
<div class="md-search__output">
<div class="md-search__scrollwrap" data-md-scrollfix>
<div class="md-search-result" data-md-component="search-result">
<div class="md-search-result__meta">
Initializing search
</div>
<ol class="md-search-result__list" role="presentation"></ol>
</div>
</div>
</div>
</div>
</div>
</nav>
</header>
<div class="md-container" data-md-component="container">
<main class="md-main" data-md-component="main">
<div class="md-main__inner md-grid">
<div class="md-sidebar md-sidebar--primary" data-md-component="sidebar" data-md-type="navigation" >
<div class="md-sidebar__scrollwrap">
<div class="md-sidebar__inner">
<nav class="md-nav md-nav--primary" aria-label="Navigation" data-md-level="0">
<label class="md-nav__title" for="__drawer">
<a href="../.." title="DAARION Documentation" class="md-nav__button md-logo" aria-label="DAARION Documentation" data-md-component="logo">
<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24"><path d="M12 8a3 3 0 0 0 3-3 3 3 0 0 0-3-3 3 3 0 0 0-3 3 3 3 0 0 0 3 3m0 3.54C9.64 9.35 6.5 8 3 8v11c3.5 0 6.64 1.35 9 3.54 2.36-2.19 5.5-3.54 9-3.54V8c-3.5 0-6.64 1.35-9 3.54Z"/></svg>
</a>
DAARION Documentation
</label>
<ul class="md-nav__list" data-md-scrollfix>
<li class="md-nav__item">
<a href="../../public/" class="md-nav__link">
<span class="md-ellipsis">
Home
</span>
</a>
</li>
<li class="md-nav__item">
<a href="../../public/getting-started/" class="md-nav__link">
<span class="md-ellipsis">
Getting Started
</span>
</a>
</li>
<li class="md-nav__item">
<a href="../../public/architecture-overview/" class="md-nav__link">
<span class="md-ellipsis">
Architecture
</span>
</a>
</li>
<li class="md-nav__item">
<a href="../../public/daiS_daos_overview/" class="md-nav__link">
<span class="md-ellipsis">
DAIS & DAOS
</span>
</a>
</li>
<li class="md-nav__item md-nav__item--section md-nav__item--nested">
<input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_5" >
<label class="md-nav__link" for="__nav_5" id="__nav_5_label" tabindex="">
<span class="md-ellipsis">
Internal
</span>
<span class="md-nav__icon md-icon"></span>
</label>
<nav class="md-nav" data-md-level="1" aria-labelledby="__nav_5_label" aria-expanded="false">
<label class="md-nav__title" for="__nav_5">
<span class="md-nav__icon md-icon"></span>
Internal
</label>
<ul class="md-nav__list" data-md-scrollfix>
<li class="md-nav__item md-nav__item--nested">
<input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_5_1" >
<label class="md-nav__link" for="__nav_5_1" id="__nav_5_1_label" tabindex="0">
<span class="md-ellipsis">
Infra
</span>
<span class="md-nav__icon md-icon"></span>
</label>
<nav class="md-nav" data-md-level="2" aria-labelledby="__nav_5_1_label" aria-expanded="false">
<label class="md-nav__title" for="__nav_5_1">
<span class="md-nav__icon md-icon"></span>
Infra
</label>
<ul class="md-nav__list" data-md-scrollfix>
<li class="md-nav__item">
<a href="../../internal/infra/INFRA_AUTOMATION_PACK_V1/" class="md-nav__link">
<span class="md-ellipsis">
Infra Automation Pack v1
</span>
</a>
</li>
<li class="md-nav__item">
<a href="../../internal/infra/monitoring_overview/" class="md-nav__link">
<span class="md-ellipsis">
Monitoring Overview
</span>
</a>
</li>
<li class="md-nav__item">
<a href="../../internal/infra/nodes_registry_v0/" class="md-nav__link">
<span class="md-ellipsis">
Nodes Registry v0
</span>
</a>
</li>
</ul>
</nav>
</li>
<li class="md-nav__item md-nav__item--nested">
<input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_5_2" >
<label class="md-nav__link" for="__nav_5_2" id="__nav_5_2_label" tabindex="0">
<span class="md-ellipsis">
Specs
</span>
<span class="md-nav__icon md-icon"></span>
</label>
<nav class="md-nav" data-md-level="2" aria-labelledby="__nav_5_2_label" aria-expanded="false">
<label class="md-nav__title" for="__nav_5_2">
<span class="md-nav__icon md-icon"></span>
Specs
</label>
<ul class="md-nav__list" data-md-scrollfix>
<li class="md-nav__item">
<a href="../../internal/specs/matrix_presence_aggregator/" class="md-nav__link">
<span class="md-ellipsis">
Matrix Presence Aggregator
</span>
</a>
</li>
<li class="md-nav__item">
<a href="../../internal/specs/city_map_spec/" class="md-nav__link">
<span class="md-ellipsis">
City Map Spec
</span>
</a>
</li>
<li class="md-nav__item">
<a href="../../internal/specs/node_join_protocol_draft/" class="md-nav__link">
<span class="md-ellipsis">
Node Join Protocol (Draft)
</span>
</a>
</li>
</ul>
</nav>
</li>
</ul>
</nav>
</li>
</ul>
</nav>
</div>
</div>
</div>
<div class="md-sidebar md-sidebar--secondary" data-md-component="sidebar" data-md-type="toc" >
<div class="md-sidebar__scrollwrap">
<div class="md-sidebar__inner">
<nav class="md-nav md-nav--secondary" aria-label="Table of contents">
<label class="md-nav__title" for="__toc">
<span class="md-nav__icon md-icon"></span>
Table of contents
</label>
<ul class="md-nav__list" data-md-component="toc" data-md-scrollfix>
<li class="md-nav__item">
<a href="#microdao-data-model-update-foundation-layer" class="md-nav__link">
<span class="md-ellipsis">
microDAO — Data Model Update (Foundation Layer)
</span>
</a>
</li>
</ul>
</nav>
</div>
</div>
</div>
<div class="md-content" data-md-component="content">
<article class="md-content__inner md-typeset">
<h1 id="microdao_data_model_update_v1md">microdao_Data_Model_UPDATE_v1.md<a class="headerlink" href="#microdao_data_model_update_v1md" title="Permanent link">&para;</a></h1>
<h2 id="microdao-data-model-update-foundation-layer">microDAO — Data Model Update (Foundation Layer)<a class="headerlink" href="#microdao-data-model-update-foundation-layer" title="Permanent link">&para;</a></h2>
<p><strong>Version:</strong> 1.0<br />
<strong>Status:</strong> Non-Breaking Schema Extension<br />
<strong>Scope:</strong> agents, microdaos, nodes, assignments, capabilities, metadata</p>
<hr />
<h1 id="0">0. Мета документа<a class="headerlink" href="#0" title="Permanent link">&para;</a></h1>
<p>Цей документ визначає оновлену модель даних microDAO, яка:</p>
<ul>
<li>формалізує онтологію DAARION (Agent → MicroDAO → Node → District),</li>
<li>вводить нові інваріанти,</li>
<li>додає нові сутності та поля,</li>
<li>стандартизує JSON-поля <code>capabilities</code> і <code>metadata</code>,</li>
<li>додає шар Assignment для агента, який працює в інших MicroDAO,</li>
<li>залишається сумісною з існуючою системою (non-breaking).</li>
</ul>
<hr />
<h1 id="1">1. Загальна структура моделі<a class="headerlink" href="#1" title="Permanent link">&para;</a></h1>
<p>Оновлена модель складається з п’яти головних сутностей:</p>
<ol>
<li><code>agents</code> (оновлено)</li>
<li><code>microdaos</code> (оновлено)</li>
<li><code>nodes</code> (оновлено)</li>
<li><code>agent_assignments</code> (нова таблиця)</li>
<li><code>event_log</code> / outbox (оновлено відповідно до подій)</li>
</ol>
<p>Усі ці сутності підтримують фундаментальну онтологію DAARION.</p>
<hr />
<h1 id="2-agents">2. Таблиця <code>agents</code> (оновлена)<a class="headerlink" href="#2-agents" title="Permanent link">&para;</a></h1>
<p>Призначення: зберігати всіх агентів міста — персональних, сервісних, інфраструктурних, core-city, orchestrator.</p>
<h2 id="21">2.1. Поля<a class="headerlink" href="#21" title="Permanent link">&para;</a></h2>
<div class="codehilite"><pre><span></span><code><span class="n">agents</span><span class="w"> </span><span class="p">(</span>
<span class="w"> </span><span class="n">id</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">primary</span><span class="w"> </span><span class="k">key</span><span class="p">,</span>
<span class="w"> </span><span class="n">dais_identity_id</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="p">,</span>
<span class="w"> </span><span class="c1">-- базова приписка</span>
<span class="w"> </span><span class="n">home_microdao_id</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">references</span><span class="w"> </span><span class="n">microdaos</span><span class="p">(</span><span class="n">id</span><span class="p">),</span>
<span class="w"> </span><span class="n">home_node_id</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">references</span><span class="w"> </span><span class="n">nodes</span><span class="p">(</span><span class="n">id</span><span class="p">),</span>
<span class="w"> </span><span class="c1">-- роль агента</span>
<span class="w"> </span><span class="k">role</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">check</span><span class="w"> </span><span class="p">(</span><span class="k">role</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span class="p">(</span><span class="s1">&#39;regular&#39;</span><span class="p">,</span><span class="s1">&#39;orchestrator&#39;</span><span class="p">)),</span>
<span class="w"> </span><span class="c1">-- тип діяльності (розширений шар)</span>
<span class="w"> </span><span class="n">service_scope</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">null</span><span class="w"> </span>
<span class="w"> </span><span class="k">check</span><span class="w"> </span><span class="p">(</span><span class="n">service_scope</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span class="p">(</span><span class="s1">&#39;microdao&#39;</span><span class="p">,</span><span class="s1">&#39;district&#39;</span><span class="p">,</span><span class="s1">&#39;city&#39;</span><span class="p">)),</span>
<span class="w"> </span><span class="n">metadata</span><span class="w"> </span><span class="n">jsonb</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">default</span><span class="w"> </span><span class="s1">&#39;{}&#39;</span><span class="p">::</span><span class="n">jsonb</span><span class="p">,</span>
<span class="w"> </span><span class="n">created_at</span><span class="w"> </span><span class="n">timestamptz</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">default</span><span class="w"> </span><span class="n">now</span><span class="p">()</span>
<span class="p">);</span>
</code></pre></div>
<h2 id="22">2.2. Опис ключових полів<a class="headerlink" href="#22" title="Permanent link">&para;</a></h2>
<ul>
<li><code>home_microdao_id</code> — база агента (жорсткий інваріант).</li>
<li><code>home_node_id</code> — нода, на якій живе агент (може бути null).</li>
<li><code>role</code><code>regular</code> або <code>orchestrator</code>.</li>
<li><code>service_scope</code><code>microdao</code>, <code>district</code>, <code>city</code>.</li>
<li><code>metadata</code> — додаткові параметри (аватар, worker-конфіги, теги тощо).</li>
</ul>
<hr />
<h1 id="3-microdaos">3. Таблиця <code>microdaos</code> (оновлена)<a class="headerlink" href="#3-microdaos" title="Permanent link">&para;</a></h1>
<p>Призначення: зберігати root, standard, district MicroDAO.</p>
<h2 id="31">3.1. Поля<a class="headerlink" href="#31" title="Permanent link">&para;</a></h2>
<div class="codehilite"><pre><span></span><code><span class="n">microdaos</span><span class="w"> </span><span class="p">(</span>
<span class="w"> </span><span class="n">id</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">primary</span><span class="w"> </span><span class="k">key</span><span class="p">,</span>
<span class="w"> </span><span class="k">type</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span>
<span class="w"> </span><span class="k">check</span><span class="w"> </span><span class="p">(</span><span class="k">type</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span class="p">(</span><span class="s1">&#39;root&#39;</span><span class="p">,</span><span class="s1">&#39;standard&#39;</span><span class="p">,</span><span class="s1">&#39;district&#39;</span><span class="p">)),</span>
<span class="w"> </span><span class="n">primary_orchestrator_agent_id</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span>
<span class="w"> </span><span class="k">references</span><span class="w"> </span><span class="n">agents</span><span class="p">(</span><span class="n">id</span><span class="p">),</span>
<span class="w"> </span><span class="n">parent_microdao_id</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">references</span><span class="w"> </span><span class="n">microdaos</span><span class="p">(</span><span class="n">id</span><span class="p">),</span>
<span class="w"> </span><span class="n">wallet_address</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">null</span><span class="p">,</span>
<span class="w"> </span><span class="n">metadata</span><span class="w"> </span><span class="n">jsonb</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">default</span><span class="w"> </span><span class="s1">&#39;{}&#39;</span><span class="p">::</span><span class="n">jsonb</span><span class="p">,</span>
<span class="w"> </span><span class="n">created_at</span><span class="w"> </span><span class="n">timestamptz</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">default</span><span class="w"> </span><span class="n">now</span><span class="p">()</span>
<span class="p">);</span>
</code></pre></div>
<h2 id="32">3.2. Інваріанти<a class="headerlink" href="#32" title="Permanent link">&para;</a></h2>
<ul>
<li>MicroDAO не може існувати без <code>primary_orchestrator_agent_id</code>.</li>
<li><code>type='root'</code> зарезервовано для DAARION.</li>
<li><code>type='district'</code> дає розширені можливості.</li>
<li>МікроДАО можуть формувати дерево через <code>parent_microdao_id</code>.</li>
</ul>
<hr />
<h1 id="4-nodes">4. Таблиця <code>nodes</code> (оновлена)<a class="headerlink" href="#4-nodes" title="Permanent link">&para;</a></h1>
<p>Призначення: зберігати фізичні / логічні вузли виконання DAGI Mesh.</p>
<h2 id="41">4.1. Поля<a class="headerlink" href="#41" title="Permanent link">&para;</a></h2>
<div class="codehilite"><pre><span></span><code><span class="n">nodes</span><span class="w"> </span><span class="p">(</span>
<span class="w"> </span><span class="n">id</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">primary</span><span class="w"> </span><span class="k">key</span><span class="p">,</span>
<span class="w"> </span><span class="n">microdao_id</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">references</span><span class="w"> </span><span class="n">microdaos</span><span class="p">(</span><span class="n">id</span><span class="p">),</span>
<span class="w"> </span><span class="n">node_kind</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span>
<span class="w"> </span><span class="k">check</span><span class="w"> </span><span class="p">(</span><span class="n">node_kind</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span class="p">(</span>
<span class="w"> </span><span class="s1">&#39;smartphone&#39;</span><span class="p">,</span><span class="s1">&#39;laptop&#39;</span><span class="p">,</span><span class="s1">&#39;edge&#39;</span><span class="p">,</span><span class="s1">&#39;datacenter&#39;</span><span class="p">,</span>
<span class="w"> </span><span class="s1">&#39;iot&#39;</span><span class="p">,</span><span class="s1">&#39;gpu-cluster&#39;</span>
<span class="w"> </span><span class="p">)),</span>
<span class="w"> </span><span class="n">capabilities</span><span class="w"> </span><span class="n">jsonb</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">default</span><span class="w"> </span><span class="s1">&#39;{}&#39;</span><span class="p">::</span><span class="n">jsonb</span><span class="p">,</span>
<span class="w"> </span><span class="n">status</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span>
<span class="w"> </span><span class="k">check</span><span class="w"> </span><span class="p">(</span><span class="n">status</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span class="p">(</span><span class="s1">&#39;provisioning&#39;</span><span class="p">,</span><span class="s1">&#39;active&#39;</span><span class="p">,</span><span class="s1">&#39;draining&#39;</span><span class="p">,</span><span class="s1">&#39;retired&#39;</span><span class="p">)),</span>
<span class="w"> </span><span class="n">metadata</span><span class="w"> </span><span class="n">jsonb</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">default</span><span class="w"> </span><span class="s1">&#39;{}&#39;</span><span class="p">::</span><span class="n">jsonb</span><span class="p">,</span>
<span class="w"> </span><span class="n">created_at</span><span class="w"> </span><span class="n">timestamptz</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">default</span><span class="w"> </span><span class="n">now</span><span class="p">()</span>
<span class="p">);</span>
</code></pre></div>
<h2 id="42">4.2. Інваріанти<a class="headerlink" href="#42" title="Permanent link">&para;</a></h2>
<ul>
<li>Node завжди належить конкретній MicroDAO.</li>
<li>Node — реальний пристрій (не абстракція).</li>
<li>При створенні ноди генерується подія <code>node.registered</code>.</li>
</ul>
<hr />
<h1 id="5-agent_assignments">5. Таблиця <code>agent_assignments</code> (нова)<a class="headerlink" href="#5-agent_assignments" title="Permanent link">&para;</a></h1>
<p>Призначення: описує, де агент працює (service layer), не змінюючи приписку.</p>
<h2 id="51">5.1. Поля<a class="headerlink" href="#51" title="Permanent link">&para;</a></h2>
<div class="codehilite"><pre><span></span><code><span class="n">agent_assignments</span><span class="w"> </span><span class="p">(</span>
<span class="w"> </span><span class="n">id</span><span class="w"> </span><span class="n">uuid</span><span class="w"> </span><span class="k">primary</span><span class="w"> </span><span class="k">key</span><span class="p">,</span>
<span class="w"> </span><span class="n">agent_id</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">references</span><span class="w"> </span><span class="n">agents</span><span class="p">(</span><span class="n">id</span><span class="p">),</span>
<span class="w"> </span><span class="n">target_microdao_id</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">references</span><span class="w"> </span><span class="n">microdaos</span><span class="p">(</span><span class="n">id</span><span class="p">),</span>
<span class="w"> </span><span class="k">scope</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span>
<span class="w"> </span><span class="k">check</span><span class="w"> </span><span class="p">(</span><span class="k">scope</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span class="p">(</span><span class="s1">&#39;microdao&#39;</span><span class="p">,</span><span class="s1">&#39;district&#39;</span><span class="p">,</span><span class="s1">&#39;city&#39;</span><span class="p">)),</span>
<span class="w"> </span><span class="k">role</span><span class="w"> </span><span class="nb">text</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="p">,</span><span class="w"> </span><span class="c1">-- advisor/security/mentor/ops/core-team</span>
<span class="w"> </span><span class="n">start_ts</span><span class="w"> </span><span class="n">timestamptz</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">default</span><span class="w"> </span><span class="n">now</span><span class="p">(),</span>
<span class="w"> </span><span class="n">end_ts</span><span class="w"> </span><span class="n">timestamptz</span><span class="w"> </span><span class="k">null</span><span class="p">,</span>
<span class="w"> </span><span class="n">metadata</span><span class="w"> </span><span class="n">jsonb</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">null</span><span class="w"> </span><span class="k">default</span><span class="w"> </span><span class="s1">&#39;{}&#39;</span><span class="p">::</span><span class="n">jsonb</span>
<span class="p">);</span>
</code></pre></div>
<h2 id="52">5.2. Інваріанти<a class="headerlink" href="#52" title="Permanent link">&para;</a></h2>
<ul>
<li>Assignment не змінює <code>home_microdao_id</code>.</li>
<li>DAARION108 мають assignments з <code>scope='city'</code>.</li>
<li>Service/Infrastructure агенти можуть мати кілька assignments.</li>
</ul>
<hr />
<h1 id="6-json-">6. JSON-структури<a class="headerlink" href="#6-json-" title="Permanent link">&para;</a></h1>
<h2 id="61-capabilitiesjson">6.1. <code>capabilities.json</code><a class="headerlink" href="#61-capabilitiesjson" title="Permanent link">&para;</a></h2>
<div class="codehilite"><pre><span></span><code><span class="p">{</span>
<span class="w"> </span><span class="nt">&quot;cpu&quot;</span><span class="p">:</span><span class="w"> </span><span class="s2">&quot;8 cores&quot;</span><span class="p">,</span>
<span class="w"> </span><span class="nt">&quot;ram&quot;</span><span class="p">:</span><span class="w"> </span><span class="s2">&quot;32GB&quot;</span><span class="p">,</span>
<span class="w"> </span><span class="nt">&quot;gpu&quot;</span><span class="p">:</span><span class="w"> </span><span class="p">{</span>
<span class="w"> </span><span class="nt">&quot;model&quot;</span><span class="p">:</span><span class="w"> </span><span class="s2">&quot;RTX 4090&quot;</span><span class="p">,</span>
<span class="w"> </span><span class="nt">&quot;vram&quot;</span><span class="p">:</span><span class="w"> </span><span class="s2">&quot;24GB&quot;</span>
<span class="w"> </span><span class="p">},</span>
<span class="w"> </span><span class="nt">&quot;network&quot;</span><span class="p">:</span><span class="w"> </span><span class="p">{</span>
<span class="w"> </span><span class="nt">&quot;up&quot;</span><span class="p">:</span><span class="w"> </span><span class="s2">&quot;1Gbps&quot;</span><span class="p">,</span>
<span class="w"> </span><span class="nt">&quot;down&quot;</span><span class="p">:</span><span class="w"> </span><span class="s2">&quot;1Gbps&quot;</span>
<span class="w"> </span><span class="p">},</span>
<span class="w"> </span><span class="nt">&quot;sensors&quot;</span><span class="p">:</span><span class="w"> </span><span class="p">[</span><span class="s2">&quot;camera&quot;</span><span class="p">,</span><span class="s2">&quot;lidar&quot;</span><span class="p">,</span><span class="s2">&quot;temperature&quot;</span><span class="p">]</span>
<span class="p">}</span>
</code></pre></div>
<h2 id="62-metadatajson">6.2. <code>metadata.json</code><a class="headerlink" href="#62-metadatajson" title="Permanent link">&para;</a></h2>
<div class="codehilite"><pre><span></span><code><span class="p">{</span>
<span class="w"> </span><span class="nt">&quot;version&quot;</span><span class="p">:</span><span class="w"> </span><span class="s2">&quot;1.0.0&quot;</span><span class="p">,</span>
<span class="w"> </span><span class="nt">&quot;agent_type&quot;</span><span class="p">:</span><span class="w"> </span><span class="s2">&quot;service&quot;</span><span class="p">,</span>
<span class="w"> </span><span class="nt">&quot;citywide&quot;</span><span class="p">:</span><span class="w"> </span><span class="kc">true</span><span class="p">,</span>
<span class="w"> </span><span class="nt">&quot;labels&quot;</span><span class="p">:</span><span class="w"> </span><span class="p">[</span><span class="s2">&quot;core&quot;</span><span class="p">,</span><span class="s2">&quot;secure&quot;</span><span class="p">,</span><span class="s2">&quot;production&quot;</span><span class="p">],</span>
<span class="w"> </span><span class="nt">&quot;notes&quot;</span><span class="p">:</span><span class="w"> </span><span class="s2">&quot;This agent is part of DAARION108&quot;</span>
<span class="p">}</span>
</code></pre></div>
<hr />
<h1 id="7">7. Події (пов’язані з моделлю)<a class="headerlink" href="#7" title="Permanent link">&para;</a></h1>
<ul>
<li><code>agent.promoted_to_orchestrator</code></li>
<li><code>microdao.created</code></li>
<li><code>node.registered</code></li>
<li><code>microdao.promoted_to_district</code></li>
<li><code>agent.assignment_created</code></li>
<li><code>agent.assignment_ended</code></li>
</ul>
<p>Їхні схеми визначені в <code>microdao_Event_Catalog_EXTENDED_v1.md</code>.</p>
<hr />
<h1 id="8">8. Міграції (чорновий план)<a class="headerlink" href="#8" title="Permanent link">&para;</a></h1>
<ul>
<li>додати поля до <code>agents</code>;</li>
<li>додати поля до <code>microdaos</code>;</li>
<li>оновити <code>nodes</code>;</li>
<li>створити <code>agent_assignments</code>;</li>
<li>додати enum-типи (за потреби).</li>
</ul>
<hr />
<h1 id="9">9. Підсумок<a class="headerlink" href="#9" title="Permanent link">&para;</a></h1>
<p>Модель даних тепер повністю відповідає фундаментальній онтології DAARION.<br />
Усі інваріанти формалізовані, Assignment layer додано, структури capabilities/metadata стандартизовано.<br />
Документ готовий до реалізації міграцій та оновлень у коді.</p>
</article>
</div>
<script>var target=document.getElementById(location.hash.slice(1));target&&target.name&&(target.checked=target.name.startsWith("__tabbed_"))</script>
</div>
</main>
<footer class="md-footer">
<div class="md-footer-meta md-typeset">
<div class="md-footer-meta__inner md-grid">
<div class="md-copyright">
Made with
<a href="https://squidfunk.github.io/mkdocs-material/" target="_blank" rel="noopener">
Material for MkDocs
</a>
</div>
</div>
</div>
</footer>
</div>
<div class="md-dialog" data-md-component="dialog">
<div class="md-dialog__inner md-typeset"></div>
</div>
<script id="__config" type="application/json">{"base": "../..", "features": ["navigation.sections", "navigation.instant", "content.code.copy"], "search": "../../assets/javascripts/workers/search.b8dbb3d2.min.js", "translations": {"clipboard.copied": "Copied to clipboard", "clipboard.copy": "Copy to clipboard", "search.result.more.one": "1 more on this page", "search.result.more.other": "# more on this page", "search.result.none": "No matching documents", "search.result.one": "1 matching document", "search.result.other": "# matching documents", "search.result.placeholder": "Type to start searching", "search.result.term.missing": "Missing", "select.version": "Select version"}}</script>
<script src="../../assets/javascripts/bundle.3220b9d7.min.js"></script>
</body>
</html>