본문 바로가기

mysql

TYPEORM - Nestjs - Entity(ONETOMANY, MANYTOONE)

 

UserEntity의 user_id를 CartEntity에서 일대 다의 관계

 

@Entity('users')
export class UserEntity {
  @PrimaryGeneratedColumn()
  _id: number;

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

  @Column({ default: false, nullable: false })
  password: boolean;

  @OneToMany(() => CartEntity, (carts) => carts.user)
  carts: CartEntity[];
}
@Entity('carts')
export class CartEntity {
  @PrimaryGeneratedColumn()
  _id: number;

  @Column({ nullable: false, default: null })
  product: string;

  @Column({ nullable: false, default: null })
  quntity: number;

  @ManyToOne(() => VideoEntity, (user) => user.carts)
  @JoinColumn({ name: 'user_id' })
  user: UserEntity;
}

'mysql' 카테고리의 다른 글

TYPESCRIPT - typeorm - snakeCase  (0) 2023.07.31
TYPEORM - nestjs - save FK관련 저장문제 해결  (0) 2023.06.14
unic5n - showRoom 쿼리문  (0) 2023.04.15
LIMIT  (0) 2023.04.06
Sub-query  (0) 2023.04.06