import { defineRelations } from 'drizzle-orm'
import * as schema from './schema.ts'

export const relations = defineRelations(schema, (r) => ({
  users: {
    groups: r.many.groups({
      from: r.users.id.through(r.userGroups.userId),
      to: r.groups.id.through(r.userGroups.groupId)
    })
  },
  groups: {
    members: r.many.users()
  },
  userKeys: {
    user: r.one.users({
      from: r.userKeys.userId,
      to: r.users.id
    })
  }
}))