Workspace

Settings

Prototype settings for reminders, team ownership, Supabase data structure, and future Stripe billing.

Renewal reminders

Notify 7 days and 1 day before billing dates.

Credit expiration alerts

Warn when paid credits expire within 14 days.

Gmail receipt scanning

Review invoices, receipts, renewals, trials, and credit notices from Gmail.

Plan and billing

Manage Stripe checkout, subscription status, and plan access.

Team ownership

Assign tools to team members and departments.

Stripe billing

Ready for app subscription payments later.

Supabase-ready tables

{
  "ai_tools": {
    "id": "uuid primary key",
    "user_id": "uuid references auth.users(id)",
    "name": "text not null",
    "vendor": "text",
    "category": "text",
    "plan_name": "text",
    "status": "text",
    "billing_cycle": "text",
    "monthly_cost": "numeric(10,2)",
    "renewal_date": "date",
    "billing_date": "date",
    "included_credits": "integer",
    "remaining_credits": "integer",
    "credit_unit": "text",
    "credit_expiration_date": "date",
    "rollover_rule": "text",
    "rollover_notes": "text",
    "seats": "integer default 1",
    "owner": "text",
    "usage_notes": "text",
    "created_at": "timestamp with time zone default now()",
    "updated_at": "timestamp with time zone default now()"
  },
  "subscriptions": {
    "id": "uuid primary key",
    "user_id": "uuid references auth.users(id)",
    "stripe_customer_id": "text",
    "stripe_subscription_id": "text",
    "plan_key": "text",
    "status": "text",
    "current_period_end": "timestamp with time zone"
  }
}

Stripe architecture notes

Keep app subscription billing separate from tracked AI tool expenses.
Store Stripe customer and subscription IDs on the workspace subscription record.
Gate team features and reminder limits by plan_key after payments are added.