import {
  Column,
  CreateDateColumn,
  DeleteDateColumn,
  Entity,
  JoinColumn,
  ManyToOne,
  PrimaryGeneratedColumn,
  UpdateDateColumn,
} from "typeorm"
import { Trip } from "./trip.entity"
import { EpisodeLog } from "src/modules/customers/entities/episode_log.entity"
import { CustomerEpisode } from "src/modules/customers/entities/customer_episode.entity"

@Entity("trips_logs")
export class TripLog {
  @PrimaryGeneratedColumn()
  id: number

  @Column({ type: "int", nullable: false })
  trip_id: number

  @Column({ type: "int", nullable: false })
  episode_id: number

  @Column({ type: "int", nullable: false })
  log_id: number

  @ManyToOne(() => Trip, (trip) => trip.trip_logs, { onDelete: "CASCADE" })
  @JoinColumn({ name: "trip_id" })
  trip: Trip

  @ManyToOne(() => CustomerEpisode, (episode) => episode.trip_logs, {
    onDelete: "CASCADE",
  })
  @JoinColumn({ name: "episode_id" })
  episode: CustomerEpisode

  @ManyToOne(() => EpisodeLog, (episode_log) => episode_log.trip_logs, {
    onDelete: "CASCADE",
  })
  @JoinColumn({ name: "log_id" })
  episode_log: EpisodeLog

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

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

  @DeleteDateColumn({ type: "timestamp", nullable: true })
  deleted_at: Date
}