(최겸) 구매 인포메이션, 공지사항 수정

1 files changed, 4 insertions, 1 deletions

diff --git a/db/schema/information.ts b/db/schema/information.ts
index f20723d5..325f02a6 100644
--- a/db/schema/information.ts
+++ b/db/schema/information.ts
@@ -1,5 +1,6 @@
 import { pgTable, varchar, timestamp, serial, boolean, text as textArea, integer } from "drizzle-orm/pg-core";

 import { relations } from "drizzle-orm";

+import { users } from "./users";

 

 // 페이지별 인포메이션 관리 테이블

 export const pageInformation = pgTable("page_information", {

@@ -13,9 +14,11 @@ export const pageInformation = pgTable("page_information", {
   

   // 활성화 여부

   isActive: boolean("is_active").default(true).notNull(), // 활성화 여부

-  

+

+  createdBy: integer("created_by").references(() => users.id), // 생성자

   // 메타데이터

   createdAt: timestamp("created_at").defaultNow().notNull(),

+  updatedBy: integer("updated_by").references(() => users.id), // 수정자

   updatedAt: timestamp("updated_at").defaultNow().notNull(),

 });