summaryrefslogtreecommitdiff
path: root/db/migrations/0376_keen_daimon_hellstrom.sql
blob: 8bdd3b001a2447bd4a29e7ab2275cdf67453a843 (plain)
1
2
3
4
5
6
7
8
9
10
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
);