Skip to main content
The users table stores core user account information and links to Dodo customer records. Source: ~/workspace/source/lib/drizzle/schema.ts:12-28

​
Table Definition

export const users = pgTable("users", {
  supabaseUserId: text("supabase_user_id").primaryKey(),
  dodoCustomerId: text("dodo_customer_id").notNull(),
  currentSubscriptionId: text("current_subscription_id"),
  createdAt: timestamp("created_at", {
    mode: "string",
    withTimezone: true,
  }).notNull(),
  updatedAt: timestamp("updated_at", {
    mode: "string",
    withTimezone: true,
  }).notNull(),
  deletedAt: timestamp("deleted_at", {
    mode: "string",
    withTimezone: true,
  }),
});

​
Fields

​
supabase_user_id
text
required
Primary KeySupabase authentication user ID. Links to Supabase Auth.This is the unique identifier for each user in your application.
​
dodo_customer_id
text
required
Dodo Payments customer identifier.Used in webhook handlers to identify the customer when processing payment and subscription events.Referenced in:
  • updateUserTier() at supabase/functions/dodo-webhook/index.ts:208
  • downgradeToHobbyPlan() at supabase/functions/dodo-webhook/index.ts:216
​
current_subscription_id
text
NullableReferences the active subscription ID from the subscriptions table.
  • Set to subscription ID when user has an active paid plan
  • Set to null when user is on free tier or subscription ends
  • Updated automatically by webhook events
Updated by webhook events:
  • subscription.active - Sets to new subscription ID
  • subscription.plan_changed - Updates to new subscription ID
  • subscription.cancelled - Sets to null
  • subscription.expired - Sets to null
  • subscription.failed - Sets to null
​
created_at
timestamp
required
With timezoneTimestamp when the user record was created.Stored as ISO 8601 string with timezone information.
​
updated_at
timestamp
required
With timezoneTimestamp when the user record was last updated.Stored as ISO 8601 string with timezone information.
​
deleted_at
timestamp
Nullable, With timezoneSoft delete timestamp. When set, indicates the user account has been deleted.Stored as ISO 8601 string with timezone information.

​
Relations

Defined at: lib/drizzle/schema.ts:111-117 
export const usersRelations = relations(users, ({ one, many }) => ({
  currentSubscription: one(subscriptions, {
    fields: [users.currentSubscriptionId],
    references: [subscriptions.subscriptionId],
  }),
  subscriptions: many(subscriptions),
}));

​
currentSubscription (one-to-one)

Links to the user’s current active subscription.
​
Related Table
subscriptions
Foreign key: users.current_subscription_id → subscriptions.subscription_id

​
subscriptions (one-to-many)

All subscriptions associated with this user (historical and current).
​
Related Table
subscriptions
Inverse relation through subscriptions.user_id

​
TypeScript Types

Defined at: lib/drizzle/schema.ts:126-127 
export type SelectUser = typeof users.$inferSelect;
export type InsertUser = typeof users.$inferInsert;

​
SelectUser

Type for reading user records from the database. 
type SelectUser = {
  supabaseUserId: string;
  dodoCustomerId: string;
  currentSubscriptionId: string | null;
  createdAt: string;
  updatedAt: string;
  deletedAt: string | null;
}

​
InsertUser

Type for inserting new user records. 
type InsertUser = {
  supabaseUserId: string;
  dodoCustomerId: string;
  currentSubscriptionId?: string | null;
  createdAt: string;
  updatedAt: string;
  deletedAt?: string | null;
}

​
Usage in Webhook Handlers

​
Updating User Subscription Status

When subscription becomes active (webhook events: subscription.active, subscription.plan_changed): 
const { error } = await supabase
  .from("users")
  .update({ current_subscription_id: subscriptionId })
  .eq("dodo_customer_id", dodoCustomerId);
Source: supabase/functions/dodo-webhook/index.ts:205-208

​
Downgrading User to Free Tier

When subscription ends (webhook events: subscription.cancelled, subscription.expired, subscription.failed): 
const { error } = await supabase
  .from("users")
  .update({ current_subscription_id: null })
  .eq("dodo_customer_id", dodoCustomerId);
Source: supabase/functions/dodo-webhook/index.ts:215-217

​
Query Examples

​
Get User with Current Subscription

import { db } from "@/lib/drizzle/db";
import { users, subscriptions } from "@/lib/drizzle/schema";
import { eq } from "drizzle-orm";

const user = await db
  .select()
  .from(users)
  .leftJoin(
    subscriptions,
    eq(users.currentSubscriptionId, subscriptions.subscriptionId)
  )
  .where(eq(users.supabaseUserId, userId))
  .limit(1);

​
Get All Active Subscribers

import { db } from "@/lib/drizzle/db";
import { users } from "@/lib/drizzle/schema";
import { isNotNull } from "drizzle-orm";

const activeSubscribers = await db
  .select()
  .from(users)
  .where(isNotNull(users.currentSubscriptionId));

​
Check User Subscription Status

import { db } from "@/lib/drizzle/db";
import { users } from "@/lib/drizzle/schema";
import { eq } from "drizzle-orm";

const [user] = await db
  .select({
    hasSubscription: users.currentSubscriptionId,
  })
  .from(users)
  .where(eq(users.supabaseUserId, userId))
  .limit(1);

const isPaidUser = user?.hasSubscription !== null;

Subscriptions Schema

View the subscriptions table schema

Payments Schema

View the payments table schema

Build docs developers (and LLMs) love

Get started for freeTalk to us