import {
  Entity,
  PrimaryGeneratedColumn,
  Column,
  ManyToOne,
  JoinColumn,
} from "typeorm"
import { BaseEntity } from "../../common/entities/base.entity"
import { Company } from "./company.entity"
import { CompanySubscription } from "./company-subscription.entity"

@Entity("company_subscription_histories")
export class CompanySubscriptionHistory extends BaseEntity {
  @PrimaryGeneratedColumn()
  id: number

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

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

  @Column({ type: "date", nullable: false })
  subscription_start_date: Date

  @Column({ type: "date", nullable: false })
  subscription_end_date: Date

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

  @Column({
    type: "varchar",
    nullable: false,
  })
  duration_type: string

  @Column({ type: "decimal", precision: 10, scale: 2, nullable: false })
  subscription_amount: number

  @Column({
    type: "varchar",
    nullable: false,
  })
  status: string

  @ManyToOne(() => Company)
  @JoinColumn({ name: "company_id" })
  company: Company

  @ManyToOne(() => CompanySubscription)
  @JoinColumn({ name: "subscription_id" })
  subscription: CompanySubscription
}