/
review
/
bot
Обзор
Документация
Войти
/
review
/
bot
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
main
src/database/models/MrComment/schema.ts
37 строк
1 KB
Semyon Okulov
init
28 июл 2025, 09:49
28 июл 2025, 09:49
874de44
Код
Авторство
О чём код?
import { relations } from 'drizzle-orm' import { integer, pgTable, serial, varchar } from 'drizzle-orm/pg-core' import { z } from 'zod' import { mrReviews } from '../MrReview' import { users } from '../User' export const mrComments = pgTable('mr_comments', { id: serial('id').primaryKey(), commentId: integer('comment_id').notNull(), commentLink: varchar('comment_link', { length: 255 }).notNull(), assignedUserId: integer('assigned_user_id') .references(() => users.id, { onDelete: 'cascade', onUpdate: 'cascade' }) .notNull(), mrReviewId: integer('mr_review_id') .references(() => mrReviews.id, { onDelete: 'cascade', onUpdate: 'cascade' }) .notNull() }) export const mrCommentsRelations = relations(mrComments, ({ one }) => ({ mrReview: one(mrReviews, { fields: [mrComments.mrReviewId], references: [mrReviews.id] }), assignedUser: one(users, { fields: [mrComments.assignedUserId], references: [users.id] }) })) export const mrCommentSchema = z.object({ id: z.number(), link: z.string() })