// PostgreSQL Table: admin_audit_logs
@Entity({ name: 'admin_audit_logs' })
@Index(['actorId', 'createdAt'])
export class AdminAuditLog extends BaseEntity {
  @Column({ name: 'actor_id' })
  actorId!: string;

  @Column({ name: 'actor_email' })
  actorEmail!: string;

  @Column({ name: 'actor_name', nullable: true })
  actorName?: string;

  @Column()
  action!: string; // e.g. CREATE_COURSE, UPDATE_QUESTION, BAN_USER

  @Column({ name: 'target_type', nullable: true })
  targetType?: string; // e.g. Course, User, TranslationJob

  @Column({ name: 'target_id', nullable: true })
  targetId?: string;

  @Column({ type: 'text', nullable: true })
  details?: string; // Serialized JSON of parameters & modified diffs

  @Column({ name: 'ip_address', nullable: true })
  ipAddress?: string; // Originating client IP
}

// PostgreSQL Table: reward_transactions
@Entity({ name: 'reward_transactions' })
@Index(['userId', 'createdAt'])
@Index(['transactionType', 'createdAt'])
@Index(['processingStatus', 'createdAt'])
@Index(['blockchainBatchId'])
export class RewardTransaction extends BaseEntity {
  @Column()
  userId!: string;

  @Column({ type: 'enum', enum: RewardTransactionType })
  transactionType!: RewardTransactionType; // DAILY_CLAIM, LESSON_COMPLETE, BATTLE_WIN, CONTEST_PRIZE

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

  @Column({ type: 'text', nullable: true })
  reason?: string;

  @Column({ type: 'enum', enum: TransactionProcessingStatus })
  processingStatus!: TransactionProcessingStatus; // PENDING, PROCESSING, COMPLETED, FAILED

  @Column({ type: 'varchar', nullable: true })
  blockchainTxHash?: string; // Verifiable on-chain transaction hash on Lisk L2

  @Column({ type: 'timestamp', nullable: true })
  blockchainProcessedAt?: Date;

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