(김준회) Revert "(대표님) EDP 작업사항"

태그 가져오기 실패 등 에러로 인한 Revert 처리

1 files changed, 0 insertions, 87 deletions

diff --git a/db/schema/vendorData.ts b/db/schema/vendorData.ts
index 5301e61a..c3df6b53 100644
--- a/db/schema/vendorData.ts
+++ b/db/schema/vendorData.ts
@@ -41,27 +41,6 @@ export const forms = pgTable("forms", {
     }
 })
 
-export const formsPlant = pgTable("forms_plant", {
-    id: integer("id").primaryKey().generatedAlwaysAsIdentity(),
-    projectCode: varchar("project_code", { length: 100 }).notNull(),
-    packageCode: varchar("package_code", { length: 100 }).notNull(),
-    formCode: varchar("form_code", { length: 100 }).notNull(),
-    formName: varchar("form_name", { length: 255 }).notNull(),
-    // source: varchar("source", { length: 255 }),
-    // 새로 추가된 칼럼: eng와 im
-    eng: boolean("eng").default(false).notNull(),
-    im: boolean("im").default(false).notNull(),
-    createdAt: timestamp("created_at").defaultNow().notNull(),
-    updatedAt: timestamp("updated_at").defaultNow().notNull(),
-}, (table) => {
-    return {
-        projectItemFormCodeUnique: uniqueIndex("project_item_form_code_unique").on(
-            table.projectCode,
-            table.formCode
-        ),
-    }
-})
-
 // formMetas에 projectId 추가
 export const formMetas = pgTable("form_metas", {
     id: serial("id").primaryKey(),
@@ -94,16 +73,6 @@ export const formEntries = pgTable("form_entries", {
     updatedAt: timestamp("updated_at", { withTimezone: true }).defaultNow().notNull(),
 })
 
-export const formEntriesPlant = pgTable("form_entries_plant", {
-    id: serial("id").primaryKey(),
-    formCode: varchar("form_code", { length: 50 }).notNull(),
-    data: jsonb("data").notNull(),
-    projectCode: varchar("project_code", { length: 100 }).notNull(),
-    packageCode: varchar("package_code", { length: 100 }).notNull(),
-    createdAt: timestamp("created_at", { withTimezone: true }).defaultNow().notNull(),
-    updatedAt: timestamp("updated_at", { withTimezone: true }).defaultNow().notNull(),
-})
-
 export const tags = pgTable("tags", {
     id: integer("id").primaryKey().generatedAlwaysAsIdentity(),
     contractItemId: integer("contract_item_id")
@@ -139,42 +108,6 @@ export const tags = pgTable("tags", {
     };
 });
 
-
-export const tagsPlant = pgTable("tags_plant", {
-    id: integer("id").primaryKey().generatedAlwaysAsIdentity(),
-
-    // SEDP에서 오는 고유 식별자
-    tagIdx: varchar("tag_idx", { length: 100 }).notNull(),
-    
-    // 사용자가 편집 가능한 태그 번호
-    tagNo: varchar("tag_no", { length: 100 }).notNull(),
-    
-    tagType: varchar("tag_type", { length: 50 }).notNull(),
-    class: varchar("class", { length: 100 }).notNull(),
-    tagClassId: integer("tag_class_id")
-        .references(() => tagClasses.id, { onDelete: "set null" }),
-    description: text("description"),
-    
-    // 동적 속성을 저장할 JSONB 컬럼 추가
-    attributes: jsonb("attributes").$type<Record<string, string>>(),
-    
-    createdAt: timestamp("created_at").defaultNow().notNull(),
-    updatedAt: timestamp("updated_at").defaultNow().notNull(),
-
-    projectCode: varchar("project_code", { length: 100 }).notNull(),
-    packageCode: varchar("package_code", { length: 100 }).notNull(),
-    formId: integer("form_id"),
-
-}, (table) => {
-    return {
-        projectPackageTagIdxUnique: uniqueIndex("project_package_tag_idx_unique").on(
-            table.projectCode,
-            table.packageCode,
-            table.tagIdx
-        ),
-    }
-})
-
 // tagTypes에 projectId 추가 및 복합 기본키 생성
 export const tagTypes = pgTable("tag_types", {
     code: varchar("code", { length: 50 }).notNull(),
@@ -401,26 +334,6 @@ export const vendorDataReportTemps = pgTable("vendor_data_report_temps", {
 
 export type VendorDataReportTemps = typeof vendorDataReportTemps.$inferSelect;
 
-export const vendorDataReportTempsPlant = pgTable("vendor_data_report_temps_plant", {
-    id: serial("id").primaryKey(),
-
-    projectCode: varchar("project_code", { length: 100 }).notNull(),
-    packageCode: varchar("package_code", { length: 100 }).notNull(),
-    formId: integer("form_id")
-        .notNull()
-        .references(() => forms.id, { onDelete: "cascade" }),
-    fileName: varchar("file_name", { length: 255 }).notNull(),
-    filePath: varchar("file_path", { length: 1024 }).notNull(),
-    createdAt: timestamp("created_at", { withTimezone: true })
-        .defaultNow()
-        .notNull(),
-    updatedAt: timestamp("updated_at", { withTimezone: true })
-        .defaultNow()
-        .notNull(),
-});
-
-export type VendorDataReportTempsPlant = typeof vendorDataReportTempsPlant.$inferSelect;
-
 
 export const formListsView = pgView("form_lists_view").as((qb) => {
     return qb