pantry-app/pantry
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Week 1-2: Database schema implementation #3

New Issue
Closed
opened 2026-02-08 19:00:48 +00:00 by makiolaj · 0 comments
makiolaj commented 2026-02-08 19:00:48 +00:00
Owner
Copy Link
Copy Source

Phase: Week 1-2 - Foundation + Core Inventory

Task

Implement complete database schema with migrations, seed data, and RLS policies.

Acceptance Criteria

  • All tables created (inventory_items, products, tags, units, item_tags)
  • Enums created (tag_category, unit_type)
  • RLS policies applied
  • Indexes created
  • Functions created (convert_unit, consume_item, search_products)
  • Triggers created (update_updated_at)
  • Default units seeded
  • Default tags seeded

Technical Details

  • Use migrations from docs/DATABASE.md
  • Create 3 migration files: schema, seed_units, seed_tags
  • Test all RLS policies
  • Verify conversions work correctly

Resources

  • docs/DATABASE.md (complete schema)
  • supabase/migrations/

Estimated Effort

2 days

**Phase:** Week 1-2 - Foundation + Core Inventory ## Task Implement complete database schema with migrations, seed data, and RLS policies. ## Acceptance Criteria - [ ] All tables created (inventory_items, products, tags, units, item_tags) - [ ] Enums created (tag_category, unit_type) - [ ] RLS policies applied - [ ] Indexes created - [ ] Functions created (convert_unit, consume_item, search_products) - [ ] Triggers created (update_updated_at) - [ ] Default units seeded - [ ] Default tags seeded ## Technical Details - Use migrations from docs/DATABASE.md - Create 3 migration files: schema, seed_units, seed_tags - Test all RLS policies - Verify conversions work correctly ## Resources - docs/DATABASE.md (complete schema) - supabase/migrations/ ## Estimated Effort 2 days
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
backend
Backend (Supabase/Edge Functions)
 database
Database (Schema/Migrations)
 frontend
Frontend (Nuxt/Vue)
 infrastructure
Infrastructure (Docker/Coolify)
 mvp
Required for MVP (v0.1)
 week-1
Week 1: Foundation
 week-2
Week 2: Core Inventory
 week-3
Week 3: Barcode Scanning
 week-4
Week 4: Tag System
 week-5
Week 5: PWA & Offline
 week-6
Week 6: Deployment
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
makiolaj (Jean-Luc Makiola)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: pantry-app/pantry#3