turns-00082.parquet:32083
5218963e56c5142b0f6ae874degenerate_repetitionAbsentFinal dense release
USER
CREATE TABLE long_term_memory (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
word_id INT NOT NULL,
review_count INT DEFAULT 0, -- 总复习次数
interval_days INT DEFAULT 0, -- 下次复习间隔（单位：天）
next_review_date DATETIME NOT NULL, -- 下一次复习目标日期（精确时间）
last_review_date DATETIME NOT NULL, -- 上一次复习日期
longmemory_score INT DEFAULT NULL,
longmemory_seen INT DEFAULT -1,
pass_count INT DEFAULT 0, -- 新增字段，复习通过计数
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES user(id),
FOREIGN KEY (word_id) REFERENCES words(id),
UNIQUE KEY uniq_user_word (user_id, word_id)
);public class LongTermMemory {
}帮我生成entity类
ASSISTANT
根据你提供的`long_term_memory`表结构，下面是完整的Java实体类`LongTermMemory`，包含所有字段，使用了常用的Java类型映射，包含`getter`和`setter`方法（你可以用IDE自动生成或用Lombok简化）。示例如下：
```java
package com.example.springboot.entity;
import java.time.LocalDateTime;
public class LongTermMemory {
private Integer id;
private Integer userId;
private Integer wordId;
private Integer reviewCount; // 总复习次数
private Integer intervalDays; // 下次复习间隔（单位：天）
private LocalDateTime nextReviewDate; // 下一次复习目标日期
private LocalDateTime lastReviewDate; // 上一次复习日期
private Integer longmemoryScore;
private Integer longmemorySeen;
private Integer passCount; // 复习通过计数
private LocalDateTime createdAt;
private LocalDateTime updatedAt;
// 空构造函数
public LongTermMemory() {
}
// get/set 方法
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public Integer getUserId() {
return userId;
}
public void setUserId(Integer userId) {
this.userId = userId;
}
public Integer getWordId() {
return wordId;
}
public void setWordId(Integer wordId) {
this.wordId = wordId;
}
public Integer getReviewCount() {
return reviewCount;
}
public void setReviewCount(Integer reviewCount) {
this.reviewCount = reviewCount;
}
public Integer getIntervalDays() {
return intervalDays;
}
public void setIntervalDays(Integer intervalDays) {
this.intervalDays = intervalDays;
}
public LocalDateTime getNextReviewDate() {
return nextReviewDate;
}
public void setNextReviewDate(LocalDateTime nextReviewDate) {
this.nextReviewDate = nextReviewDate;
}
public LocalDateTime getLastReviewDate() {
return lastReviewDate;
}
public void setLastReviewDate(LocalDateTime lastReviewDate) {
this.lastReviewDate = lastReviewDate;
}
public Integer getLongmemoryScore() {
return longmemoryScore;
}
public void setLongmemoryScore(Integer longmemoryScore) {
this.longmemoryScore = longmemoryScore;
}
public Integer getLongmemorySeen() {
return longmemorySeen;
}
public void setLongmemorySeen(Integer longmemorySeen) {
this.longmemorySeen = longmemorySeen;
}
public Integer getPassCount() {
return passCount;
}
public void setPassCount(Integer passCount) {
this.passCount = passCount;
}
public LocalDateTime getCreatedAt() {
return createdAt;
}
public void setCreatedAt(LocalDateTime createdAt) {
this.createdAt = createdAt;
}
public LocalDateTime getUpdatedAt() {
return updatedAt;
}
public void setUpdatedAt(LocalDateTime updatedAt) {
this.updatedAt = updatedAt;
}
}
```
---
### 说明
- 使用`LocalDateTime`替换了数据库的DATETIME字段，具备时间精度。
- 所有字段类型按你DDL映射：
- INT → Integer
- DATETIME → LocalDateTime
- TIMESTAMP → LocalDateTime（如果有时区需求，建议用`OffsetDateTime`）
- 如果使用Lombok，可以减少代码量：
```java
import lombok.Data;
import java.time.LocalDateTime;
@Data
public class LongTermMemory {
private Integer id;
private Integer userId;
private Integer wordId;
private Integer reviewCount;
private Integer intervalDays;
private LocalDateTime nextReviewDate;
private LocalDateTime lastReviewDate;
private Integer longmemoryScore;
private Integer longmemorySeen;
private Integer passCount;
private LocalDateTime createdAt;
private LocalDateTime updatedAt;
}
```
---
如果你需要，我也可以帮你写对应的Mapper XML和MyBatis注解。