java将联接表引用到视图
我有一个实体MorningMinutesNote,它与MorningMinutesNoteType有@ManyToMany关系,使用联接表MorningMinutes\u note\u item\u type
@Entity
@Table(name = "morning_minutes_note", schema = "public")
public class MorningMinutesNote {
private List<MorningMinutesNoteType> itemTypes = new ArrayList<MorningMinutesNoteType>();
@ManyToMany
@JoinTable(name="morning_minutes_note_item_type",
joinColumns=@JoinColumn(name="morning_minutes_note_id",updatable=false,insertable=false),
inverseJoinColumns=@JoinColumn(name="item_type_id",updatable=false,insertable=false))
public List<MorningMinutesNoteType> getItemTypes() {
return itemTypes;
}
CREATE TABLE morning_minutes_note_item_type(
morning_minutes_note_item_type_id BIGINT PRIMARY KEY DEFAULT NEXTVAL('morning_minutes_note_item_type_id_seq'),
morning_minutes_note_id BIGINT NOT NULL,
item_type_id BIGINT NOT NULL
);
我创建了一个视图表view\u morning\u minutes\u note,它使用morning\u minutes\u note作为主表。我如何引用MorningMinutesNoteType列表 也可以添加到视图表,以便我也可以从ViewMorningMinutesNote获取列表。我不知道这是否可行,但我已经尝试添加MorningMinutesNote的精确注释 查看晨曦时刻笔记,但它什么也拿不到
@Entity
@org.hibernate.annotations.Entity(selectBeforeUpdate = false,dynamicInsert = true, dynamicUpdate = true)
@Table(name = "view_morning_minutes_note", schema = "public")
public class ViewMorningMinutesNote{
private List<MorningMinutesNoteType> itemTypes = new ArrayList<>();
# 1 楼答案
如果需要直接访问
JoinTable
,可以使用FluentJPA功能公开join table for queries