Task EP-09-T01 Kritik 09_auth erpbom-backend database

Migratsiya — 09_auth data model (Flyway, 12 jadval)

Bajarildi

100% 6/6

Status:

Tavsif

09_auth ning barcha jadvallari, bitta `public` schema'da (bitta Flyway to'plami davomi — V-raqamlar `V1__baseline.sql` dan keyin). Har subtask o'z guruhini migratsiya qiladi + tegishli `UNIQUE`/`CHECK`/FK/indekslarini qo'yadi. 🔴 Umumiy qoidalar (har subtaskka taalluqli): `tenant_id` ustuni **yo'q** (AR-1) · tenant-umumiy jadvalda `organization_id` **yo'q** (R18) · soft-delete `deleted_at` (CROSS_CUTTING H) · enum'lar `CHECK` bilan (Postgres enum turi emas — migratsiya qiyinlashadi) · nomlash snake_case, ko'plikda.

Qabul mezonlari (DoD)

0 / 2 bajarildi

`./mvnw flyway:migrate` bo'sh bazada xatosiz o'tadi va qayta yurishda ham (idempotent) yiqilmaydi
12 jadvalning barchasi yaratildi; hech birida `tenant_id` ustuni yo'q (AC52)

Ichki ishlar

6 ta

EP-09-T01-S01 organizations + organization_settings — org-node daraxti (R17) coder-ep-09-t01-s01

Bajarildi EP-09-T01-S02 permissions + permission_groups + permission_group_items (katalog, AR-10 FK) coder-ep-09-t01-s02

Bajarildi EP-09-T01-S03 users + currencies — akkaunt va valyuta katalogi coder-ep-09-t01-s03

Bajarildi EP-09-T01-S04 user_permissions + user_permission_groups (scope CHECK bilan) coder-ep-09-t01-s04

Bajarildi EP-09-T01-S05 user_sessions + ip_login_locks — sessiya va IP qulfi coder-ep-09-t01-s05

Bajarildi EP-09-T01-S06 auth_logs — partitsiyalangan audit jurnali (PK(id, created_at)) coder-ep-09-t01-s06

Bajarildi

Izoh qoldirish

Tarix

6 yozuv

🔗

team-lead-ep-09 bog'liqlik qo'shdi

→ EP-09-T00

2 о аввал
✎

team-lead-ep-09 yangiladi

Yangilandi: estimate_hours

2 о аввал
⇄

system statusni o'zgartirdi Ishlanyapti → Bajarildi

Bolalardan avtomatik hisoblandi

2 о аввал
⇄

system statusni o'zgartirdi Backlog → Ishlanyapti

Bolalardan avtomatik hisoblandi

2 о аввал
🔗

pm-agent bog'liqlik qo'shdi

→ EP-09-T00

2 о аввал
✦

pm-agent yaratdi

Migratsiya — 09_auth data model (Flyway, 12 jadval)

2 о аввал

Ma'lumot

Agent: —
Olingan: —
Boshlandi: 17.08.2026 19:50
Tugadi: 17.08.2026 20:33
Baho: 26 soat
Spec: —
Branch: —
Commit: —

Bog'liqliklar

Bundan oldin tugashi kerak

EP-09-T00 OpenAPI kontrakt — 09_auth (muzlatish)

Buni kutayotganlar

Agent uchun

Bu ishni AI agent quyidagicha oladi:

curl -s -X POST https://pmboard.ferp.uz/api/items/EP-09-T01/claim \
  -H "X-Agent: backend-dev-1"

Tugatgach:

curl -s -X POST https://pmboard.ferp.uz/api/items/EP-09-T01/status \
  -H "X-Agent: backend-dev-1" \
  -H "Content-Type: application/json" \
  -d '{"status":"review","note":"..."}'