Error "There is no unique constraint matching the given key for the referenced table" after run "drizzle-kit migrate"

[jdkcoder]

I got this error when running drizzle-kit generate && drizzle-kit migrate. How to fix it?

PostgresError: There is no unique constraint matching the given key for the referenced "vendors" table
    at ErrorResponse (C:\Users\joker\Desktop\acx18\X - BE\node_modules\drizzle-kit\bin.cjs:79677:27)
    at handle (C:\Users\joker\Desktop\acx18\X - BE\node_modules\drizzle-kit\bin.cjs:79454:7)
    at Socket.data (C:\Users\joker\Desktop\acx18\X - BE\node_modules\drizzle-kit\bin.cjs:79277:9)
    at Socket.emit (node:events:520:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17) {
  severity_local: '오류',
  severity: 'ERROR',
  code: '42830',
  where: 'SQL Syntax "ALTER TABLE "vendors_2_models" ADD CONSTRAINT "vendors_2_models_vendor_id_vendors_id_fk" FOREIGN KEY ("vendor_id") REFERENCES "public"."vendors"("id") ON DELETE set null ON UPDATE no action"\n' +
    'PL/pgSQL Function: 2nd SQL statement of "inline_code_block"'',
  file: 'tablecmds.c',
  line: '11586',
  routine: 'transformFkeyCheckAttrs'
}

Here is the tables & relations

import { relations } from `drizzle-orm`;
import { integer, pgTable, primaryKey, text, timestamp, jsonb, real } from `drizzle-orm/pg-core`;
import { ulid } from `ulidx`;


export const vendor = pgTable(`vendors`, {
    id: text(`id`).primaryKey().$defaultFn(() => ulid()),
    created_at: timestamp(`created_at`).notNull().defaultNow(),
    updated_at: timestamp(`updated_at`).notNull().$onUpdate(() => new Date()),
    name: text(`name`).unique().notNull(),
    country: text(`country`),
    avatar: text(`avatar`),
    sale_pages: jsonb(`sale_pages`),
    slug: text(`slug`).notNull(),
    views: integer(`views`).default(0),
    type: integer(`type`).notNull()
});


export const model = pgTable(`models`, {
    id: text(`id`).primaryKey().$defaultFn(() => ulid()),
    created_at: timestamp(`created_at`).notNull().defaultNow(),
    updated_at: timestamp(`updated_at`).notNull().$onUpdate(() => new Date()),
    name: text(`name`).unique().notNull(),
    readable_name: text(`readable_name`),
    related_names: text(`related_names`),
    country: text(`country`),
    slug: text(`slug`).notNull(),
    featured: integer(`featured`).default(0),
    circle_avatar: text(`circle_avatar`).notNull(),
    vertical_avatar: text(`vertical_avatar`),
    dob: text(`dob`),
    measurements: text(`measurements`),
    rating: real(`rating`).notNull(),
    views: integer(`views`).default(0),
})


export const vendor2Model = pgTable(`vendors_2_models`, {
    vendor_id: text(`vendor_id`).notNull().references(() => vendor.id),
    model_id: text(`model_id`).notNull().references(() => vendor.id),
}, (t) => ({ pk: primaryKey({ columns: [ t.vendor_id, t.model_id ] }), }));

export const vendorRelations = relations(vendor, ({ many }) => ({
    models: many(model),
}))


export const modelRelations = relations(model, ({ many }) => ({
    vendors: many(vendor),
}))


export const vendor2ModelRelations = relations(vendor2Model, ({ one }) => ({
    vendor: one(vendor, {
        fields: [ vendor2Model.vendor_id ],
        references: [ vendor.id ],
    }),

    model: one(model, {
        fields: [ vendor2Model.model_id ],
        references: [ model.id ],
    }),
}));

My drizzle.config.js

import { defineConfig } from "drizzle-kit";
export default defineConfig({
  dialect: "postgresql",
  dbCredentials: {
    url: `postgres://postgres:[email protected]:5432/postgres`,
  },
  schema: "./db/schemas.js",
  out: "./db/migrations",
});

My package.json

{
  "scripts": {
    "dev": "bun run --watch app.js | bunx pino-pretty",
    "migrate": "drizzle-kit generate && drizzle-kit migrate"
  },
  "dependencies": {
    "drizzle-orm": "latest",
    "elysia": "latest",
    "postgres": "latest",
    "ulidx": "latest"
  },
  "devDependencies": {
    "bun-types": "latest",
    "drizzle-kit": "latest"
  },
  "module": "app.js"
}

The .sql file after run drizzle-kit generate && drizzle-kit migrate

CREATE TABLE IF NOT EXISTS "vendors" (
	"id" text PRIMARY KEY NOT NULL,
	"created_at" timestamp DEFAULT now() NOT NULL,
	"updated_at" timestamp NOT NULL,
	"name" text NOT NULL,
	"country" text,
	"avatar" text,
	"sale_pages" jsonb,
	"slug" text NOT NULL,
	"views" integer DEFAULT 0,
	"type" integer NOT NULL,
	CONSTRAINT "vendors_name_unique" UNIQUE("name")
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "models" (
	"id" text PRIMARY KEY NOT NULL,
	"created_at" timestamp DEFAULT now() NOT NULL,
	"updated_at" timestamp NOT NULL,
	"name" text NOT NULL,
	"readable_name" text,
	"related_names" text,
	"country" text,
	"slug" text NOT NULL,
	"featured" integer DEFAULT 0,
	"circle_avatar" text NOT NULL,
	"vertical_avatar" text,
	"dob" text,
	"measurements" text,
	"rating" real NOT NULL,
	"views" integer DEFAULT 0,
	CONSTRAINT "models_name_unique" UNIQUE("name")
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "vendors_2_models" (
	"vendor_id" text NOT NULL,
	"model_id" text NOT NULL,
	CONSTRAINT "vendors_2_models_vendor_id_model_id_pk" PRIMARY KEY("vendor_id","model_id")
);
--> statement-breakpoint
DO $$ BEGIN
 ALTER TABLE "vendors_2_models" ADD CONSTRAINT "vendors_2_models_vendor_id_vendors_id_fk" FOREIGN KEY ("vendor_id") REFERENCES "public"."vendors"("id") ON DELETE set null ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;
--> statement-breakpoint
DO $$ BEGIN
 ALTER TABLE "vendors_2_models" ADD CONSTRAINT "vendors_2_models_model_id_vendors_id_fk" FOREIGN KEY ("model_id") REFERENCES "public"."vendors"("id") ON DELETE set null ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

[jdkcoder]

Adding .unique() after $defaultFn() solved my problem. I forgot that :'(

id: text(`id`).primaryKey().$defaultFn(() => ulid()).unique()