export const customers = pgTable(
"customers",
{
id: uuid("id").primaryKey().defaultRandom(),
firstName: varchar("first_name"),
lastName: varchar("last_name"),
address1: varchar("address1"),
address2: varchar("address2"),
city: varchar("city"),
state: varchar("state"),
postcode: varchar("postcode"),
country: varchar("country"),
email: varchar("email"),
phone: varchar("phone"),
bodyShopId: uuid("body_shop_id")
.references(() => bodyShops.id, { onDelete: "cascade" })
.notNull(),
createdAt: timestamp("created_at").defaultNow(),
updatedAt: timestamp("updated_at").default(defaultTimestamp.updatedAt()),
},
(_t) => [
bodyShopAdminAccessPolicy("bodyshop_admin_policy"),
bodyShopMemberAccessPolicy("bodyshop_member_policy"),
]
).enableRLS();
export const customers = pgTable(
"customers",
{
id: uuid("id").primaryKey().defaultRandom(),
firstName: varchar("first_name"),
lastName: varchar("last_name"),
address1: varchar("address1"),
address2: varchar("address2"),
city: varchar("city"),
state: varchar("state"),
postcode: varchar("postcode"),
country: varchar("country"),
email: varchar("email"),
phone: varchar("phone"),
bodyShopId: uuid("body_shop_id")
.references(() => bodyShops.id, { onDelete: "cascade" })
.notNull(),
createdAt: timestamp("created_at").defaultNow(),
updatedAt: timestamp("updated_at").default(defaultTimestamp.updatedAt()),
},
(_t) => [
bodyShopAdminAccessPolicy("bodyshop_admin_policy"),
bodyShopMemberAccessPolicy("bodyshop_member_policy"),
]
).enableRLS();