diff options
Diffstat (limited to 'db/schema/vendors.ts')
| -rw-r--r-- | db/schema/vendors.ts | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/db/schema/vendors.ts b/db/schema/vendors.ts index c194cf61..79ac994b 100644 --- a/db/schema/vendors.ts +++ b/db/schema/vendors.ts @@ -64,6 +64,9 @@ export const vendors = pgTable("vendors", { creditRating: varchar("credit_rating", { length: 50 }), cashFlowRating: varchar("cash_flow_rating", { length: 50 }), + // 안전적격성 평가 통과 여부 (null: 해당없음, true: 승인, false: 거절) + safetyQualificationPassed: boolean("safety_qualification_passed"), + businessSize: varchar("business_size", { length: 255 }), // 기업규모 // 성조회 가입여부: 공제회 가입여부이며, 구매에서 직접 입력하겠다는 값임. 'E'=해당없음, 'Y'=가입, 'N'=미가입, null='-' @@ -540,6 +543,9 @@ export const vendorsWithTypesAndMaterialsView = pgView("vendors_with_types_and_m END `.as("vendor_category"), + // 안전적격성 평가 통과 여부 + safetyQualificationPassed: sql<boolean | null>`${vendors.safetyQualificationPassed}`.as("safety_qualification_passed"), + // 업체대표품목 1, 2, 3 - isConfirmed = true를 우선적으로, 그 다음 false 순으로 정렬 primaryMaterial1: sql<string>` (SELECT CASE |