如何为新的JPA @ElementCollection编写SQL DDL查询

Question

我在一个域类(JPA)中做了一个代码更改。我给实体添加了一个ElementCollection:

@ElementCollection(targetClass = String.class)
@CollectionTable(name = "T_NETWORK_STATE", joinColumns = {@JoinColumn(name = "NETWORK_ID")})
@Column(name = "STATE")
private Set<String> states = new HashSet<>();

现在我想为这个变化写一个flyway更新数据库脚本。我需要表T_NETWORK_STATE的SQL DDL。

我是新写sql查询。任何帮助将不胜感激!

Answer 1

CREATE TABLE T_NETWORK_STATE (
  NETWORK_ID INT,
  STATE VARCHAR(100),
  UNIQUE INDEX (NETWORK_ID, STATE),
  FOREIGN KEY (NETWORK_ID) REFERENCES NETWORK(NETWORK_ID)
);