From a9980dd9f0f53c9c90937947d4514c921ba05f7f Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Tue, 1 Jul 2025 02:53:46 +0000
Subject: (최겸) 정보시스템 인포메이션 db 추가
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/migrations/0174_peaceful_warpath.sql | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 db/migrations/0174_peaceful_warpath.sql

(limited to 'db/migrations/0174_peaceful_warpath.sql')

diff --git a/db/migrations/0174_peaceful_warpath.sql b/db/migrations/0174_peaceful_warpath.sql
new file mode 100644
index 00000000..2181c9ac
--- /dev/null
+++ b/db/migrations/0174_peaceful_warpath.sql
@@ -0,0 +1,16 @@
+CREATE TABLE "page_information" (
+	"id" serial PRIMARY KEY NOT NULL,
+	"page_code" varchar(100) NOT NULL,
+	"page_name" varchar(255) NOT NULL,
+	"title" varchar(500) NOT NULL,
+	"description" text NOT NULL,
+	"notice_title" varchar(500),
+	"notice_content" text,
+	"attachment_file_name" varchar(255),
+	"attachment_file_path" varchar(1024),
+	"attachment_file_size" varchar(50),
+	"is_active" boolean DEFAULT true NOT NULL,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL,
+	CONSTRAINT "page_information_page_code_unique" UNIQUE("page_code")
+);
-- 
cgit v1.2.3

