diff options
Diffstat (limited to 'db/schema/information.ts')
| -rw-r--r-- | db/schema/information.ts | 5 |
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(),
});
|
