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

@Entity({ name: 'user_assets_history' })
@Unique(['msafeAddress', 'txDigest', 'coinType'])
@Index(['msafeAddress', 'coinType', 'isReceive', 'executedAt'])
export class AssetsHistory {
  @PrimaryGeneratedColumn()
  id?: number;

  @Column()
  msafeAddress: string;

  @Column()
  txDigest: string;

  @Column()
  coinType: string;

  @Column('bigint')
  amount: string;

  @Column()
  isReceive: boolean; // distinguish between receive and spend

  @Column()
  @Index()
  executedAt: number;

  @UpdateDateColumn()
  updatedAt?: Date;

  @CreateDateColumn()
  createdAt?: Date;
}