(대표님) 정규벤더등록, 벤더문서관리, 벤더데이터입력, 첨부파일관리

1 files changed, 5 insertions, 0 deletions

diff --git a/db/schema/vendorRegistrations.ts b/db/schema/vendorRegistrations.ts
index 308d664f..d6030a75 100644
--- a/db/schema/vendorRegistrations.ts
+++ b/db/schema/vendorRegistrations.ts
@@ -8,6 +8,7 @@ import {
   timestamp,

   varchar,

   decimal,

+  boolean,

 } from "drizzle-orm/pg-core";

 import { vendors } from "./vendors";

 

@@ -24,6 +25,10 @@ export const vendorRegularRegistrations = pgTable("vendor_regular_registrations"
   assignedUser: varchar("assigned_user", { length: 100 }), // 담당자

   assignedUserCode: varchar("assigned_user_code", { length: 20 }), // 담당자코드

   remarks: text("remarks"), // 비고

+  // 안전적격성 평가 관련

+  safetyQualificationContent: text("safety_qualification_content"), // 안전적격성 평가 내용

+  // GTC Skip 관련

+  gtcSkipped: boolean("gtc_skipped").notNull().default(false), // GTC Skip 여부

   createdAt: timestamp("created_at").defaultNow(),

   updatedAt: timestamp("updated_at").defaultNow(),

 });