//schema.ts
import { defineSchema, defineTable } from "convex/server";
import { v } from "convex/values";
import { authTables } from "@convex-dev/auth/server";
export default defineSchema({
...authTables,
users: defineTable({
name: v.string(),
email: v.string(),
phone: v.string(),
company: v.optional(v.string()),
createdAt: v.number(),
}).index("by_email", ["email"]),
orders: defineTable({
orderId: v.id("orders"),
clientEmail: v.string(),
price: v.number() ?? v.string(),
createdAt: v.number(),
}).index("by_user", ["orderId"]),
});
//schema.ts
import { defineSchema, defineTable } from "convex/server";
import { v } from "convex/values";
import { authTables } from "@convex-dev/auth/server";
export default defineSchema({
...authTables,
users: defineTable({
name: v.string(),
email: v.string(),
phone: v.string(),
company: v.optional(v.string()),
createdAt: v.number(),
}).index("by_email", ["email"]),
orders: defineTable({
orderId: v.id("orders"),
clientEmail: v.string(),
price: v.number() ?? v.string(),
createdAt: v.number(),
}).index("by_user", ["orderId"]),
});