item.entity.ts

import { Entity, PrimaryGeneratedColumn, Column, CreateDateColumn, UpdateDateColumn, ManyToOne, JoinColumn } from 'typeorm';
import { Split } from './split.entity';

const jsonColumnType = process.env.NODE_ENV === 'test' ? 'simple-json' : 'jsonb';
const jsonArrayDefault = process.env.NODE_ENV === 'test' ? '[]' : [];

@Entity('items')
export class Item {
  @PrimaryGeneratedColumn('uuid')
  id!: string;

  @Column({ type: 'uuid' })
  splitId!: string;

  @Column({ type: 'varchar' })
  name!: string;

  @Column({ type: 'integer' })
  quantity!: number;

  @Column({ type: 'decimal', precision: 10, scale: 2 })
  unitPrice!: number;

  @Column({ type: 'decimal', precision: 10, scale: 2 })
  totalPrice!: number;

  @Column({ type: 'varchar', nullable: true })
  category?: string;

  @Column({ type: jsonColumnType, default: jsonArrayDefault })
  assignedToIds!: string[];

  @CreateDateColumn()
  createdAt!: Date;

  @UpdateDateColumn()
  updatedAt!: Date;

  @ManyToOne(() => Split, (split) => split.items)
  @JoinColumn({ name: 'splitId' })
  split?: Split;
}