File size: 604 Bytes
312c2e2 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | import { pgTable, text, timestamp, serial } from "drizzle-orm/pg-core";
export const subscriptionsTable = pgTable("subscriptions", {
id: serial("id").primaryKey(),
userId: text("user_id").notNull().unique(),
paypalSubscriptionId: text("paypal_subscription_id"),
status: text("status").notNull().default("none"),
trialEnd: timestamp("trial_end"),
currentPeriodEnd: timestamp("current_period_end"),
createdAt: timestamp("created_at").notNull().defaultNow(),
updatedAt: timestamp("updated_at").notNull().defaultNow(),
});
export type Subscription = typeof subscriptionsTable.$inferSelect;
|