diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema/rfqLast.ts | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/db/schema/rfqLast.ts b/db/schema/rfqLast.ts index 7374538f..7ab03c30 100644 --- a/db/schema/rfqLast.ts +++ b/db/schema/rfqLast.ts @@ -54,6 +54,7 @@ export const rfqsLast = pgTable( rfqSealedYn: boolean("rfq_sealed_yn").default(false), EngPicName: varchar("eng_pic_name", { length: 50 }), + EngPicEmployeeNumber: varchar("eng_pic_employee_number", { length: 50 }), packageNo: varchar("package_no", { length: 50 }), packageName: varchar("package_name", { length: 255 }), @@ -322,6 +323,17 @@ export const rfqsLastView = pgView("rfqs_last_view").as((qb) => { projectId: sql<number | null>`${rfqsLast.projectId}`.as("project_id"), projectCode: sql<string | null>`${projects.code}`.as("project_code"), projectName: sql<string | null>`${projects.name}`.as("project_name"), + + // Classification (선급) + classNo: sql<string | null>` + CASE + WHEN ${projects.CLS_1} IS NOT NULL AND ${projects.CLS_2} IS NOT NULL + THEN CONCAT(${projects.CLS_1}, '-', ${projects.CLS_2}) + WHEN ${projects.CLS_1} IS NOT NULL + THEN ${projects.CLS_1} + ELSE NULL + END + `.as("class_no"), // Item information itemCode: sql<string | null>`${rfqsLast.itemCode}`.as("item_code"), @@ -333,6 +345,7 @@ export const rfqsLastView = pgView("rfqs_last_view").as((qb) => { // Engineering PIC engPicName: sql<string | null>`${rfqsLast.EngPicName}`.as("eng_pic_name"), + engPicEmployeeNumber: sql<string | null>`${rfqsLast.EngPicEmployeeNumber}`.as("eng_pic_employee_number"), // Status and dates status: sql<string>`${rfqsLast.status}`.as("status"), |