在powerdesign中使用sql语句逆向生成pdm

这里展示的是所使用的SQL语句

DROP DATABASE IF EXISTS test;
CREATE DATABASE test;
USE test;

DROP TABLE IF EXISTS user;
DROP TABLE IF EXISTS blog;
DROP TABLE IF EXISTS comment;
DROP TABLE IF EXISTS category;

CREATE TABLE user (
  id            INT AUTO_INCREMENT PRIMARY KEY,
  username      VARCHAR(200) UNIQUE,
  password      VARCHAR(200) NOT NULL
);


CREATE TABLE category (
  id          INT AUTO_INCREMENT PRIMARY KEY,
  name        VARCHAR(200) NOT NULL
);

CREATE TABLE blog (
  id          INT AUTO_INCREMENT PRIMARY KEY,
  category    INT,
  title       VARCHAR(200) NOT NULL,
  content     TEXT         NOT NULL,
  author      INT          NOT NULL,
  create_time DATETIME     NOT NULL,
  FOREIGN KEY (author) REFERENCES user (id),
  FOREIGN KEY (category) REFERENCES category (id) ON DELETE CASCADE
);

CREATE TABLE comment (
  id          INT AUTO_INCREMENT PRIMARY KEY,
  content     TEXT         NOT NULL,
  create_time DATETIME     NOT NULL,
  author      INT,
  blog        INT,
  FOREIGN KEY (author) REFERENCES user (id),
  FOREIGN KEY (blog) REFERENCES blog (id) ON DELETE CASCADE
);

File–>Reverse Engineer–>Database




成功啦