diff options
Diffstat (limited to 'db/schema/users.ts')
| -rw-r--r-- | db/schema/users.ts | 15 |
1 files changed, 9 insertions, 6 deletions
diff --git a/db/schema/users.ts b/db/schema/users.ts index 1d963228..278bc7ab 100644 --- a/db/schema/users.ts +++ b/db/schema/users.ts @@ -5,6 +5,7 @@ import { import { eq, sql } from "drizzle-orm"; import { vendors } from "./vendors"; import { techVendors } from "./techVendors"; +import { ownerCompanies } from "./companies"; export const userDomainEnum = pgEnum("user_domain", ["pending", "evcp", "procurement", "sales", "engineering", "partners"]); @@ -17,6 +18,8 @@ export const users = pgTable("users", { deptCode: varchar("deptCode", { length: 50 }), deptName: varchar("deptName", { length: 255 }), + ownerCompanyId: integer("owner_company_id") + .references(() => ownerCompanies.id, { onDelete: "set null" }), companyId: integer("company_id") .references(() => vendors.id, { onDelete: "set null" }), techCompanyId: integer("tech_company_id") @@ -49,12 +52,12 @@ export const users = pgTable("users", { deactivatedAt: timestamp("deactivated_at", { withTimezone: true }), deactivationReason: varchar("deactivation_reason", { length: 50 }), // 'INACTIVE', 'ADMIN', 'GDPR' 등 - // ✨ 새로 추가: 동의 관련 필드들 - lastConsentUpdate: timestamp("last_consent_update", { withTimezone: true }), - consentVersion: varchar("consent_version", { length: 20 }), // 마지막 동의한 정책 버전 - requiresConsentUpdate: boolean("requires_consent_update").default(false).notNull(), - - // ✨ 새로 추가: 회원가입 관련 + // ✨ 새로 추가: 동의 관련 필드들 + lastConsentUpdate: timestamp("last_consent_update", { withTimezone: true }), + consentVersion: varchar("consent_version", { length: 20 }), // 마지막 동의한 정책 버전 + requiresConsentUpdate: boolean("requires_consent_update").default(false).notNull(), + + // ✨ 새로 추가: 회원가입 관련 // emailVerified: boolean("email_verified").default(false).notNull(), // emailVerifiedAt: timestamp("email_verified_at", { withTimezone: true }), // registrationCompleted: boolean("registration_completed").default(false).notNull(), |