Asoslar

Ma’lumotlar modeli

PostgreSQL jadvallari, asosiy bog‘lanishlar va holat mashinalari.

Identity va katalog

Domen	Jadvallar	Vazifa
Identity	`users`, `roles`, `user_roles`	Hisoblar va RBAC
Credentials	`sessions`, `password_reset_tokens`, `api_keys`	Browser va machine auth
Provider	`providers`, `provider_credentials`	Endpoint va encrypted secret
Model	`models`, `user_model_permissions`	Alias, capability, pricing va access

Chat, loyiha va fayllar

Jadval	Mazmun
`projects`	Foydalanuvchining suhbat guruhlari
`conversations`	Chat metadata, archive/soft-delete va pagination ustunlari
`messages`	User/assistant xabarlari
`message_parts`	Text, reasoning, tool, source va fayl qismlari
`conversation_shares`	Public immutable snapshot havolalari
`files`	Object key, integrity, MIME va lifecycle holati
`file_chunks`	Extraction natijasi
`embeddings`	1536-o‘lchamli pgvector va HNSW indeks
`conversation_summaries`	Kelajakdagi long-context summary uchun sxema

Inference, usage va operatsiya

Jadval	Mazmun
`inference_requests`	Har bir inference urinishining holati
`usage_ledger`	Token va integer micros qiymatidagi xarajat
`limits`	User/model limit siyosati
`budget_reservations`	Parallel requestlarda overspendni oldini olish
`daily_usage_rollups`, `monthly_usage_rollups`	Hisobot agregatlari
`idempotency_records`	Machine API replay himoyasi
`background_jobs`	Lease, fencing, retry va dead-letter holati
`audit_logs`	Admin va xavfsizlik amallari
`system_settings`	Platforma darajasidagi sozlama

Muhim holat mashinalari

File lifecycle

pending_upload → uploaded → verified → processing → ready
                                  └──────────────→ failed
ready / failed → deleting → deleted

Job lifecycle

queued → running (lease + fencing) → succeeded
   └──── retry_scheduled ─────────→ running
   └─────────────────────────────→ failed / dead