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

@Entity('seeker_certifications')
export class SeekerCertification {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  seeker_id: number;

  @Column({ nullable: true })
  certification_id: number;

  @Column({ name: 'certification_name', type: 'varchar', length: 255 })
  certification_name: string;

  @Column({ name: 'certification_provider', type: 'varchar', length: 150, nullable: true })
  certification_provider: string;

  @Column({ type: 'date', nullable: true })
  issue_date: string;

  @Column({ type: 'date', nullable: true })
  expiry_date: string;

  @CreateDateColumn()
  created_at: Date;

  @UpdateDateColumn()
  updated_at: Date;
}
