blob: 41789b9939bb90b693531f97df7f0ff89b0167a3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
CREATE TABLE "vendor_types" (
"id" serial PRIMARY KEY NOT NULL,
"code" varchar(50) NOT NULL,
"name_ko" varchar(255) NOT NULL,
"name_en" varchar(255) NOT NULL,
"created_at" timestamp DEFAULT now() NOT NULL,
"updated_at" timestamp DEFAULT now() NOT NULL,
CONSTRAINT "vendor_types_code_unique" UNIQUE("code")
);
--> statement-breakpoint
ALTER TABLE "vendors" ADD COLUMN "vendor_type_id" integer;--> statement-breakpoint
ALTER TABLE "vendors" ADD CONSTRAINT "vendors_vendor_type_id_vendor_types_id_fk" FOREIGN KEY ("vendor_type_id") REFERENCES "public"."vendor_types"("id") ON DELETE no action ON UPDATE no action;
|
