假设我有一张如下所示的桌子:-

Employee

employee Id -- Primary Key
manager Id -- Foreign Key Relationship with employee id as manager is also an employee
subordinates -- List<Employee Ids> another foreign key relationship to the same table.

我用的是spring，所以一个极简课程应该是如下所示的:-

@Data
@Entity(name = "employee")
@Table(name = "employee")
public class Employee {

    @Id
    @GeneratedValue(generator="system-uuid")
    @GenericGenerator(name="system-uuid", strategy = "uuid")
    @Column(name = "employee_id", columnDefinition = "VARCHAR(255)", unique = true, nullable = false)
    private String employeeId;

    @OneToMany(mappedBy = "employee", fetch = FetchType.LAZY,
            cascade = CascadeType.ALL)
    @JsonManagedReference
    private Set<Employee> subordinates;

    @OneToOne(fetch = FetchType.LAZY, optional = false)
    @JoinColumn(name = "employee_id", nullable = false)
    @JsonBackReference
    private Employee manager;

}
}

当我编译和运行时，上面没有给我任何问题。

所以我的问题基本上是，让一个表与自身或另一个表具有多个外键关系是否可以，或者如果我遵循这个模式，我以后会陷入一些麻烦。

谢谢，