Wireframe Specification & Navigational Workflow

System entity-relationship mapping, screen layouts, and workflows based on WireFrame.md & Potluck.md.

Database ERD Diagram
Entity / Table Primary Key Foreign Keys Description / Role
Events EventId (PK) - Core party/gathering definition (dates, location, descriptions)
Members MemberId (PK) - Individuals attending, managing, or supplying food/items
Items ItemId (PK) EventId (FK) Dishes, supplies, or drinks needed for the event with unit of measure
EventInvites (EventId, MemberId) EventId (FK), MemberId (FK) Tracks member invitations, RSVP status, and manager/host flag
ItemAssignments (ItemId, MemberId) ItemId (FK), MemberId (FK) Fulfillment tracking: members committing quantities of specific items
UnitOfMeasure Id (PK) - Admin-managed measurement units (Ounces, Pounds, Liters, Gallons, Cups, etc.)
Key Relationship Rules:
  • One-to-Many: Each Event contains multiple Items requested for the menu.
  • Many-to-Many (EventInvites): An Event can have multiple Members invited; a Member can attend multiple Events. Includes IsManager flag for host privileges.
  • Many-to-Many (ItemAssignments): One Item can be fulfilled by one or more individuals (fractional/shared quantities).