mysql - Answertouma/jade-meng GitHub Wiki

房间信息表
CREATE TABLE `room` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `use_status` int(11) NOT NULL DEFAULT '1' COMMENT '使用状态,1: 未使用,2:已占用,3:已开始',
  `mem1` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '成员1',
  `mem2` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '成员2',
  `mem3` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '成员3',
  `mem4` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '成员4',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '状态：0:失效, 1:有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

对局记录表
CREATE TABLE `liushui` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `room_id` int(11) NOT NULL COMMENT '房间ID',
  `mem_id` varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '赌徒ID',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '状态，0:无效，1:有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

赌徒成员表
CREATE TABLE `member` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `mem_id` varchar(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '赌徒ID',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '状态：0:无效，1:有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mem_id` (`mem_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci