import { relations } from "drizzle-orm"
import { pgTable, primaryKey, uuid } from "drizzle-orm/pg-core"
import { organizations } from "./organizations"
import { users } from "./user"
export const usersToOrganizations = pgTable(
"usersToOrganizations",
{
userId: uuid("userId")
.notNull()
.references(() => users.id),
organizationId: uuid("organizationId")
.notNull()
.references(() => organizations.id),
},
(t) => ({
pk: primaryKey(t.userId, t.organizationId),
}),
)
export const usersToOrganizationsRelations = relations(
usersToOrganizations,
({ one }) => ({
organization: one(organizations, {
fields: [usersToOrganizations.organizationId],
references: [organizations.id],
}),
user: one(users, {
fields: [usersToOrganizations.userId],
references: [users.id],
}),
}),
)
export const usersRelations = relations(users, ({ many }) => ({
organizations: many(organizations),
}))
export const organizationsRelations = relations(organizations, ({ many }) => ({
users: many(users),
}))
import { relations } from "drizzle-orm"
import { pgTable, primaryKey, uuid } from "drizzle-orm/pg-core"
import { organizations } from "./organizations"
import { users } from "./user"
export const usersToOrganizations = pgTable(
"usersToOrganizations",
{
userId: uuid("userId")
.notNull()
.references(() => users.id),
organizationId: uuid("organizationId")
.notNull()
.references(() => organizations.id),
},
(t) => ({
pk: primaryKey(t.userId, t.organizationId),
}),
)
export const usersToOrganizationsRelations = relations(
usersToOrganizations,
({ one }) => ({
organization: one(organizations, {
fields: [usersToOrganizations.organizationId],
references: [organizations.id],
}),
user: one(users, {
fields: [usersToOrganizations.userId],
references: [users.id],
}),
}),
)
export const usersRelations = relations(users, ({ many }) => ({
organizations: many(organizations),
}))
export const organizationsRelations = relations(organizations, ({ many }) => ({
users: many(users),
}))