bt-2302-4月份需求.sql 701 B

123456789101112131415
  1. create table bt_refund_record
  2. (
  3. id bigint(20) not null comment '主键',
  4. order_id bigint(20) not null comment '订单ID',
  5. refund_type char(1) not null comment '退款类型: 0 -> 自动退款, 1 -> 人工退款',
  6. refund_reason varchar(200) comment '退款原因',
  7. refund_amount decimal(20,2) not null comment '退款金额',
  8. create_time datetime not null comment '创建时间',
  9. create_user bigint(20) not null comment '创建人',
  10. update_time datetime not null comment '修改时间',
  11. update_user bigint(20) not null comment '修改人',
  12. primary key (id)
  13. );
  14. alter table bt_refund_record comment '退款记录';