Backend Issue 9: Add Board-To-Repository Link Database Model #10

New Issue

Closed

opened 2026-05-19 02:28:00 -05:00 by null · 0 comments

null commented

2026-05-19 02:28:00 -05:00

Owner

Goal

Add the data model for linking tracked Forgejo repositories to Pipeline boards.

Scope

Add mapping model between boards and tracked repositories.
Add migration and basic schema.
Do not add API routes in this issue.

Suggested Model Shape

id, board_id, repository_id, organization_id, created_at

Acceptance Criteria

Migration creates board/repository link table.
Unique constraint prevents duplicate board/repository links.
Foreign keys reference boards and Forgejo repositories.
Indexes support lookup by board and repository.

Out Of Scope

Board link API, Frontend UI.

## Goal Add the data model for linking tracked Forgejo repositories to Pipeline boards. ## Scope - Add mapping model between boards and tracked repositories. - Add migration and basic schema. - Do not add API routes in this issue. ## Suggested Model Shape `id, board_id, repository_id, organization_id, created_at` ## Acceptance Criteria - Migration creates board/repository link table. - Unique constraint prevents duplicate board/repository links. - Foreign keys reference boards and Forgejo repositories. - Indexes support lookup by board and repository. ## Out Of Scope - Board link API, Frontend UI.