order-refund.mt.entity.ts 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  1. import { Entity, PrimaryGeneratedColumn, Column, CreateDateColumn, UpdateDateColumn, ManyToOne, JoinColumn, Index } from 'typeorm';
  2. import { OrderMt } from './order.mt.entity';
  3. @Entity('orders_refund_mt')
  4. @Index(['tenantId'])
  5. @Index(['tenantId', 'id'])
  6. @Index(['tenantId', 'orderNo'])
  7. @Index(['tenantId', 'refundOrderNo'])
  8. export class OrderRefundMt {
  9. @PrimaryGeneratedColumn({ unsigned: true })
  10. id!: number;
  11. @Column({ name: 'tenant_id', type: 'int', unsigned: true, comment: '租户ID' })
  12. tenantId!: number;
  13. @Column({ name: 'order_no', type: 'varchar', length: 32, nullable: true, comment: '订单号' })
  14. orderNo!: string | null;
  15. @Column({ name: 'refund_order_no', type: 'varchar', length: 32, nullable: true, comment: '退款订单号' })
  16. refundOrderNo!: string | null;
  17. @Column({ name: 'refund_amount', type: 'decimal', precision: 10, scale: 2, nullable: true, comment: '退款金额' })
  18. refundAmount!: number | null;
  19. @Column({ name: 'state', type: 'int', default: 0, comment: '0未退款1退款中2退款成功3退款失败' })
  20. state!: number;
  21. @Column({ name: 'remark', type: 'varchar', length: 255, nullable: true, comment: '备注' })
  22. remark!: string | null;
  23. @Column({ name: 'created_by', type: 'int', unsigned: true, nullable: true, comment: '创建人ID' })
  24. createdBy!: number | null;
  25. @Column({ name: 'updated_by', type: 'int', unsigned: true, nullable: true, comment: '更新人ID' })
  26. updatedBy!: number | null;
  27. @CreateDateColumn({ name: 'created_at', type: 'timestamp' })
  28. createdAt!: Date;
  29. @UpdateDateColumn({ name: 'updated_at', type: 'timestamp' })
  30. updatedAt!: Date;
  31. // 关联关系
  32. @ManyToOne(() => OrderMt)
  33. @JoinColumn({ name: 'order_no', referencedColumnName: 'orderNo' })
  34. order!: OrderMt;
  35. }