GPT

Database Schema

// Users table with Stripe fields export const users = pgTable("users", { uuid: text("uuid").notNull().primaryKey(), email: text("email").unique(), proaccess: boolean("proaccess").default(false), stripeCustomerId: te

Prompt text

Original English text. Replace placeholders with your own details.

// Users table with Stripe fields
export const users = pgTable("users", {
 uuid: text("uuid").notNull().primaryKey(),
 email: text("email").unique(),
 pro_access: boolean("pro_access").default(false),
 stripeCustomerId: text("stripe_customer_id").unique(),
 stripeSubscriptionId: text("stripe_subscription_id").unique(),
 subscriptionStatus: text("subscription_status"),
 subscriptionPriceId: text("subscription_price_id"),
 subscriptionCurrentPeriodEnd: timestamp("subscription_current_period_end"),
 cancelAtPeriodEnd: boolean("cancel_at_period_end").default(false),
 lastInvoiceStatus: text("last_invoice_status"),
 lastPaymentError: text("last_payment_error"),
});

// Stripe events table for webhook processing
export const stripeEvents = pgTable("stripe_events", {
 stripeEventId: text("stripe_event_id").primaryKey(),
 type: text("type").notNull(),
 data: jsonb("data").notNull(),
 createdAt: timestamp("created_at").defaultNow(),
 processedAt: timestamp("processed_at"),
});

Source & attribution

Instructa AI Prompts · Instructa AI Prompts

Source-listed license: CC-BY-4.0. Prompt text is preserved; titles and previews may be shortened for display. Source examples are not NexGateHub test results.

View original source ↗ · Source credits & licenses

Explore more prompts →