qimall/addons/Dianqian/install.sql

CREATE TABLE `qimall_dianqian_apply` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) NOT NULL DEFAULT '0' COMMENT '商城ID',
  `user_id` int(10) DEFAULT '0' COMMENT '用户ID',
  `name` varchar(100) DEFAULT '' COMMENT '签约人姓名',
  `mobile` bigint(11) DEFAULT '0' COMMENT '签约人手机号',
  `reason` text COMMENT '被拒理由',
  `remark` text COMMENT '备注',
  `sign_status` tinyint(2) DEFAULT '1' COMMENT '签约状态[-1:申请被拒,1=签约中,2=签约成功]',
  `status` tinyint(2) DEFAULT '1' COMMENT '状态',
  `created_at` int(10) NOT NULL DEFAULT '0',
  `updated_at` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mall_id` (`mall_id`) USING BTREE,
  KEY `user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='点签申请表';