(최겸) 정보시스템 인포메이션 db 추가

1 files changed, 16 insertions, 0 deletions

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")
+);