db/migrations/0174_peaceful_warpath.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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")
);