import {
  Entity,
  PrimaryGeneratedColumn,
  Column,
  ManyToOne,
  JoinColumn,
  Index,
} from 'typeorm';
import { Character } from '../character/entities/character.entity';
import { Material } from './material.entity';

@Entity('character_materials')
@Index(['characterId', 'materialId'])
export class CharacterMaterial {
  @PrimaryGeneratedColumn('uuid')
  id: string;

  @Column({ name: 'character_id' })
  @Index()
  characterId: string;

  @ManyToOne(() => Character)
  @JoinColumn({ name: 'character_id' })
  character: Character;

  @Column({ name: 'material_id' })
  materialId: string;

  @ManyToOne(() => Material, { eager: true })
  @JoinColumn({ name: 'material_id' })
  material: Material;

  @Column({ default: 0 })
  quantity: number;
}