20240114

1 ACTable自动建表

https://gitee.com/sunchenbin/mybatis-enhance(opens new window) (opens new window)

https://www.yuque.com/sunchenbin/actable/ca4vsf

实体类

常用的一些类型

@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@Table(name = "accounting_boundary_info")
@TableComment("核算边界")
@TableCharset(MySqlCharsetConstant.UTF16)
@TableEngine(MySqlEngineConstant.InnoDB)

@Column(isKey = true,comment = "主键id",isAutoIncrement = true)

@Column(comment = "因子名称",length = 64)

@Column(comment = "修改人id")

@Column(type = MySqlTypeConstant.DATETIME, comment = "创建时间",defaultValue = "CURRENT_TIMESTAMP")

@Column(type = MySqlTypeConstant.DOUBLE,length = 50,decimalLength = 11,comment = "二氧化碳排放当量值")

JPA自动建表

实体类常用类型

@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@Entity
@Table(name = "carbon_activity_collect")
@org.hibernate.annotations.Table(appliesTo = "carbon_activity_collect", comment = "活动数据采集任务表")

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Comment("主键id")

@Comment("活动数据采集任务名称")
@Column(name = "name", length = 64)

@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
@CreationTimestamp
@Comment("创建时间")
@Column(name = "create_time", columnDefinition = "TIMESTAMP DEFAULT CURRENT_TIMESTAMP")

@Comment("创建人id")
@Column(name = "create_by")

@Transient