建表规范

 

 

use database_name;
DROP TABLE IF EXISTS `table_name`;
CREATE TABLE `table_name` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `ad_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '广告id',
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户量',
  `use_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '广告使用量',
  `valid_time` datetime NOT NULL COMMENT '广告有效使用时间',
  PRIMARY KEY (`id`),
  KEY `idx_ad_user` (`ad_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='广告记录表';