这是使用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文件。
