mini-starter/src/server/modules/advertisements/advertisement.entity.ts

import { Entity, PrimaryGeneratedColumn, Column } from 'typeorm';

@Entity('ad')
export class Advertisement {
  @PrimaryGeneratedColumn({ unsigned: true })
  id!: number;

  @Column({ 
    name: 'title', 
    type: 'varchar', 
    length: 30,
    nullable: true,
    comment: '标题'
  })
  title!: string | null;

  @Column({ 
    name: 'type_id', 
    type: 'int',
    nullable: true,
    comment: '广告类型'
  })
  typeId!: number | null;

  @Column({ 
    name: 'code', 
    type: 'varchar', 
    length: 20,
    nullable: true,
    comment: '调用别名'
  })
  code!: string | null;

  @Column({ 
    name: 'url', 
    type: 'varchar', 
    length: 255,
    nullable: true,
    comment: 'url'
  })
  url!: string | null;

  @Column({ 
    name: 'img', 
    type: 'varchar', 
    length: 100,
    nullable: true,
    comment: '图片'
  })
  img!: string | null;

  @Column({ 
    name: 'sort', 
    type: 'int',
    default: 0,
    comment: '排序'
  })
  sort!: number;

  @Column({ 
    name: 'create_time', 
    type: 'int',
    nullable: true,
    comment: '创建时间'
  })
  createTime!: number | null;

  @Column({ 
    name: 'update_time', 
    type: 'int',
    default: 0,
    comment: '更新时间'
  })
  updateTime!: number;

  @Column({ 
    name: 'status', 
    type: 'int',
    unsigned: true,
    default: 0,
    comment: '状态'
  })
  status!: number;

  @Column({ 
    name: 'action_type', 
    type: 'int',
    default: 1,
    comment: '跳转类型 0 不跳转 1webview 2小程序页面'
  })
  actionType!: number;
}