import {
  Column,
  Entity,
  JoinColumn,
  ManyToOne,
  PrimaryGeneratedColumn,
} from "typeorm";
import { Product } from "..";
import { Day } from "./Day";

@Entity("product_schedule", {
  comment: "Horarios en que se puede ver una producto.",
})
export class ProductSchedule {
  @PrimaryGeneratedColumn({
    type: "int",
    comment: "Número de identificación (ID) único de cada registro.",
  })
  id: number;

  @ManyToOne(() => Product, (product) => product.product_schedules, {
    onDelete: "CASCADE",
    onUpdate: "NO ACTION",
  })
  @JoinColumn({ name: "product" })
  product: Product;

  @ManyToOne(() => Day, (day) => day.product_schedules_day, {
    onDelete: "RESTRICT",
    onUpdate: "NO ACTION",
  })
  @JoinColumn({ name: "day" })
  day: Day;

  @Column({ type: "varchar", length: 5, comment: "Hora de inicio." })
  start_time: string;

  @Column({ type: "varchar", length: 5, comment: "Hora de finalización." })
  end_time: string;
}