import {
  Column,
  Entity,
  Index,
  JoinColumn,
  ManyToOne,
  PrimaryGeneratedColumn,
} from "typeorm";
import { Passport } from "./Passport";

@Index("uq_passport_history_passport_id_date", ["date", "passportId"], {
  unique: true,
})
@Index("PK_passport_history", ["id"], { unique: true })
@Entity("passport_history", { schema: "core" })
export class PassportHistory {
  @PrimaryGeneratedColumn({ type: "integer", name: "id" })
  id: number;

  @Column("integer", { name: "passport_id" })
  passportId: number;

  @Column("jsonb", { name: "data", nullable: true })
  data: object | null;

  @Column("integer", { name: "created_by" })
  createdBy: number;

  @Column("timestamp without time zone", { name: "created_date" })
  createdDate: Date;

  @Column("integer", { name: "modified_by" })
  modifiedBy: number;

  @Column("timestamp without time zone", { name: "modified_date" })
  modifiedDate: Date;

  @Column("real", { name: "progress", precision: 24 })
  progress: number;

  @Column("date", { name: "date" })
  date: string;

  @ManyToOne(() => Passport, (passport) => passport.passportHistories, {
    onDelete: "CASCADE",
  })
  @JoinColumn([{ name: "passport_id", referencedColumnName: "id" }])
  passport: Passport;
}