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

@Entity({ name: 'transaction_index' })
@Index(['msafeAddress', 'txType', 'txSubType'])
@Unique(['msafeAddress', 'digest'])
export class TransactionIndex {
  @PrimaryGeneratedColumn()
  id?: number;

  @Column()
  msafeAddress: string;

  @Column()
  digest: string;

  @Column()
  sequenceNumber: number;

  @Column()
  txType: string; // Transaction type - E.g. assets

  @Column()
  txSubType: string; // Transaction subType - E.g. coin_transfer

  @Column()
  isSendTx: boolean;

  @Column()
  isRejectTx: boolean;

  @Column()
  status: string; // History transaction status - E.g. Executed, Failed, Rejected

  @UpdateDateColumn()
  updatedAt?: Date;

  @CreateDateColumn()
  createdAt?: Date;

  @Column({ nullable: true })
  executedAt?: Date;
}