How to define schemas for friendship table

  export const usersRelations = relations(users, ({ many }) => ({
  friendships: many(friendships),
}));

    // Friends table
export const friendships = mysqlTable(
  'friends',
  {
    userId: int('user_id').notNull(),
    friendId: int('friend_id').notNull(),
  },
  (t) => {
    return {
      pk: primaryKey(t.userId, t.friendId),
    };
  },
);
// Define relationships
export const friendshipsRelations = relations(friendships, ({ one }) => ({
    user1: one(users, {
        fields: [friendships.userId],
        references: [users.id],
    }),
    user2: one(users, {
        fields: [friendships.friendId],
        references: [users.id],
    }),
}));

  export const usersRelations = relations(users, ({ many }) => ({
  friendships: many(friendships),
}));

    // Friends table
export const friendships = mysqlTable(
  'friends',
  {
    userId: int('user_id').notNull(),
    friendId: int('friend_id').notNull(),
  },
  (t) => {
    return {
      pk: primaryKey(t.userId, t.friendId),
    };
  },
);
// Define relationships
export const friendshipsRelations = relations(friendships, ({ one }) => ({
    user1: one(users, {
        fields: [friendships.userId],
        references: [users.id],
    }),
    user2: one(users, {
        fields: [friendships.friendId],
        references: [users.id],
    }),
}));