import {
  Entity,
  PrimaryGeneratedColumn,
  Column,
  ManyToOne,
  JoinColumn,
} from 'typeorm';
import { UserAiInterviews } from '../../user_ai_interviews/entities/user_ai_interviews.entity';

@Entity('interview_skill_summary')
export class InterviewSkillSummary {
  @PrimaryGeneratedColumn()
  id: number;

  @Column({ type: 'int' })
  interview_id: number;

  @Column({ type: 'int', nullable: true })
  skill_id: number;

  @Column({ type: 'varchar', length: 200, nullable: true })
  topic_name: string;

  @Column({ type: 'int', default: 0 })
  total_questions: number;

  @Column({ type: 'int', default: 0 })
  correct_count: number;

  @Column({ type: 'decimal', precision: 6, scale: 2, default: 0.0 })
  score: number;

  @Column({ type: 'json', nullable: true })
  notes: any;
}
