Self referencing composite primary key table

export const locations = pgTable(
  'locations',
  {
    id: varchar('id', { length: 60 }).notNull(),
    orgId: varchar('org_id', { length: 60 }).notNull(),
    name: varchar('name', { length: 255 }).notNull(),
    isLeaf: boolean('is_leaf').default(false).notNull(),
    parentId: varchar('parent_id', { length: 60 }),
    parentOrgId: varchar('parent_org_id', { length: 60 }),
  },
  (table) => ({
    pk: primaryKey({
      columns: [table.id, table.orgId],
      name: 'locations_pkey'
    }),
  }),
);

export const locationsRelations = relations(locations, ({ many, one }) => ({
  parent: one(locations, {
    fields: [locations.parentId, locations.parentOrgId],
    references: [locations.id, locations.orgId],
    relationName: 'parent_child',
  }),
  children: many(locations, {
    relationName: 'parent_child',
  }),
}));