import {
  Entity,
  PrimaryGeneratedColumn,
  Column,
  ManyToOne,
  JoinColumn,
  CreateDateColumn,
  UpdateDateColumn,
  DeleteDateColumn,
} from "typeorm"
import { InspectionFleetReport } from "./inspection-fleet-report.entity"
import { InspectionQuestion } from "./inspection-questions.entity"
import { InspectionAnswerOption } from "./inspection-answer-option.entity"

@Entity("inspection_fleet_answers")
export class InspectionFleetAnswer {
  @PrimaryGeneratedColumn()
  id: number

  @Column({ type: "int", nullable: true })
  inspection_fleet_report_id: number

  @Column({ type: "int", nullable: true })
  question_id: number

  @Column({ type: "int", nullable: true })
  selected_answer_id: number

  @CreateDateColumn({ type: "timestamp", default: () => "NOW()" })
  created_at: Date

  @UpdateDateColumn({ type: "timestamp", default: () => "NOW()" })
  updated_at: Date

  @DeleteDateColumn({ nullable: true })
  deleted_at: Date

  @ManyToOne(
    () => InspectionFleetReport,
    (report) => report.inspection_answers,
    {
      onDelete: "CASCADE",
    },
  )
  @JoinColumn({ name: "inspection_fleet_report_id" })
  inspection_fleet_report: InspectionFleetReport

  @ManyToOne(() => InspectionQuestion, (report) => report.inspection_answers, {
    onDelete: "CASCADE",
  })
  @JoinColumn({ name: "question_id" })
  question: InspectionQuestion

  @ManyToOne(
    () => InspectionAnswerOption,
    (report) => report.selected_in_answers,
    {
      onDelete: "CASCADE",
    },
  )
  @JoinColumn({ name: "selected_answer_id" })
  selected_answer: InspectionAnswerOption
}