Organizations feature #28

New issue

Closed

opened 2026-06-12 20:29:18 +00:00 by james · 0 comments

james commented

2026-06-12 20:29:18 +00:00

Owner

Network → Organizations.

Scope

Each Organization has: Name, Description, Links (multi), Date joined, Key people (refs into the People list). Carries a user_id FK.

Entities + migrations (organization + link entries + key-people refs). All scoped per-user; key-people refs must point at People owned by the same user as the Organization.
Full CRUD API + DTOs. All queries scoped to the authenticated user; cross-user access returns 404.
UI under Network → Organizations.
Tests on both DB engines, including cross-user isolation.

Acceptance criteria

Organizations can reference People; the FK survives a Person being renamed.
Deleting a Person removes their key-people reference on any Organization owned by the same user (handled in app code if engines diverge on cascade).
Round-trips on both DB engines.
User A cannot see, reference, or modify any of User B's Organizations.

Part of epic #5. Depends on #8, #10, #20, #27.

Network → Organizations. ## Scope Each Organization has: Name, Description, Links (multi), Date joined, Key people (refs into the People list). **Carries a `user_id` FK.** - Entities + migrations (organization + link entries + key-people refs). **All scoped per-user; key-people refs must point at People owned by the same user as the Organization.** - Full CRUD API + DTOs. **All queries scoped to the authenticated user; cross-user access returns 404.** - UI under Network → Organizations. - Tests on both DB engines, **including cross-user isolation**. ## Acceptance criteria - [ ] Organizations can reference People; the FK survives a Person being renamed. - [ ] Deleting a Person removes their key-people reference on any Organization owned by the same user (handled in app code if engines diverge on cascade). - [ ] Round-trips on both DB engines. - [ ] User A cannot see, reference, or modify any of User B's Organizations. Part of epic #5. Depends on #8, #10, #20, #27.

james added the

area:pwa

area:service

feature

labels

2026-06-12 20:32:15 +00:00

james referenced this issue

2026-06-12 20:44:55 +00:00

People feature with relatives, met-through, and notes #27

james referenced this issue from a commit

2026-06-24 00:38:34 +00:00

feat(db): people + organizations tables, repos, and dual-engine tests (#27)