summaryrefslogtreecommitdiff
path: root/db/schema
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema')
-rw-r--r--db/schema/bidding.ts1
-rw-r--r--db/schema/techSales.ts4
2 files changed, 4 insertions, 1 deletions
diff --git a/db/schema/bidding.ts b/db/schema/bidding.ts
index 2f0dd07f..1d1fe50a 100644
--- a/db/schema/bidding.ts
+++ b/db/schema/bidding.ts
@@ -42,6 +42,7 @@ export const biddingStatusEnum = pgEnum('bidding_status', [
'bidding_opened', // 입찰공고
'bidding_closed', // 입찰마감
'evaluation_of_bidding', // 입찰평가중
+ 'approval_pending', // 결재 진행중
'bidding_disposal', // 유찰
'vendor_selected', // 업체선정
'bid_opening', // 개찰
diff --git a/db/schema/techSales.ts b/db/schema/techSales.ts
index c252a116..677e8cd3 100644
--- a/db/schema/techSales.ts
+++ b/db/schema/techSales.ts
@@ -48,7 +48,8 @@ import { techVendors, techVendorContacts, techVendorPossibleItems } from "./tech
// 기술영업 RFQ 상태
export const TECH_SALES_RFQ_STATUSES = {
RFQ_CREATED: "RFQ Created",
- RFQ_VENDOR_ASSIGNED: "RFQ Vendor Assignned",
+ RFQ_VENDOR_ASSIGNED: "RFQ Vendor Assignned",
+ APPROVAL_IN_PROGRESS: "결재 진행중",
RFQ_SENT: "RFQ Sent",
QUOTATION_ANALYSIS: "Quotation Analysis",
CLOSED: "Closed",
@@ -208,6 +209,7 @@ export const techSalesAttachments = pgTable(
fileSize: integer("file_size"),
fileType: varchar("file_type", { length: 100 }),
description: varchar("description", { length: 500 }),
+ drmEncrypted: boolean("drm_encrypted").default(false).notNull(), // DRM 암호화 여부
createdBy: integer("created_by")
.references(() => users.id, { onDelete: "set null" })
.notNull(),