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