tweb-api/src/entities/task.entity.ts

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

export enum TaskStatus {
  PENDING = 'pending',
  SENDING = 'sending',
  PAUSED = 'paused',
  COMPLETED = 'completed'
}

@Entity()
export class Task {
  @PrimaryGeneratedColumn()
  id: number

  @Column()
  name: string

  @Column()
  userId: number

  @Column({ type: 'text', nullable: false })
  message: string

  @Column({ default: 0 })
  total: number

  @Column({ default: 0 })
  sent: number

  @Column({ default: 0 })
  successCount: number

  @Column({ default: false })
  delFlag: boolean

  @Column({
    type: 'enum',
    enum: TaskStatus,
    default: TaskStatus.PENDING
  })
  status: TaskStatus

  @Column({ default: 5 })
  sendLimit: number

  @Column({ type: 'datetime', precision: 6, default: null })
  startedAt: Date

  @CreateDateColumn()
  createdAt: Date

  @UpdateDateColumn()
  updatedAt: Date
}