Skip to content

Add RecipeCollection and RecipeCollectionItem entities, EF config, migration #1151

Open

Description

@dgee2

Goal

Add the database entities for curated recipe collections.

Spec reference

docs/specs/recipe-creation-target-architecture.md — §"Related recipe usage capabilities – Curated recipe collections"

Implementation notes

  • RecipeCollection entity: Id (int PK), Title (nvarchar(200)), Summary (nvarchar(max), nullable), CreatedByUserId (int FK → MenuUser), IsCurated (bit), CreatedAtUtc
  • RecipeCollectionItem entity: composite PK (CollectionId + RecipeId), SortOrder (int)
  • EF config: cascade delete from collection to items; no cascade from recipe (restrict/set null)
  • Migration

Acceptance criteria

  • Both tables created with correct structure and cascade rules

Testing

  • Unit tests for entity configuration

Part of#1107

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    .NETPull requests that update .net codeenhancementNew feature or request

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions