Spring Boot Run 控制台显示表已创建，但该表不存在于数据库中

Question

创建spring boot表时遇到问题。

具有3个实体，预订和财产与用户实体具有多对一关系：

@Entity

public class Booking implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(generator = "uuid2")

    @GenericGenerator(name = "uuid2", strategy = "uuid2")

    @Type(type = "uuid-binary")

    private UUID booking_id;

    @Column(name = "startdate", nullable = false)

    private Time startdate;

    @Column(name = "enddate", nullable = false)
    private Time enddate;

    @ManyToOne
    @JoinColumn(name="property_id", nullable=false)
    private Property property;

    @ManyToOne
    @JoinColumn(name="tenant_id", nullable=false)
    private User user;

    @Column(name = "date_made", nullable = false)
    private Time date_made;

@Entity()

public class User implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id

    @GeneratedValue(generator = "uuid2")

    @GenericGenerator(name = "uuid2", strategy = "uuid2")

    @Type(type = "uuid-binary")

    private UUID user_id;

    @Column(name = "name", nullable = false)
    private String name;

    @Column(name = "birth_date", nullable = false)
    private String birth_date;

    @Column(name = "gender", nullable = false)
    private String gender;

    @Column(name = "age", nullable = false)
    private int age;

    @Column(name = "address", nullable = false)
    private String address;

    @Column(name = "password", nullable = false)
    private String password;

    @Column(name = "role", nullable = false)
    private int role;

    @OneToMany(mappedBy="user")
    private Set<Booking> bookingList;


    @OneToMany(mappedBy="user")
    private Set<Property> propertiesList;

 @Entity

public class Property implements Serializable {

    private static final long serialVersionUID = 1L;
    @Id

    @GeneratedValue(generator = "uuid2")

    @GenericGenerator(name = "uuid2", strategy = "uuid2")

    @Type(type = "uuid-binary")

    private UUID property_id;

    @ManyToOne

    @JoinColumn(name="user_id", nullable=false)

    private User user;

    @Column(name = "name", nullable = false)
    private String name;

    @Column(name = "location", nullable = false)
    private String location;

    @Column(name = "password", nullable = false)
    private String password;

    @Column(name = "rentCpcty", nullable = false)
    private int rentCpcty;

启动应用程序时，使用spring.jpa.hibernate.ddl-auto=create-drop，在3个实体中，只有预订属性被创建为表，尽管是运行控制台，但会显示以下消息：

Hibernate：创建用于预订的表（booking_id bytea不为空，date_make时间不为空、enddate时间不为零、startdate时间不为null、property_id bytea不空、tenant_id bytea不为空以及主键（booking_id））

Hibernate：创建表属性（property_id bytea不为空，位置varchar（255）不为空、名称varchar不为空（255）、密码varchar未为空、rent_cpcty int4未为空，user_id bytea未为空以及主键（properties_id））

Hibernate：创建表用户（user_id bytea not null，地址varchar（255）不为null，age int4不为null，

在pgAdmin中，仅显示2个表。

要检查这是否只是一个pgAdmin错误，我使用POST或GET在Postman中使用的用户地址，显示以下错误：

Servlet.service（） for servlet [dispatcherServlet] in context with path [] throw exception [Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException： can not execute statement;SQL [n/a];嵌套异常是 org.hibernate.exception.SQLGrammarException： can not execute statement] with root cause org.postgresql.util.PSQLException： ERROR： 语法错误在“user”处或附近

我的pom.xml：

<modelVersion>4.0.0</modelVersion>
<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.5.2</version>
    <relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.rentBackEnd</groupId>
<artifactId>demo</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>backEnd</name>
<description>backEnd for final project</description>
<properties>
    <java.version>11</java.version>
</properties>
<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-rest</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-hateoas</artifactId>
    </dependency>
    <dependency>
        <groupId>com.h2database</groupId>
        <artifactId>h2</artifactId>
        <scope>runtime</scope>
    </dependency>
    <dependency>
        <groupId>javax.validation</groupId>
        <artifactId>validation-api</artifactId>
        <version>2.0.0.Final</version>
    </dependency>
    <dependency>
        <groupId>org.hibernate.validator</groupId>
        <artifactId>hibernate-validator</artifactId>
        <version>6.0.2.Final</version>
    </dependency>
    <dependency>
        <groupId>org.hibernate.validator</groupId>
        <artifactId>hibernate-validator-annotation-processor</artifactId>
        <version>6.0.2.Final</version>
    </dependency>
    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-validator</artifactId>
        <version>6.0.2.Final</version>
    </dependency>
    <dependency>
        <groupId>javax.el</groupId>
        <artifactId>javax.el-api</artifactId>
        <version>3.0.0</version>
    </dependency>
    <dependency>
        <groupId>org.postgresql</groupId>
        <artifactId>postgresql</artifactId>
        <scope>runtime</scope>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
    </dependency>
    <dependency>
        <groupId>javax.validation</groupId>
        <artifactId>validation-api</artifactId>
        <version>2.0.0.Final</version>
    </dependency>
</dependencies>
    <build>
    <plugins>
        <plugin>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-maven-plugin</artifactId>
        </plugin>
    </plugins>
   </build>

Answer 1

user 是 SQL 中的关键字。使其成为用户以外的其他任何内容。

例如“用户”

但是如果你想用相同的名字创建，那么使用下面的。

@Table(name="\"user\"")