0810.sql 829 B

1234567891011121314151617181920212223
  1. USE `hnqzx`;
  2. SET NAMES utf8mb4;
  3. SET FOREIGN_KEY_CHECKS = 0;
  4. -- ----------------------------
  5. -- Table structure for user_agreement_signature_record
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `user_agreement_signature_record`;
  8. CREATE TABLE `user_agreement_signature_record`
  9. (
  10. `id` INT AUTO_INCREMENT COMMENT 'id',
  11. `user_id` INT NOT NULL COMMENT '用户id',
  12. `target` INT(1) NOT NULL COMMENT '协议方',
  13. `agreement` MEDIUMTEXT DEFAULT NULL COMMENT '协议文本',
  14. `sign_time` DATETIME NOT NULL COMMENT '签署时间',
  15. `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  16. PRIMARY KEY (`id`) USING BTREE
  17. ) ENGINE = InnoDB
  18. AUTO_INCREMENT = 9
  19. DEFAULT CHARSET = utf8mb4 COMMENT ='用户协议签名';
  20. SET FOREIGN_KEY_CHECKS = 1;