注册

mysql8-dm8-jpa

DM_281173 2024/12/30 322 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:帮忙改下对应到达梦数据库该怎么写

@Entity(name = "third_user_info")
@Data
@NoArgsConstructor
@AllArgsConstructor
@Table(name = "third_user_info")
public class ThirdUserInfoDO {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id", columnDefinition = "bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID'")
private Long id;

@Column(name = "emp_id", columnDefinition = "varchar(60) default null comment '员工表ID'")
private String empId;

@Column(name = "emp_status", columnDefinition = "int(3) default null comment '0 未同步 1 新增 2 调岗 3 离岗 4 删除'")
private Integer empStatus;

/**
* 手机号
*/
@Column(name = "mobile", columnDefinition = "varchar(12) default NULL comment '手机号'")
private String mobile;

/**
* 身份证号
*/
@Column(name = "id_no", columnDefinition = "varchar(128) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '身份证号'")
private String idNo;

/**
* 原数据
*/
@Column(name = "original_data", columnDefinition = "text default null comment '原数据'")
private String originalData;

/**
* 创建时间
*/
@Column(name = "created_time", columnDefinition = "datetime NOT NULL DEFAULT CURRENT_TIMESTAMP")
private Date createdTime;

/**
*
* 修改时间
*/
@Column(name = "updated_time", columnDefinition = "datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP")
private Date updatedTime;

}

回答 0
暂无回答
扫一扫
联系客服