Платформа: Полная иерархия компонентов

Table Engine
├── Table (основная сущность)
│   ├── Schema (определение полей)
│   ├── Data (строки)
│   ├── Relations (связи с другими таблицами)
│   └── Permissions (права доступа)
│
├── Field Types (20+ типов)
│   ├── Basic (Text, Number, Boolean, Date)
│   ├── Select (Single select, Multi-select)
│   ├── Reference (Link to record, Lookup, Rollup)
│   ├── Computed (Formula, Auto-number)
│   ├── Rich (Rich text, Attachment, URL)
│   └── Special (Person, Phone, Email, Location, Currency)
│
├── View System (множественные представления)
│   ├── Grid (spreadsheet)
│   ├── Kanban (по select field)
│   ├── Calendar (по date field)
│   ├── Gallery (с изображениями)
│   ├── Form (ввод данных)
│   └── Timeline/Gantt (по date range)
│
├── Relation Engine (связи между таблицами)
│   ├── One-to-Many (автоматически двусторонняя)
│   ├── Many-to-Many (через junction table)
│   └── Self-reference (иерархия)
│
├── Computed Fields (вычисления)
│   ├── Formula (JavaScript-like expressions)
│   ├── Lookup (значение из связанной записи)
│   └── Rollup (агрегация: SUM, COUNT, AVG, MIN, MAX)
│
├── Permission System (4 уровня)
│   ├── Workspace-level (кто видит базу)
│   ├── Table-level (кто видит таблицу)
│   ├── Row-level (кто видит запись) — в beta
│   └── Field-level (кто видит поле)
│
├── Auto-generated API (REST + GraphQL)
│   ├── CRUD endpoints (per table)
│   ├── Filter/Sort/Pagination
│   └── Webhooks (on create/update/delete)
│
└── Auto-generated Forms
    ├── Create form (from schema)
    ├── Edit form
    └── Validation rules

Relation Types
├── One-to-Many (1:N)
│   └── Пример: Company → Contacts
│       - Одна компания → много контактов
│       - Автоматически создает обратную связь
│
├── Many-to-Many (N:M)
│   └── Пример: Tasks ↔ Tags
│       - Одна задача → много тегов
│       - Один тег → много задач
│       - Через junction table (tasks_tags)
│
└── Self-reference (иерархия)
    └── Пример: Category → Parent Category
        - Категория ссылается на родительскую
        - Создает дерево

// Математика
{Price} * {Quantity} * (1 - {Discount})

// Условия
IF({Status} = "Paid", "✅", "⏳")

// Даты
DATEADD({Start Date}, {Duration}, 'days')

// Текст
CONCATENATE({First Name}, " ", {Last Name})

// Агрегация (через Rollup)
SUM({Related Orders}[Amount])
COUNT({Related Tasks}[ID])

┌────────────────────────────────────────────────────────────┐
│ SYSTEM (15 типов систем)                                  │
│ CRM, E-commerce, ERP, PM, CMS, Analytics, HR, etc.       │
└────────────────────────────────────────────────────────────┘
                        │
                        ▼
┌────────────────────────────────────────────────────────────┐
│ ENTITY (основные сущности системы)                        │
│ Contact, Deal, Product, Order, Task, etc.                 │
└────────────────────────────────────────────────────────────┘
                        │
                        ▼
┌────────────────────────────────────────────────────────────┐
│ MODULE (группа компонентов)                               │
│ Contact Management, Pipeline, Inventory, Workflow         │
└────────────────────────────────────────────────────────────┘
                        │
                        ▼
┌────────────────────────────────────────────────────────────┐
│ COMPONENT (UI + Logic)                                     │
│ Contact Card, Kanban Board, Form, Filter                  │
└────────────────────────────────────────────────────────────┘
                        │
                        ▼
┌────────────────────────────────────────────────────────────┐
│ PRIMITIVE (базовые блоки)                                  │
│ Field, Relation, View, Permission, Activity               │
└────────────────────────────────────────────────────────────┘

CRM System
│
├── ENTITY: Contact (человек)
│   │
│   ├── MODULE: Contact Management
│   │   │
│   │   ├── COMPONENT: Contact List
│   │   │   └── PRIMITIVES:
│   │   │       ├── Table (Grid View)
│   │   │       ├── Filter (by Status, Owner)
│   │   │       ├── Search (full-text)
│   │   │       └── Pagination
│   │   │
│   │   ├── COMPONENT: Contact Card
│   │   │   └── PRIMITIVES:
│   │   │       ├── Form (name, email, phone)
│   │   │       ├── Activity Feed (timeline)
│   │   │       ├── Relation (to Company)
│   │   │       └── Attachment (files)
│   │   │
│   │   └── COMPONENT: Contact Import
│   │       └── PRIMITIVES:
│   │           ├── File Upload
│   │           ├── Field Mapping
│   │           └── Validation
│   │
│   └── MODULE: Contact Activity Tracking
│       │
│       ├── COMPONENT: Activity Timeline
│       │   └── PRIMITIVES:
│       │       ├── Activity (create, update, call, email)
│       │       ├── Timestamp
│       │       ├── User (who did it)
│       │       └── Comment
│       │
│       └── COMPONENT: Activity Calendar
│           └── PRIMITIVES:
│               ├── Calendar View
│               ├── Date field
│               └── Filter (by type)
│
├── ENTITY: Deal (сделка)
│   │
│   ├── MODULE: Pipeline Management
│   │   │
│   │   ├── COMPONENT: Kanban Board
│   │   │   └── PRIMITIVES:
│   │   │       ├── Board View
│   │   │       ├── Status (columns)
│   │   │       ├── Drag-drop
│   │   │       └── Deal Card
│   │   │
│   │   ├── COMPONENT: Deal Detail
│   │   │   └── PRIMITIVES:
│   │   │       ├── Form (amount, stage, close_date)
│   │   │       ├── Relation (to Contact, Company)
│   │   │       ├── Activity Feed
│   │   │       └── Custom Fields
│   │   │
│   │   └── COMPONENT: Pipeline Analytics
│   │       └── PRIMITIVES:
│   │           ├── Chart (funnel, trend)
│   │           ├── Rollup (SUM amount by stage)
│   │           └── Filter (by owner, date)
│   │
│   └── MODULE: Sales Automation
│       │
│       ├── COMPONENT: Workflow Builder
│       │   └── PRIMITIVES:
│       │       ├── Trigger (field change, time)
│       │       ├── Condition (IF/THEN)
│       │       ├── Action (send email, create task)
│       │       └── Notification
│       │
│       └── COMPONENT: Email Sequences
│           └── PRIMITIVES:
│               ├── Template
│               ├── Schedule
│               └── Tracking (opens, clicks)
│
├── ENTITY: Company (организация)
│   └── MODULE: Account Management
│       └── ...
│
├── ENTITY: Activity (активность)
│   └── MODULE: Activity Tracking
│       └── ...
│
└── ENTITY: Task (задача)
    └── MODULE: Task Management
        └── ...

Phase 0: Core Primitives (неделя 1)
    ↓ зависимость
Phase 1: Tabular Foundation (неделя 2-3)
    ↓ зависимость
Phase 2: Common Modules (неделя 4-6)
    ↓ зависимость
Phase 3: Specialized Components (неделя 7-12)
    ↓ зависимость
Phase 4: Integration Layer (неделя 13-14)

Phase 0
│
├── 0.1 Entity System (2 дня)
│   ├── Entity (abstract base)
│   ├── Field (базовый тип)
│   ├── Relation (связь между Entity)
│   └── Schema (описание структуры)
│
├── 0.2 Permission System (1.5 дня)
│   ├── User
│   ├── Role
│   ├── Permission (read, write, delete)
│   └── RBAC engine
│
├── 0.3 Activity System (1 день)
│   ├── Activity (create, update, delete)
│   ├── Timestamp (created_at, updated_at)
│   ├── Actor (who did it)
│   └── Activity Log
│
├── 0.4 Basic Data Types (1 день)
│   ├── STRING
│   ├── NUMBER
│   ├── BOOLEAN
│   ├── DATE
│   └── SELECT
│
└── 0.5 Storage Layer (1.5 дня)
    ├── PostgreSQL setup
    ├── JSONB для flexible schemas
    ├── Migrations system
    └── Query builder

Phase 1
│
├── 1.1 Table Engine (4 дня)
│   ├── Table (основная сущность)
│   ├── Dynamic schema (add/remove fields)
│   ├── Row CRUD operations
│   └── Validation rules
│
├── 1.2 Field Types (5 дней)
│   ├── Basic types (TEXT, NUMBER, BOOLEAN, DATE)
│   ├── Select types (SINGLE_SELECT, MULTI_SELECT)
│   ├── Reference types (LINK, LOOKUP, ROLLUP)
│   ├── Computed types (FORMULA, AUTO_NUMBER)
│   └── Special types (PERSON, EMAIL, PHONE, CURRENCY, LOCATION)
│
├── 1.3 View System (4 дня)
│   ├── Grid View (spreadsheet)
│   ├── Board View (kanban)
│   ├── Calendar View
│   ├── Gallery View
│   ├── Form View
│   └── Timeline View
│
├── 1.4 Relation Engine (3 дня)
│   ├── One-to-Many
│   ├── Many-to-Many (junction tables)
│   ├── Self-reference (hierarchy)
│   └── Auto-bidirectional links
│
├── 1.5 Computed Fields (3 дня)
│   ├── Formula engine (JavaScript-like)
│   ├── Lookup (value from related record)
│   └── Rollup (aggregation: SUM, COUNT, AVG)
│
└── 1.6 UI Components (3 дня)
    ├── Table Grid (React component)
    ├── Board Kanban (drag-drop)
    ├── Calendar component
    └── Form builder

Phase 2
│
├── 2.1 User Management (4 дня)
│   ├── User registration & login
│   ├── Role management (Admin, Member, Viewer)
│   ├── Team/Workspace
│   └── Invitation system
│
├── 2.2 Permission System Extension (3 дня)
│   ├── Workspace-level permissions
│   ├── Table-level permissions
│   ├── Row-level permissions (beta)
│   └── Field-level permissions
│
├── 2.3 Activity & Comments (3 дня)
│   ├── Activity Feed component
│   ├── Comment system (@mentions)
│   ├── Reactions (emoji)
│   └── Edit history
│
├── 2.4 Attachments (2 дня)
│   ├── File upload (S3/local)
│   ├── File types (image, pdf, office)
│   ├── Inline preview
│   └── Version control (optional)
│
├── 2.5 Notifications (3 дня)
│   ├── Email notifications
│   ├── In-app notifications
│   ├── Webhook events
│   └── Notification settings
│
├── 2.6 Workflow Automation (5 дней)
│   ├── Trigger (field change, time-based)
│   ├── Condition (IF/THEN logic)
│   ├── Action (update field, send email, create record)
│   └── Visual workflow builder
│
├── 2.7 Form Builder (3 дня)
│   ├── Auto-generated forms from schema
│   ├── Custom form layouts
│   ├── Validation rules
│   └── Submit actions
│
├── 2.8 API Layer (4 дня)
│   ├── REST API (CRUD per table)
│   ├── GraphQL API
│   ├── Authentication (JWT)
│   ├── Rate limiting
│   └── API documentation (auto-generated)
│
└── 2.9 Filter & Search (3 дня)
    ├── Advanced filters (AND/OR groups)
    ├── Full-text search
    ├── Saved filters
    └── Quick filters

Phase 3
│
├── 3.1 CRM Components (15 дней)
│   ├── Lead Management
│   ├── Sales Pipeline (Kanban + analytics)
│   ├── Contact & Company modules
│   ├── Deal Forecasting
│   └── Email Templates & Sequences
│
├── 3.2 E-commerce Components (12 дней)
│   ├── Product Catalog (variants, categories)
│   ├── Shopping Cart
│   ├── Checkout Flow
│   ├── Payment Gateway integration
│   ├── Order Management
│   └── Inventory Tracking
│
├── 3.3 Project Management Components (10 дней)
│   ├── Sprint Planning
│   ├── Task Dependencies
│   ├── Time Tracking
│   ├── Gantt Chart
│   └── Burndown Charts
│
├── 3.4 CMS Components (8 дней)
│   ├── Content Blocks
│   ├── Media Library
│   ├── Taxonomy System
│   ├── SEO Tools
│   └── Multilingual Support
│
├── 3.5 Analytics/BI Components (10 дней)
│   ├── Semantic Layer (dimensions, measures)
│   ├── Chart Builder (10+ chart types)
│   ├── Dashboard Builder
│   ├── Drill-down
│   └── Data Connectors
│
├── 3.6 HR Components (8 дней)
│   ├── Recruitment Pipeline
│   ├── Performance Reviews
│   ├── Payroll Calculator
│   └── Benefits Management
│
├── 3.7 Accounting Components (12 дней)
│   ├── Chart of Accounts
│   ├── Double-entry Engine
│   ├── Journal Entries
│   ├── Depreciation Calculator
│   └── Tax Calculator
│
└── 3.8 Other Systems (15 дней)
    ├── Helpdesk (Ticket management, SLA)
    ├── Marketing (Campaigns, Lead capture)
    ├── LMS (Courses, Assessments)
    └── Asset Management (Maintenance, Check-in/out)

Phase 4
│
├── 4.1 API Connectors (5 дней)
│   ├── Google Sheets
│   ├── Zapier integration
│   ├── Slack notifications
│   ├── Email (SMTP/IMAP)
│   └── Calendar (Google Calendar, Outlook)
│
├── 4.2 Data Import/Export (3 дня)
│   ├── CSV import/export
│   ├── Excel import/export
│   ├── JSON import/export
│   └── Field mapping
│
├── 4.3 Webhooks (2 дня)
│   ├── Outgoing webhooks (on events)
│   ├── Incoming webhooks (trigger actions)
│   └── Retry logic
│
├── 4.4 Embeds & Widgets (2 дня)
│   ├── Embeddable forms
│   ├── Public views (read-only)
│   └── iFrame widgets
│
└── 4.5 Marketplace (3 дня)
    ├── Plugin system
    ├── Template marketplace
    └── Component library

MVP Platform
│
├── Entity System
│   ├── Table (create, edit, delete)
│   ├── Field Types (10 базовых)
│   └── Row CRUD
│
├── Basic Views
│   ├── Grid View
│   └── Form View
│
├── Relations
│   └── One-to-Many (basic)
│
├── Permissions
│   ├── Workspace-level
│   └── Table-level
│
├── User Management
│   ├── Registration/Login
│   └── Basic roles (Owner, Member)
│
└── API
    └── REST API (CRUD)

Production Platform (MVP +)
│
├── Advanced Views
│   ├── Board/Kanban
│   ├── Calendar
│   ├── Timeline
│   └── Gallery
│
├── Computed Fields
│   ├── Formula
│   ├── Lookup
│   └── Rollup
│
├── Workflow Automation
│   ├── Trigger → Action
│   └── Visual builder
│
├── Advanced Permissions
│   ├── Row-level
│   └── Field-level
│
├── Activity & Comments
│   ├── Activity Feed
│   ├── @mentions
│   └── Reactions
│
├── Notifications
│   ├── Email
│   └── In-app
│
└── API Extensions
    ├── GraphQL
    └── Webhooks

Enterprise Platform (Production +)
│
├── CRM System
│   ├── Lead Management
│   ├── Sales Pipeline
│   └── Forecasting
│
├── E-commerce System
│   ├── Product Catalog
│   ├── Shopping Cart
│   └── Checkout
│
├── PM System
│   ├── Sprint Planning
│   ├── Dependencies
│   └── Time Tracking
│
├── CMS System
│   ├── Content Blocks
│   ├── Media Library
│   └── SEO Tools
│
├── Analytics/BI
│   ├── Dashboard Builder
│   ├── Charts (10+ types)
│   └── Semantic Layer
│
├── Accounting
│   ├── Chart of Accounts
│   ├── Double-entry
│   └── Tax Calculator
│
└── Integration Layer
    ├── Zapier, Slack, Email
    ├── Import/Export (CSV, Excel)
    └── Plugin Marketplace

┌─────────────────────────────────────────────────────────────────┐
│ TIMELINE (14 недель = 3.5 месяца)                              │
└─────────────────────────────────────────────────────────────────┘

Week 1: Phase 0 — Core Primitives
├── Entity, Field, Relation
├── Permissions (User, Role, RBAC)
├── Activity System
└── Storage Layer (PostgreSQL)

Week 2-3: Phase 1 — Tabular Foundation
├── Table Engine
├── Field Types (20+)
├── Views (Grid, Board, Calendar, Gallery, Form, Timeline)
├── Relation Engine
└── Computed Fields

Week 4-6: Phase 2 — Common Modules
├── User Management
├── Advanced Permissions
├── Activity & Comments
├── Attachments
├── Notifications
├── Workflow Automation
├── Form Builder
├── API (REST + GraphQL)
└── Filter & Search

Week 7-12: Phase 3 — Specialized Components
├── CRM (Lead, Pipeline, Forecasting)
├── E-commerce (Product, Cart, Checkout, Payment)
├── PM (Sprint, Dependencies, Time Tracking)
├── CMS (Blocks, Media, SEO)
├── Analytics (Dashboard, Charts, Drill-down)
├── HR (Recruitment, Payroll, Performance)
├── Accounting (Double-entry, Tax)
└── Others (Helpdesk, Marketing, LMS, Asset)

Week 13-14: Phase 4 — Integration Layer
├── API Connectors (Google, Zapier, Slack)
├── Import/Export (CSV, Excel, JSON)
├── Webhooks
├── Embeds
└── Marketplace

# ═══════════════════════════════════════════════════════════
# АВТОМАТИЧЕСКАЯ ГЕНЕРАЦИЯ ПЛАТФОРМЫ
# ═══════════════════════════════════════════════════════════

def build_platform():
    """
    Автоматически строит платформу из конфигураций
    """

    # ШАГ 1: Загрузить конфигурации компонентов
    components = load_component_configs()
    # → [Entity, Field, Relation, Permission, Activity, ...]

    # ШАГ 2: Построить граф зависимостей
    dependency_graph = build_dependency_graph(components)
    # → Entity → Field → Relation

    # ШАГ 3: Топологическая сортировка (определить порядок)
    build_order = topological_sort(dependency_graph)
    # → [Entity, Field, Relation, User, Permission, ...]

    # ШАГ 4: Генерация кода для каждого компонента
    for component in build_order:
        generate_component_code(component)
        # → Backend (Python/FastAPI)
        # → Frontend (React/TypeScript)
        # → Database (SQL migrations)
        # → API (OpenAPI spec)

    # ШАГ 5: Сборка платформы
    build_backend()
    build_frontend()
    apply_migrations()

    # ШАГ 6: Тестирование
    run_unit_tests()
    run_integration_tests()

    # ШАГ 7: Деплой
    deploy_to_staging()
    # После approval:
    deploy_to_production()

# components/crm/contact.yaml
---
meta:
  layer: universal
  name: Contact
  version: 1.0.0

fields:
  name:
    type: STRING
    required: true
    max_length: 200

  email:
    type: EMAIL
    required: false
    unique: true

  phone:
    type: PHONE
    required: false
    format: international

  company:
    type: RELATION
    target: Company
    relation_type: many_to_one

views:
  - grid
  - board
  - calendar

permissions:
  create: [member, admin]
  read: [member, admin, viewer]
  update: [member, admin]
  delete: [admin]

# Auto-generated from components/crm/contact.yaml

from pydantic import BaseModel, EmailStr
from typing import Optional
from datetime import datetime

class Contact(BaseModel):
    id: UUID
    name: str
    email: Optional[EmailStr] = None
    phone: Optional[str] = None
    company_id: Optional[UUID] = None
    created_at: datetime
    updated_at: datetime

@app.post("/api/contacts")
@require_permission("contact.create")
def create_contact(contact: Contact):
    # Auto-generated CRUD
    pass

@app.get("/api/contacts")
@require_permission("contact.read")
def list_contacts():
    pass

// Auto-generated from components/crm/contact.yaml

interface Contact {
  id: string;
  name: string;
  email?: string;
  phone?: string;
  company_id?: string;
  created_at: Date;
  updated_at: Date;
}

// Auto-generated form
export const ContactForm: React.FC = () => {
  return (
    <Form>
      <Input name="name" type="text" required />
      <Input name="email" type="email" />
      <Input name="phone" type="tel" />
      <Select name="company_id" relation="Company" />
    </Form>
  );
};

// Auto-generated views
export const ContactGrid: React.FC = () => { /* ... */ };
export const ContactBoard: React.FC = () => { /* ... */ };
export const ContactCalendar: React.FC = () => { /* ... */ };

-- Auto-generated from components/crm/contact.yaml

CREATE TABLE contacts (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    name VARCHAR(200) NOT NULL,
    email VARCHAR(255) UNIQUE,
    phone VARCHAR(50),
    company_id UUID REFERENCES companies(id),
    created_at TIMESTAMP DEFAULT NOW(),
    updated_at TIMESTAMP DEFAULT NOW()
);

CREATE INDEX idx_contacts_email ON contacts(email);
CREATE INDEX idx_contacts_company ON contacts(company_id);

# Auto-generated OpenAPI spec

/api/contacts:
  post:
    summary: Create contact
    requestBody:
      required: true
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Contact'
    responses:
      201:
        description: Created
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/Contact'