为何NestJS/TypeORM保存时会移除传入的organizationId属性？

我是NestJS新手，正在搭建首个项目熟悉框架。定义了Organization和User两个实体，Organization相关功能正常，但创建User时始终出现organizationId为NULL的情况，无法完成保存。

实体代码 #

Organization实体 #

import { User } from "src/modules/user/entities/user.entity";
import { IOrganization } from "../interfaces/organization.interface";
import { Column, CreateDateColumn, Entity, PrimaryColumn, UpdateDateColumn, OneToMany } from "typeorm";

@Entity()
export class Organization implements IOrganization {
  @PrimaryColumn()
  id: string

  @Column({ nullable: false })
  name: string

  @OneToMany(() => User, (user) => user.organization)
  users: User[]

  @CreateDateColumn()
  createdAt: Date

  @UpdateDateColumn()
  updatedAt: Date
}

User实体 #

import { Organization } from "src/modules/organization/entities/organization.entity";
import { Column, CreateDateColumn, Entity, PrimaryColumn, UpdateDateColumn, ManyToOne, JoinColumn } from "typeorm";
import { Role } from "../enums/user.enum";

@Entity()
export class User {
  @PrimaryColumn()
  id: string

  @ManyToOne(() => Organization, (organization) => organization.users, {
    nullable: false,
  })
  @JoinColumn({ name: "organizationId" })
  organization: Organization

  @Column({ unique: true, nullable: false })
  email: string
  
  @Column ({
    type: "enum",
    enum: Role,
    default: Role.USER,
    nullable: false,
  })
  role: Role

  @Column({ nullable: false })
  name: string

  @CreateDateColumn()
  createdAt: Date

  @UpdateDateColumn()
  updatedAt: Date
}

User模块代码 #

import { Module } from '@nestjs/common';
import { TypeOrmModule } from '@nestjs/typeorm';
import { UserService } from './user.service';
import { UserController } from './user.controller';
import { User } from './entities/user.entity';
import { OrganizationService } from '../organization/organization.service';

@Module({
  imports: [TypeOrmModule.forFeature([User])],
  controllers: [UserController],
  providers: [UserService],
})
export class UserModule {}

User控制器代码 #

import { UserService } from './user.service';
import { CreateUserDto } from './dto/create-user.dto';
import { UpdateUserDto } from './dto/update-user.dto';
import { Roles } from 'src/decorators/roles.decorator';
import { AuthGuard } from '@nestjs/passport';
@Controller('user')
export class UserController {
  constructor(private readonly userService: UserService) {}

  @Post()
  @UseGuards(AuthGuard('jwt'))
  @Roles('admin')
  create(@Body() createUserDto: CreateUserDto) {
    return this.userService.create(createUserDto);
  }

  @Get()
  @UseGuards(AuthGuard('jwt'))
  @Roles('admin', 'broker', 'assistant')
  findAll() {
    return this.userService.findAll();
  }

  @Get(':id')
  @UseGuards(AuthGuard('jwt'))
  @Roles('admin', 'broker', 'assistant')
  findOne(@Param('id') id: string) {
    return this.userService.findOne(+id);
  }

  @Patch(':id')
  @UseGuards(AuthGuard('jwt'))
  @Roles('admin', 'broker', 'assistant')
  update(@Param('id') id: string, @Body() updateUserDto: UpdateUserDto) {
    return this.userService.update(+id, updateUserDto);
  }

  @Delete(':id')
  @UseGuards(AuthGuard('jwt'))
  @Roles('admin')
  remove(@Param('id') id: string) {
    return this.userService.remove(+id);
  }
}

User服务代码 #

import { Repository } from 'typeorm';
import { Inject, Injectable } from '@nestjs/common';
import { InjectRepository } from '@nestjs/typeorm';
import { User } from './entities/user.entity';
import { CreateUserDto } from './dto/create-user.dto';
import { UpdateUserDto } from './dto/update-user.dto';
import { IUser } from './interfaces/user.interface';

@Injectable()
export class UserService {
  constructor(
    @InjectRepository(User)
    private userRepository: Repository<User>,
  ) {}

  async create(createUserDto: CreateUserDto): Promise<IUser> {
    console.log('Created User DTO: ', createUserDto);

    const createdUser = this.userRepository.create(createUserDto);
    console.log('Created User: ', createdUser);
    return await this.userRepository.save(createdUser);
  }

  findAll() {
    return `This action returns all user`;
  }

  findOne(id: number) {
    return `This action returns a #${id} user`;
  }

  update(id: number, updateUserDto: UpdateUserDto) {
    return `This action updates a #${id} user`;
  }

  remove(id: number) {
    return `This action removes a #${id} user`;
  }
}

控制台日志与错误信息 #

控制台日志 #

Created User DTO:  {
  id: '6104ac51c617d0d6eb',
  organizationId: '4LYTspbph',
  email: 'test@test.com',
  role: 'admin',
  name: 'test name'
}

Created User:  User {
  id: '6104ac51c617d0d6eb',
  organizationId: '4LYTspbph',
  email: 'test@test.com',
  role: 'admin',
  name: 'test name'
}

数据库错误 #

query failed: INSERT INTO "user"("id", "email", "role", "name", "createdAt", "updatedAt", "organizationId") VALUES ($1, $2, $3, $4, DEFAULT, DEFAULT, DEFAULT) RETURNING "role", "createdAt", "updatedAt" -- PARAMETERS: ["6104ac51c617d0d6eb","test@test.com","admin","test name"] error: error: null value in column "organizationId" of relation "user" violates not-null constraint

问题分析与解决方案 #

问题原因 #

User实体中定义的是organization关联对象，但传入的DTO是organizationId字段。TypeORM默认不会自动将独立的organizationId字段映射到关联关系的外键，虽然日志显示createdUser带有organizationId，但TypeORM生成SQL时未正确识别该字段，导致插入时organizationId被设为DEFAULT（NULL）。

解决方案 #

方案1：调整DTO结构，传入关联对象

修改CreateUserDto，将organizationId改为包含id的organization对象：

// create-user.dto.ts
export class CreateUserDto {
  id: string;
  organization: { id: string };
  email: string;
  role: Role;
  name: string;
}

此时userRepository.create(createUserDto)会正确识别关联关系，生成对应的外键值。

方案2：在User实体中显式添加organizationId列

在User实体中直接添加与外键对应的字段，让TypeORM自动维护字段与关联对象的一致性：

// user.entity.ts
@Column({ nullable: false })
organizationId: string;

@ManyToOne(() => Organization, (organization) => organization.users, {
  nullable: false,
})
@JoinColumn({ name: "organizationId" })
organization: Organization;

这样实体同时拥有organizationId字段和organization关联对象，插入时可直接使用传入的organizationId值。

方案3：在Service中手动构建关联对象

无需修改实体和DTO，在create方法中将organizationId转换为关联对象结构：

async create(createUserDto: CreateUserDto): Promise<IUser> {
  const { organizationId, ...rest } = createUserDto;
  const createdUser = this.userRepository.create({
    ...rest,
    organization: { id: organizationId } as Organization,
  });
  return await this.userRepository.save(createdUser);
}

可选：校验组织是否存在

如果需要确保传入的organizationId对应的组织真实存在，可以注入OrganizationRepository并添加校验逻辑：

// user.service.ts
constructor(
  @InjectRepository(User)
  private userRepository: Repository<User>,
  @InjectRepository(Organization)
  private orgRepository: Repository<Organization>,
) {}

async create(createUserDto: CreateUserDto): Promise<IUser> {
  const { organizationId, ...rest } = createUserDto;
  const org = await this.orgRepository.findOneBy({ id: organizationId });
  if (!org) {
    throw new NotFoundException(`Organization ${organizationId} not found`);
  }
  const createdUser = this.userRepository.create({
    ...rest,
    organization: org,
  });
  return await this.userRepository.save(createdUser);
}

同时在UserModule的imports中添加：

TypeOrmModule.forFeature([User, Organization])

内容的提问来源于stack exchange，提问作者Alex Beyer