(최겸) user 기술영업벤더ID 추가

1 files changed, 3 insertions, 0 deletions

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()