question-group.entity.ts

import {
  Column,
  Entity,
  Index,
  ManyToOne,
  OneToMany,
  PrimaryGeneratedColumn,
} from "typeorm";
import { Event } from "./event.entity";
import { Question } from "./question.entity";

@Index(["eventId", "type", "seq"], { unique: true })
@Entity()
export class QuestionGroup {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  eventId: number;

  @ManyToOne(() => Event, { onDelete: "CASCADE" })
  event: Event;

  @Column("enum", { enum: ['__RESERVED__', "PRE_EVENT", "POST_EVENT"] })
  type: string;

  @Column()
  seq: number;

  @Column()
  title: string;

  @OneToMany(() => Question, (question) => question.questionGroup)
  questions: Question[];
}