微信小程序个人名片-我要反馈

数据库

wiki
SQL

CREATE TABLE `tb_pc_feedback` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`pc_id` int(11) unsigned NOT NULL DEFAULT 0 COMMENT "个人名片ID",
`openid` VARCHAR(30) NOT NULL DEFAULT '' COMMENT "小程序openid",
`phone` CHAR(11) NOT NULL DEFAULT '' COMMENT "个人名片电话",
`company_name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT "公司名称",
`company_name_digest` VARCHAR(32) NOT NULL DEFAULT '',
`content` VARCHAR(500) NOT NULL DEFAULT '反馈内容',
`status` TINYINT(4) unsigned NOT NULL DEFAULT 1 COMMENT "状态，1为待处理",
`created_at` DATETIME NOT NULL COMMENT "创建时间",
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT "更新时间",
PRIMARY KEY (`id`),
KEY `idx_phone`(`phone`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT="个人名片小程序反馈表"