From 9ceed79cf32c896f8a998399bf1b296506b2cd4a Mon Sep 17 00:00:00 2001 From: dujinkim Date: Tue, 8 Apr 2025 03:08:19 +0000 Subject: 로그인 및 미들웨어 처리. 구조 변경 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- .../0047_broad_the_executioner.sql | 34 ++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 db/migrations_backup/0047_broad_the_executioner.sql (limited to 'db/migrations_backup/0047_broad_the_executioner.sql') diff --git a/db/migrations_backup/0047_broad_the_executioner.sql b/db/migrations_backup/0047_broad_the_executioner.sql new file mode 100644 index 00000000..287830a0 --- /dev/null +++ b/db/migrations_backup/0047_broad_the_executioner.sql @@ -0,0 +1,34 @@ +CREATE TABLE "documents" ( + "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "documents_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1), + "contract_id" integer NOT NULL, + "doc_number" varchar(100) NOT NULL, + "title" varchar(255) NOT NULL, + "status" varchar(50) DEFAULT 'ACTIVE' NOT NULL, + "issued_date" date, + "created_at" timestamp DEFAULT now() NOT NULL, + "updated_at" timestamp DEFAULT now() NOT NULL +); +--> statement-breakpoint +CREATE TABLE "issue_stages" ( + "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "issue_stages_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1), + "document_id" integer NOT NULL, + "stage_name" varchar(100) NOT NULL, + "plan_date" date, + "actual_date" date, + "created_at" timestamp DEFAULT now() NOT NULL, + "updated_at" timestamp DEFAULT now() NOT NULL +); +--> statement-breakpoint +CREATE TABLE "revisions" ( + "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "revisions_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1), + "issue_stage_id" integer NOT NULL, + "revision" varchar(50) NOT NULL, + "file_path" varchar(255), + "approved_date" date, + "created_at" timestamp DEFAULT now() NOT NULL, + "updated_at" timestamp DEFAULT now() NOT NULL +); +--> statement-breakpoint +ALTER TABLE "documents" ADD CONSTRAINT "documents_contract_id_contracts_id_fk" FOREIGN KEY ("contract_id") REFERENCES "public"."contracts"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint +ALTER TABLE "issue_stages" ADD CONSTRAINT "issue_stages_document_id_documents_id_fk" FOREIGN KEY ("document_id") REFERENCES "public"."documents"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint +ALTER TABLE "revisions" ADD CONSTRAINT "revisions_issue_stage_id_issue_stages_id_fk" FOREIGN KEY ("issue_stage_id") REFERENCES "public"."issue_stages"("id") ON DELETE cascade ON UPDATE no action; \ No newline at end of file -- cgit v1.2.3