1. 创建实体对象
Task.java
@SuperBuilder
@Getter
@Setter
@Table(value = "t_task", comment = "任务表")
@NoArgsConstructor
public class Task extends BasePureEntity {
@Column(nullable = true, comment = "任务名称")
private String taskName;
@Column(comment = "完成时间")
private LocalDateTime completeTime;
private Integer costHours;
private Boolean complete;
private Long assignUserId;
@Column(comment = "用户状态")
private UserStatusEnum userStatus;
}
2. 执行代码
@SpringBootTest
public class TableGeneratorTest {
@Autowired
private TableGenerator tableGenerator;
@Test
public void createTable() {
tableGenerator.createTable(Task.class);
}
}
生成sql,并执行
create table t_task
(
id bigint not null comment '主键'
primary key,
task_name varchar(32) not null comment '任务名称',
complete_time datetime null comment '完成时间',
cost_hours int null,
complete bit null,
assign_user_id bigint null,
user_status varchar(16) null comment '用户状态',
created_by bigint null,
created_at datetime null,
updated_by bigint null,
updated_at datetime null,
is_deleted bit null
)
comment '任务表';