(공통) 0919 DB Migrations

1 files changed, 11 insertions, 0 deletions

diff --git a/db/migrations/0376_keen_daimon_hellstrom.sql b/db/migrations/0376_keen_daimon_hellstrom.sql
new file mode 100644
index 00000000..8bdd3b00
--- /dev/null
+++ b/db/migrations/0376_keen_daimon_hellstrom.sql
@@ -0,0 +1,11 @@
+CREATE TABLE "buyer_signatures" (
+	"id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "buyer_signatures_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+	"name" varchar(255) DEFAULT '삼성중공업' NOT NULL,
+	"image_url" text NOT NULL,
+	"data_url" text,
+	"mime_type" varchar(100),
+	"file_size" integer,
+	"is_active" boolean DEFAULT true,
+	"created_at" timestamp DEFAULT now() NOT NULL,
+	"updated_at" timestamp DEFAULT now() NOT NULL
+);