helper-center/packages/backend/src/modules/article/article.entity.ts

import {
  Column,
  CreateDateColumn,
  Entity,
  JoinColumn,
  JoinTable,
  ManyToMany,
  OneToOne,
  PrimaryGeneratedColumn,
  UpdateDateColumn,
} from 'typeorm';
import { Category } from '../category/category.entity';
import { User } from '../user/user.entity';

@Entity()
export class Article {
  @PrimaryGeneratedColumn()
  id: number;

  @Column({ unique: false, default: '', length: 200 })
  title: string;

  @Column({ default: true })
  enable: boolean;

  @Column({ default: false })
  isShow: boolean;

  @Column({ type: 'longtext', nullable: true })
  content: string;

  @Column({ default: '' })
  remark: string;

  @OneToOne(() => Category, {
    cascade: true,
    onDelete: 'CASCADE',
    createForeignKeyConstraints: false,
  })
  @JoinColumn()
  category: Category;

  @OneToOne(() => User, {
    cascade: true,
  })
  @JoinColumn()
  user: User;

  @CreateDateColumn()
  createTime: Date;

  @UpdateDateColumn()
  updateTime: Date;

  @Column({ nullable: true })
  categoryId: number;
}