Entities

Capture.entity.ts

import {
  BaseEntity,
  Column,
  CreateDateColumn,
  Entity,
  JoinTable,
  ManyToMany,
  PrimaryGeneratedColumn,
  UpdateDateColumn,
} from "typeorm";
import { Employee } from "./Employee.entity";
import { Ghost } from "./Ghost.entity";

@Entity()
export class Capture extends BaseEntity {
  @PrimaryGeneratedColumn()
  id: number;

  @ManyToMany(() => Ghost)
  @JoinTable()
  ghosts: Ghost[];

  @ManyToMany(() => Employee)
  @JoinTable()
  employees: Employee[];

  @Column({ type: "timestamptz" })
  last_sighting: Date;

  @CreateDateColumn()
  created_at: Date;

  @UpdateDateColumn()
  updated_at: Date;
}

Ghost.entity.ts

import {
  BaseEntity,
  Column,
  CreateDateColumn,
  Entity,
  ManyToOne,
  PrimaryGeneratedColumn,
  UpdateDateColumn,
} from "typeorm";
import { Capture } from "./Capture.entity";

@Entity()
export class Ghost extends BaseEntity {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  name: string;

  @Column({ type: "timestamptz" })
  last_sighting: Date;

  @CreateDateColumn()
  created_at: Date;

  @UpdateDateColumn()
  updated_at: Date;
}