From da00bbf203534b2663289d6fe45b6ed8663e7e11 Mon Sep 17 00:00:00 2001 From: dujinkim Date: Tue, 23 Sep 2025 02:44:05 +0000 Subject: (최겸) 구매 인포메이션, 공지사항 수정 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/information.ts | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'db') 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(), }); -- cgit v1.2.3