@Inheritance

最新推荐文章于 2021-08-13 17:54:51 发布

weixin_33912453

最新推荐文章于 2021-08-13 17:54:51 发布

阅读量57

点赞数

文章标签： python 数据库

原文链接：https://my.oschina.net/maomaolsm/blog/955241

版权

2019独角兽企业重金招聘Python工程师标准>>>

SINGLE_TABLE

@Entity
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
@Data
public class Biology {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private String origin;
}

@Entity
@Data
public class Animal extends Biology{
    private Integer foot;
    private Integer wings;
}

@Entity
@Data
public class Plant extends Biology{
    private String leafShape;
}

生成的数据库中有一列dtype来标示是哪张表的数据：

CREATE TABLE IF NOT EXISTS biology (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  dtype VARCHAR(255),
  origin VARCHAR(128),
  leaf_shape VARCHAR(128),
  foot INTEGER,
  wings INTEGER
);

JOINED

CREATE TABLE IF NOT EXISTS biology (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  origin VARCHAR(128)
);

CREATE TABLE IF NOT EXISTS animal (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  foot INTEGER,
  wings INTEGER
);

CREATE TABLE IF NOT EXISTS plant (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  leaf_shape VARCHAR(128)
);

TABLE_PER_CLASS

CREATE TABLE IF NOT EXISTS biology (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  origin VARCHAR(128)
);

CREATE TABLE IF NOT EXISTS animal (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  origin VARCHAR(128),
  foot INTEGER,
  wings INTEGER
);

CREATE TABLE IF NOT EXISTS plant (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  origin VARCHAR(128),
  leaf_shape VARCHAR(128)
);

转载于:https://my.oschina.net/maomaolsm/blog/955241