聊天的DB模式？

这是使用MySQL Workbench的开始

ERD的PNG出口

和创建脚本

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';CREATE SCHEMA IF NOT EXISTS `chats` DEFAULT CHARACTER SET utf8 COLLATE default collation ;-- ------------------------------------------------------- Table `chats`.`chat`-- -----------------------------------------------------CREATE  TABLE IF NOT EXISTS `chats`.`chat` (  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,  PRIMARY KEY (`id`) )ENGINE = InnoDB;-- ------------------------------------------------------- Table `chats`.`chat_user`-- -----------------------------------------------------CREATE  TABLE IF NOT EXISTS `chats`.`chat_user` (  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,  `handle` VARCHAr(45) NOT NULL ,  PRIMARY KEY (`id`) )ENGINE = InnoDB;-- ------------------------------------------------------- Table `chats`.`chat_line`-- -----------------------------------------------------CREATE  TABLE IF NOT EXISTS `chats`.`chat_line` (  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,  `chat_id` INT UNSIGNED NOT NULL ,  `user_id` INT UNSIGNED NOT NULL ,  `line_text` TEXT NOT NULL ,  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,  PRIMARY KEY (`id`) ,  INDEX `fk_chat_line_chat` (`chat_id` ASC) ,  INDEX `fk_chat_line_chat_user1` (`user_id` ASC) ,  ConSTRAINT `fk_chat_line_chat`    FOREIGN KEY (`chat_id` )    REFERENCES `chats`.`chat` (`id` )    ON DELETE NO ACTION    ON UPDATE NO ACTION,  ConSTRAINT `fk_chat_line_chat_user1`    FOREIGN KEY (`user_id` )    REFERENCES `chats`.`chat_user` (`id` )    ON DELETE NO ACTION    ON UPDATE NO ACTION)ENGINE = InnoDB;SET SQL_MODE=@OLD_SQL_MODE;SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

也欢迎您从我的保管箱下载MWB文件。