export const usersTable = sqliteTable('users', {
id: text('id').primaryKey(),
username: text('username'),
})
export const usersRelations = relations(usersTable, ({ many }) => ({
questions: many(questionsTable),
followers: many(usersTable, { relationName: 'followers' }),
following: many(usersTable, { relationName: 'following' }),
}))
export const usersToUsersTable = sqliteTable('users_to_users', {
followedId: text('followed_id')
.notNull()
.references(() => usersTable.id),
followerId: text('follower_id')
.notNull()
.references(() => usersTable.id),
})
export const usersToUsersRelations = relations(usersToUsersTable, ({ one }) => ({
followed: one(usersTable, {
fields: [usersToUsersTable.followedId],
references: [usersTable.id],
relationName: 'followers',
}),
follower: one(usersTable, {
fields: [usersToUsersTable.followerId],
references: [usersTable.id],
relationName: 'following',
}),
}))
export const usersTable = sqliteTable('users', {
id: text('id').primaryKey(),
username: text('username'),
})
export const usersRelations = relations(usersTable, ({ many }) => ({
questions: many(questionsTable),
followers: many(usersTable, { relationName: 'followers' }),
following: many(usersTable, { relationName: 'following' }),
}))
export const usersToUsersTable = sqliteTable('users_to_users', {
followedId: text('followed_id')
.notNull()
.references(() => usersTable.id),
followerId: text('follower_id')
.notNull()
.references(() => usersTable.id),
})
export const usersToUsersRelations = relations(usersToUsersTable, ({ one }) => ({
followed: one(usersTable, {
fields: [usersToUsersTable.followedId],
references: [usersTable.id],
relationName: 'followers',
}),
follower: one(usersTable, {
fields: [usersToUsersTable.followerId],
references: [usersTable.id],
relationName: 'following',
}),
}))