// schema/tests.ts
export const tests = pgTable('tests', {
id: serial('id').primaryKey(),
createdAt: timestamp('created_at').defaultNow(),
updatedAt: timestamp('updated_at').defaultNow(),
name: varchar('name', { length: 255 }).notNull(),
isVerified: boolean('is_verified').default(false),
universityId: integer('university_id').references(() => universities.id, { onDelete: 'cascade' }).notNull(),
facultyId: integer('faculty_id').references(() => faculties.id, { onDelete: 'cascade' }).notNull(),
subjectId: integer('subject_id').references(() => subjects.id, { onDelete: 'cascade' }).notNull(),
courseId: integer('course_id').references(() => courses.id, { onDelete: 'cascade' }).notNull()
})
export const testRelations = relations(tests, ({ one, many }) => ({
course: one(courses),
university: one(universities),
faculty: one(faculties),
subject: one(subjects),
user: one(users),
questions: many(questions),
}));
// schema/tests.ts
export const tests = pgTable('tests', {
id: serial('id').primaryKey(),
createdAt: timestamp('created_at').defaultNow(),
updatedAt: timestamp('updated_at').defaultNow(),
name: varchar('name', { length: 255 }).notNull(),
isVerified: boolean('is_verified').default(false),
universityId: integer('university_id').references(() => universities.id, { onDelete: 'cascade' }).notNull(),
facultyId: integer('faculty_id').references(() => faculties.id, { onDelete: 'cascade' }).notNull(),
subjectId: integer('subject_id').references(() => subjects.id, { onDelete: 'cascade' }).notNull(),
courseId: integer('course_id').references(() => courses.id, { onDelete: 'cascade' }).notNull()
})
export const testRelations = relations(tests, ({ one, many }) => ({
course: one(courses),
university: one(universities),
faculty: one(faculties),
subject: one(subjects),
user: one(users),
questions: many(questions),
}));