8000 docs: Add categories table to SUPABASE_SETUP.md · Issue #30 · laminko/SpendCheck · GitHub
[go: up one dir, main page]

Skip to content

docs: Add categories table to SUPABASE_SETUP.md #30

Closed

Description

@laminko

Summary

Update SUPABASE_SETUP.md to include the missing categories table creation SQL.

Changes

  • Added categories table creation SQL with all required columns
  • Added unique constraint on user_id + name combination
  • Added index on user_id for performance
  • Added complete RLS policies for CRUD operations
  • Updated documentation notes to mention categories table

Table Structure

The categories table includes:

  • id (uuid, primary key)
  • user_id (text, not null)
  • name (text, not null)
  • icon (text, nullable)
  • color (text, nullable)
  • is_default (boolean, default false)
  • created_at (timestamptz)

This ensures users can create and manage custom spending categories with proper data isolation through RLS policies.

Activity

  1. added a commit that references this issue on Jun 15, 2025
    249b9c6
  2. added a commit that references this issue on Jun 15, 2025
    423c960
  3. added 2 commits that reference this issue on Jun 22, 2025
    6d7f9d2
    87f0d80
  4. added 2 commits that reference this issue on Jun 30, 2025
    0291a56
    dd9343c
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

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

      0