From a15475296b9da1cb83995b24acf9a6a20b635756 Mon Sep 17 00:00:00 2001 From: dujinkim Date: Sun, 15 Jun 2025 04:42:45 +0000 Subject: (최겸) user 기술영업벤더ID 추가 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/users.ts | 3 +++ 1 file changed, 3 insertions(+) (limited to 'db/schema') diff --git a/db/schema/users.ts b/db/schema/users.ts index 8346c24b..2a1e45d6 100644 --- a/db/schema/users.ts +++ b/db/schema/users.ts @@ -1,6 +1,7 @@ import { integer, pgTable, varchar,timestamp,pgEnum ,pgView, text, primaryKey} from "drizzle-orm/pg-core"; import { eq , sql} from "drizzle-orm"; import { vendors } from "./vendors"; +import { techVendors } from "./techVendors"; export const userDomainEnum = pgEnum("user_domain", ["evcp", "partners"]); @@ -11,6 +12,8 @@ export const users = pgTable("users", { email: varchar("email", { length: 255 }).notNull().unique(), companyId: integer("company_id") .references(() => vendors.id, { onDelete: "set null" }), + techCompanyId: integer("tech_company_id") + .references(() => techVendors.id, { onDelete: "set null" }), domain: userDomainEnum("domain").notNull().default("partners"), createdAt: timestamp("created_at", { withTimezone: true }) .defaultNow() -- cgit v1.2.3