Merge branch 'dujinkim' of https://github.com/DTS-Development/SHI_EVCP into dujinkimHEADdujinkim

1 files changed, 18 insertions, 0 deletions

diff --git a/db/schema/pq.ts b/db/schema/pq.ts
index a9d92953..68c58613 100644
--- a/db/schema/pq.ts
+++ b/db/schema/pq.ts
@@ -63,6 +63,23 @@ export const pqCriterias = pgTable("pq_criterias", {
     .notNull()
     .default("TEXT"),
 
+  // 내자/외자/내외자 구분 (nullable, 기본값: 내외자)
+  type: varchar("type", { length: 20 }).default("내외자"),
+
+  createdAt: timestamp("created_at").defaultNow().notNull(),
+  updatedAt: timestamp("updated_at").defaultNow().notNull(),
+});
+
+// PQ 기준 첨부파일
+export const pqCriteriasAttachments = pgTable("pq_criterias_attachments", {
+  id: serial("id").primaryKey(),
+  pqCriteriaId: integer("pq_criteria_id")
+    .notNull()
+    .references(() => pqCriterias.id, { onDelete: "cascade", onUpdate: "cascade" }),
+  fileName: varchar("file_name", { length: 255 }).notNull(),
+  originalFileName: varchar("original_file_name", { length: 255 }),
+  filePath: varchar("file_path", { length: 1024 }).notNull(),
+  fileSize: integer("file_size"),
   createdAt: timestamp("created_at").defaultNow().notNull(),
   updatedAt: timestamp("updated_at").defaultNow().notNull(),
 });
@@ -419,6 +436,7 @@ export const vendorInvestigationsView = pgView(
       
       // PQ 정보
       pqItems: vendorPQSubmissions.pqItems,
+      pqType: vendorPQSubmissions.type,
       pqNumber: vendorPQSubmissions.pqNumber,
       
       // User names and emails instead of just IDs