//// Friendship Model
export const friendships = pgTable(
  'friendships',
  {
    userId: uuid('user_id').references(() => users.id),
    anotherUserId: uuid('another_user_id').references(() => users.id),
    createdAt: timestamp('created_at').notNull().defaultNow()
  },
  (table) => ({
    primaryKey: primaryKey({
      columns: [table.userId, table.anotherUserId]
    })
  })
)

//// Friendship Relations
export const friendshipsRelations = relations(friendships, ({ one }) => ({
  user: one(users, {
    fields: [friendships.userId],
    references: [users.id]
  }),
  anotherUser: one(users, {
    fields: [friendships.anotherUserId],
    references: [users.id]
  })
}))

//// Friendship Model
export const friendships = pgTable(
  'friendships',
  {
    userId: uuid('user_id').references(() => users.id),
    anotherUserId: uuid('another_user_id').references(() => users.id),
    createdAt: timestamp('created_at').notNull().defaultNow()
  },
  (table) => ({
    primaryKey: primaryKey({
      columns: [table.userId, table.anotherUserId]
    })
  })
)

//// Friendship Relations
export const friendshipsRelations = relations(friendships, ({ one }) => ({
  user: one(users, {
    fields: [friendships.userId],
    references: [users.id]
  }),
  anotherUser: one(users, {
    fields: [friendships.anotherUserId],
    references: [users.id]
  })
}))