SQL - Drizzle Self Reference

Drizzle

 

 

✅ Self Reference

---

export const postReplies = pgTable("post_replies", {
  post_reply_id: bigint({ mode: "number" })
    .primaryKey()
    .generatedAlwaysAsIdentity(),
  post_id: bigint({ mode: "number" }).references(() => posts.post_id, {
    onDelete: "cascade",
  }),
  parent_id: bigint({ mode: "number" }).references(
    (): AnyPgColumn => postReplies.post_reply_id, // AnyPgColumn은 자체 참조를 하기 위해 필요(타입 안정성)
    {
      onDelete: "cascade",
    },
  ),
  profile_id: uuid()
    .references(() => profiles.profile_id, {
      onDelete: "cascade",
    })
    .notNull(),
  reply: text().notNull(),
  created_at: timestamp().notNull().defaultNow(),
  updated_at: timestamp().notNull().defaultNow(),
});

여기서 AnyPgColumn은 Self Reference를 하기 위해 필요한 타입이다.

 

https://orm.drizzle.team/docs/indexes-constraints#foreign-key

Drizzle ORM - Indexes & Constraints