import {
  Entity,
  Column,
  PrimaryGeneratedColumn,
  CreateDateColumn,
  UpdateDateColumn,
} from 'typeorm';

@Entity('certificates')
export class Certificate {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  cert_no: string;

  @Column()
  company_name: string;

  @Column()
  standard: string;

  @Column({ type: 'date', nullable: true })
  orginally_reg: Date | null;

  @Column({ type: 'date', nullable: true })
  issue_date: Date | null;

  @Column({ type: 'date', nullable: true })
  expire_date: Date | null;

  @Column()
  status: string;

  @CreateDateColumn()
  created_at: Date;

  @UpdateDateColumn()
  updated_at: Date;
}