OrderItem 1->* suppliers (some one item can have many supplier prices)
Suppliers 1->1 supplier
Suppliers 1->1 itemPrices
OrderItem {orderId, partId, quantity, suppliers}
Suppliers {orderId, partId, Supplier}
我的问题是。。。
将Suppliers实体嵌入OrderItem实体的最佳方式是什么?请忘记Suppliers与supplier和itemprice之间的关系这已经使用联接列完成了。
@JoinTable(name = "Suppliers", joinColumns = { @JoinColumn(name = "orderid", referencedColumnName = "orderid") }, inverseJoinColumns = { @JoinColumn(name = "partid", referencedColumnName = "partid") })
或:
@OneToMany(mappedBy="orderid, partid")
private List<Suppliers> suppliers;