220909.sql 1.1 KB

123456789101112131415161718
  1. -- 正启之星请求记录表
  2. create table xinbada_input_record
  3. (
  4. id int auto_increment comment '主键id'
  5. primary key,
  6. signature varchar(128) not null comment '签名',
  7. action_name varchar(32) not null comment '通知类型',
  8. req_body text not null comment '请求body内容',
  9. order_uuid varchar(64) null comment '订单编号唯一',
  10. order_status int null comment '订单状态',
  11. order_no varchar(32) null comment '',
  12. customer_user_uuid varchar(64) null comment '',
  13. server_user_uuid varchar(64) null comment '',
  14. public_key varchar(2048) null comment '请求公钥',
  15. private_key varchar(2048) null comment '请求时私钥',
  16. create_time timestamp default CURRENT_TIMESTAMP not null comment '创建时间'
  17. )
  18. comment '正启之星请求记录';