首先我们先了解一下什么是PDM
物理数据模型（PDM）是数据库设计和管理过程中的重要组成部分，具有以下好处：
- 可视化数据库结构： PDM提供了一个直观的方式来可视化数据库的结构，包括表、列、索引、关系等。这使得数据库设计更容易理解和沟通。
- 数据完整性： 通过PDM，您可以定义表之间的关系、主键、外键等约束，确保数据库中的数据完整性。这有助于避免数据不一致和错误。
- 自动化代码生成： PDM工具通常具有生成SQL脚本的功能，可以根据模型自动生成数据库创建脚本。这加速了数据库部署和维护的过程。
- 版本控制： PDM文件是可版本控制的，因此您可以跟踪数据库模型的演变，并轻松恢复到以前的版本，以便进行数据库迁移和回滚。
- 团队协作： 多人团队可以共享和协作在PDM文件上工作，以确保数据库设计的一致性和合作。
- 性能优化： 通过可视化数据库结构，您可以更容易地识别性能瓶颈和优化机会，以提高数据库的查询性能和响应时间。
- 文档和注释： PDM工具通常支持在模型中添加文档和注释，帮助数据库开发人员和管理员理解数据库对象的用途和规范。
- 跨平台兼容性： PDM工具通常支持多种数据库平台，因此您可以使用相同的模型设计不同类型的数据库，而不必从头开始。
- 安全性和合规性： PDM工具允许您定义安全性策略和合规性要求，以确保数据库的数据得到保护，并符合法规要求。
- 数据库重构： 如果需要对数据库进行结构上的更改，PDM工具可以帮助您计划和管理数据库重构，以确保平滑的过渡。
总之，PDM在数据库设计、开发和管理过程中起着关键作用，帮助团队更有效地工作，确保数据库的可靠性、性能和可维护性。通过可视化和自动化功能，它减少了人为错误的风险，并加速了数据库项目的交付。
SQL语句通常不直接用于生成PDM（Physical Data Model）文件。PDM文件是特定建模工具（如PowerDesigner、ERWin、Oracle SQL Developer Data Modeler等）使用的文件格式，用于可视化和管理数据库模型的物理结构。
要将SQL语句转换为PDM文件，通常需要进行以下步骤：
- 创建数据库模型： 打开您选择的数据库建模工具，然后创建一个新的数据库模型项目。
- 导入SQL脚本： 在工具中，通常有一个选项可以导入SQL脚本。导入您的SQL脚本文件以创建数据库对象，包括表、列、索引等。
- 自定义模型： 一旦导入了SQL脚本，您可以进一步自定义数据库模型。这包括指定表之间的关系、添加注释、定义主键和外键等。
- 生成PDM文件： 在模型工具中，您可以选择导出模型为PDM文件的选项。通常，这个选项可以在文件菜单或导出菜单中找到。选择此选项，然后为PDM文件指定名称和保存位置。
- 保存PDM文件： 完成导出设置后，保存PDM文件。该文件将包含了从SQL脚本生成的数据库模型的物理结构信息。
这里我使用的软件是PowerDesigner16
下面请看我的步骤：
第一步：File > Reverse Engineer > Database
第二步：
设置自己需要的配置参数，我使用的是Mysql数据库
第三步：
点击确定跳到下一步;
点击×清除之前使用的文件，如果没有可不点
清除完×是浅色的
第四步:添加sql文件（不是数据库）
点击这个：
选择你的sql文件：
注意：读取sql语句是按照字符读取
这个是加了中文的
-- 表结构：t_exam_paper (考试试卷表) DROP TABLE IF EXISTS `t_exam_paper`; CREATE TABLE `t_exam_paper` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '试卷ID', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '试卷名称', `subject_id` int NULL DEFAULT NULL COMMENT '学科ID', `paper_type` int NULL DEFAULT NULL COMMENT '试卷类型', `grade_level` int NULL DEFAULT NULL COMMENT '年级', `score` int NULL DEFAULT NULL COMMENT '总分', `question_count` int NULL DEFAULT NULL COMMENT '试题数量', `suggest_time` int NULL DEFAULT NULL COMMENT '建议完成时间', `limit_start_time` datetime NULL DEFAULT NULL COMMENT '限制开始时间', `limit_end_time` datetime NULL DEFAULT NULL COMMENT '限制结束时间', `frame_text_content_id` int NULL DEFAULT NULL COMMENT '正文内容ID', `create_user` int NULL DEFAULT NULL COMMENT '创建用户', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `deleted` bit(1) NULL DEFAULT NULL COMMENT '删除标志', `task_exam_id` int NULL DEFAULT NULL COMMENT '任务考试ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;讯享网
讯享网-- 表结构：t_exam_paper_answer (试卷答案表) DROP TABLE IF EXISTS `t_exam_paper_answer`; CREATE TABLE `t_exam_paper_answer` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '答案ID', `exam_paper_id` int NULL DEFAULT NULL COMMENT '试卷ID', `paper_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '试卷名称', `paper_type` int NULL DEFAULT NULL COMMENT '试卷类型', `subject_id` int NULL DEFAULT NULL COMMENT '学科ID', `system_score` int NULL DEFAULT NULL COMMENT '系统得分', `user_score` int NULL DEFAULT NULL COMMENT '用户得分', `paper_score` int NULL DEFAULT NULL COMMENT '试卷得分', `question_correct` int NULL DEFAULT NULL COMMENT '正确题数', `question_count` int NULL DEFAULT NULL COMMENT '试题数量', `do_time` int NULL DEFAULT NULL COMMENT '完成时间', `status` int NULL DEFAULT NULL COMMENT '状态', `create_user` int NULL DEFAULT NULL COMMENT '创建用户', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `task_exam_id` int NULL DEFAULT NULL COMMENT '任务考试ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;
-- 表结构：t_exam_paper_question_customer_answer (试卷试题客户答案表) DROP TABLE IF EXISTS `t_exam_paper_question_customer_answer`; CREATE TABLE `t_exam_paper_question_customer_answer` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '答案ID', `question_id` int NULL DEFAULT NULL COMMENT '试题ID', `exam_paper_id` int NULL DEFAULT NULL COMMENT '试卷ID', `exam_paper_answer_id` int NULL DEFAULT NULL COMMENT '试卷答案ID', `question_type` int NULL DEFAULT NULL COMMENT '试题类型', `subject_id` int NULL DEFAULT NULL COMMENT '学科ID', `customer_score` int NULL DEFAULT NULL COMMENT '客户得分', `question_score` int NULL DEFAULT NULL COMMENT '试题得分', `question_text_content_id` int NULL DEFAULT NULL COMMENT '试题文本内容ID', `answer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '答案', `text_content_id` int NULL DEFAULT NULL COMMENT '文本内容ID', `do_right` bit(1) NULL DEFAULT NULL COMMENT '是否正确', `create_user` int NULL DEFAULT NULL COMMENT '创建用户', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `item_order` int NULL DEFAULT NULL COMMENT '项次', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;讯享网-- 表结构：t_message (消息表) DROP TABLE IF EXISTS `t_message`; CREATE TABLE `t_message` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '消息ID', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题', `content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `send_user_id` int NULL DEFAULT NULL COMMENT '发送用户ID', `send_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发送用户名', `send_real_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发送用户真实姓名', `receive_user_count` int NULL DEFAULT NULL COMMENT '接收用户数量', `read_count` int NULL DEFAULT NULL COMMENT '阅读数量', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;
-- 表结构：t_message_user (消息用户关联表) DROP TABLE IF EXISTS `t_message_user`; CREATE TABLE `t_message_user` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '关联ID', `message_id` int NULL DEFAULT NULL COMMENT '消息ID', `receive_user_id` int NULL DEFAULT NULL COMMENT '接收用户ID', `receive_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接收用户名', `receive_real_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接收用户真实姓名', `readed` bit(1) NULL DEFAULT NULL COMMENT '是否已阅读', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `read_time` datetime NULL DEFAULT NULL COMMENT '阅读时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;讯享网 -- 表结构：t_question (试题表) DROP TABLE IF EXISTS `t_question`; CREATE TABLE `t_question` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '试题ID', `question_type` int NULL DEFAULT NULL COMMENT '试题类型', `subject_id` int NULL DEFAULT NULL COMMENT '学科ID', `score` int NULL DEFAULT NULL COMMENT '分数', `grade_level` int NULL DEFAULT NULL COMMENT '年级', `difficult` int NULL DEFAULT NULL COMMENT '难度', `correct` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '答案', `info_text_content_id` int NULL DEFAULT NULL COMMENT '信息文本内容ID', `create_user` int NULL DEFAULT NULL COMMENT '创建用户', `status` int NULL DEFAULT NULL COMMENT '状态', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `deleted` bit(1) NULL DEFAULT NULL COMMENT '删除标志', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;
-- 表结构：t_subject (学科表) DROP TABLE IF EXISTS `t_subject`; CREATE TABLE `t_subject` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '学科ID', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学科名称', `level` int NULL DEFAULT NULL COMMENT '级别', `level_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '级别名称', `item_order` int NULL DEFAULT NULL COMMENT '项次', `deleted` bit(1) NULL DEFAULT NULL COMMENT '删除标志', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;讯享网-- 表结构：t_task_exam (任务考试表) DROP TABLE IF EXISTS `t_task_exam`; CREATE TABLE `t_task_exam` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '任务考试ID', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题', `grade_level` int NULL DEFAULT NULL COMMENT '年级', `frame_text_content_id` int NULL DEFAULT NULL COMMENT '框架文本内容ID', `create_user` int NULL DEFAULT NULL COMMENT '创建用户', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `deleted` bit(1) NULL DEFAULT NULL COMMENT '删除标志', `create_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建用户名', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;
-- 表结构：t_task_exam_customer_answer (任务考试客户答案表) DROP TABLE IF EXISTS `t_task_exam_customer_answer`; CREATE TABLE `t_task_exam_customer_answer` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '客户答案ID', `task_exam_id` int NULL DEFAULT NULL COMMENT '任务考试ID', `create_user` int NULL DEFAULT NULL COMMENT '创建用户', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `text_content_id` int NULL DEFAULT NULL COMMENT '文本内容ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;讯享网-- 表结构：t_text_content (文本内容表) DROP TABLE IF EXISTS `t_text_content`; CREATE TABLE `t_text_content` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '文本内容ID', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;
-- 表结构：t_user (用户表) DROP TABLE IF EXISTS `t_user`; CREATE TABLE `t_user` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '用户ID', `user_uuid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户UUID', `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码', `real_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真实姓名', `age` int NULL DEFAULT NULL COMMENT '年龄', `sex` int NULL DEFAULT NULL COMMENT '性别', `birth_day` datetime NULL DEFAULT NULL COMMENT '出生日期', `user_level` int NULL DEFAULT NULL COMMENT '用户级别', `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电话号码', `role` int NULL DEFAULT NULL COMMENT '角色', `status` int NULL DEFAULT NULL COMMENT '状态', `image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像路径', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `modify_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `last_active_time` datetime NULL DEFAULT NULL COMMENT '最后活动时间', `deleted` bit(1) NULL DEFAULT NULL COMMENT '删除标志', `wx_open_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信OpenID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;讯享网-- 添加记录到表：t_user (用户表) INSERT INTO `t_user` VALUES (1, 'd2d29da2-dcb3-4013-b874-f47', 'student', 'D1AGFL+Gx37t0NPG4d6biYP5Z31cNbwhK5w1lUeiHB2zagqbk8efYfSjYoh1Z/j1dkiRjHU+b0EpwzCh8IGsksJjzD65ci5LsnodQVf4Uj6D3pwoscXGqmkjjpzvSJbx42swwNTA+QoDU8YLo7JhtbUK2X0qCjFGpd+8eJ5BGvk=', '学生', 18, 1, '2019-09-01 16:00:00', 1, '', 1, 1, 'https://www.mindskip.net:9008/image/ba607a75-83ba-4530-8e23-660b72dc4953/头像.jpg', '2019-09-07 18:55:02', '2020-02-04 08:26:54', NULL, b'0', NULL); INSERT INTO `t_user` VALUES (2, '52045f5f-a13f-4ccc-93dd-f7ee8270ad4c', 'admin', 'D1AGFL+Gx37t0NPG4d6biYP5Z31cNbwhK5w1lUeiHB2zagqbk8efYfSjYoh1Z/j1dkiRjHU+b0EpwzCh8IGsksJjzD65ci5LsnodQVf4Uj6D3pwoscXGqmkjjpzvSJbx42swwNTA+QoDU8YLo7JhtbUK2X0qCjFGpd+8eJ5BGvk=', '管理员', 30, 1, '2019-09-07 18:56:07', NULL, NULL, 3, 1, NULL, '2019-09-07 18:56:21', NULL, NULL, b'0', NULL); -- 表结构：t_user_event_log (用户事件日志表) DROP TABLE IF EXISTS `t_user_event_log`; CREATE TABLE `t_user_event_log` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '事件日志ID', `user_id` int NULL DEFAULT NULL COMMENT '用户ID', `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名', `real_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真实姓名', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;
-- 表结构：t_user_token (用户令牌表) DROP TABLE IF EXISTS `t_user_token`; CREATE TABLE `t_user_token` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '令牌ID', `token` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '令牌', `user_id` int NULL DEFAULT NULL COMMENT '用户ID', `wx_open_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信OpenID', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间', `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT; 讯享网 -- 恢复外键检查 SET FOREIGN_KEY_CHECKS = 1;
这个是不加中文的：
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_exam_paper -- ---------------------------- DROP TABLE IF EXISTS `t_exam_paper`; CREATE TABLE `t_exam_paper` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `subject_id` int NULL DEFAULT NULL, `paper_type` int NULL DEFAULT NULL, `grade_level` int NULL DEFAULT NULL, `score` int NULL DEFAULT NULL, `question_count` int NULL DEFAULT NULL, `suggest_time` int NULL DEFAULT NULL, `limit_start_time` datetime NULL DEFAULT NULL, `limit_end_time` datetime NULL DEFAULT NULL, `frame_text_content_id` int NULL DEFAULT NULL, `create_user` int NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `deleted` bit(1) NULL DEFAULT NULL, `task_exam_id` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of t_exam_paper -- ---------------------------- -- ---------------------------- -- Table structure for t_exam_paper_answer -- ---------------------------- DROP TABLE IF EXISTS `t_exam_paper_answer`; CREATE TABLE `t_exam_paper_answer` ( `id` int NOT NULL AUTO_INCREMENT, `exam_paper_id` int NULL DEFAULT NULL, `paper_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `paper_type` int NULL DEFAULT NULL, `subject_id` int NULL DEFAULT NULL, `system_score` int NULL DEFAULT NULL, `user_score` int NULL DEFAULT NULL, `paper_score` int NULL DEFAULT NULL, `question_correct` int NULL DEFAULT NULL, `question_count` int NULL DEFAULT NULL, `do_time` int NULL DEFAULT NULL, `status` int NULL DEFAULT NULL, `create_user` int NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `task_exam_id` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of t_exam_paper_answer -- ---------------------------- -- ---------------------------- -- Table structure for t_exam_paper_question_customer_answer -- ---------------------------- DROP TABLE IF EXISTS `t_exam_paper_question_customer_answer`; CREATE TABLE `t_exam_paper_question_customer_answer` ( `id` int NOT NULL AUTO_INCREMENT, `question_id` int NULL DEFAULT NULL, `exam_paper_id` int NULL DEFAULT NULL, `exam_paper_answer_id` int NULL DEFAULT NULL, `question_type` int NULL DEFAULT NULL, `subject_id` int NULL DEFAULT NULL, `customer_score` int NULL DEFAULT NULL, `question_score` int NULL DEFAULT NULL, `question_text_content_id` int NULL DEFAULT NULL, `answer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `text_content_id` int NULL DEFAULT NULL, `do_right` bit(1) NULL DEFAULT NULL, `create_user` int NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `item_order` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of t_exam_paper_question_customer_answer -- ---------------------------- -- ---------------------------- -- Table structure for t_message -- ---------------------------- DROP TABLE IF EXISTS `t_message`; CREATE TABLE `t_message` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `send_user_id` int NULL DEFAULT NULL, `send_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `send_real_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `receive_user_count` int NULL DEFAULT NULL, `read_count` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of t_message -- ---------------------------- -- ---------------------------- -- Table structure for t_message_user -- ---------------------------- DROP TABLE IF EXISTS `t_message_user`; CREATE TABLE `t_message_user` ( `id` int NOT NULL AUTO_INCREMENT, `message_id` int NULL DEFAULT NULL, `receive_user_id` int NULL DEFAULT NULL, `receive_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `receive_real_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `readed` bit(1) NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `read_time` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of t_message_user -- ---------------------------- -- ---------------------------- -- Table structure for t_question -- ---------------------------- DROP TABLE IF EXISTS `t_question`; CREATE TABLE `t_question` ( `id` int NOT NULL AUTO_INCREMENT, `question_type` int NULL DEFAULT NULL, `subject_id` int NULL DEFAULT NULL, `score` int NULL DEFAULT NULL, `grade_level` int NULL DEFAULT NULL, `difficult` int NULL DEFAULT NULL, `correct` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `info_text_content_id` int NULL DEFAULT NULL, `create_user` int NULL DEFAULT NULL, `status` int NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `deleted` bit(1) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of t_question -- ---------------------------- -- ---------------------------- -- Table structure for t_subject -- ---------------------------- DROP TABLE IF EXISTS `t_subject`; CREATE TABLE `t_subject` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `level` int NULL DEFAULT NULL, `level_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `item_order` int NULL DEFAULT NULL, `deleted` bit(1) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of t_subject -- ---------------------------- -- ---------------------------- -- Table structure for t_task_exam -- ---------------------------- DROP TABLE IF EXISTS `t_task_exam`; CREATE TABLE `t_task_exam` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `grade_level` int NULL DEFAULT NULL, `frame_text_content_id` int NULL DEFAULT NULL, `create_user` int NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `deleted` bit(1) NULL DEFAULT NULL, `create_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of t_task_exam -- ---------------------------- -- ---------------------------- -- Table structure for t_task_exam_customer_answer -- ---------------------------- DROP TABLE IF EXISTS `t_task_exam_customer_answer`; CREATE TABLE `t_task_exam_customer_answer` ( `id` int NOT NULL AUTO_INCREMENT, `task_exam_id` int NULL DEFAULT NULL, `create_user` int NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `text_content_id` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of t_task_exam_customer_answer -- ---------------------------- -- ---------------------------- -- Table structure for t_text_content -- ---------------------------- DROP TABLE IF EXISTS `t_text_content`; CREATE TABLE `t_text_content` ( `id` int NOT NULL AUTO_INCREMENT, `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `create_time` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of t_text_content -- ---------------------------- -- ---------------------------- -- Table structure for t_user -- ---------------------------- DROP TABLE IF EXISTS `t_user`; CREATE TABLE `t_user` ( `id` int NOT NULL AUTO_INCREMENT, `user_uuid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `real_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `age` int NULL DEFAULT NULL, `sex` int NULL DEFAULT NULL, `birth_day` datetime NULL DEFAULT NULL, `user_level` int NULL DEFAULT NULL, `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `role` int NULL DEFAULT NULL, `status` int NULL DEFAULT NULL, `image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `modify_time` datetime NULL DEFAULT NULL, `last_active_time` datetime NULL DEFAULT NULL, `deleted` bit(1) NULL DEFAULT NULL, `wx_open_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of t_user -- ---------------------------- INSERT INTO `t_user` VALUES (1, 'd2d29da2-dcb3-4013-b874-f47', 'student', 'D1AGFL+Gx37t0NPG4d6biYP5Z31cNbwhK5w1lUeiHB2zagqbk8efYfSjYoh1Z/j1dkiRjHU+b0EpwzCh8IGsksJjzD65ci5LsnodQVf4Uj6D3pwoscXGqmkjjpzvSJbx42swwNTA+QoDU8YLo7JhtbUK2X0qCjFGpd+8eJ5BGvk=', '学生', 18, 1, '2019-09-01 16:00:00', 1, '', 1, 1, 'https://www.mindskip.net:9008/image/ba607a75-83ba-4530-8e23-660b72dc4953/头像.jpg', '2019-09-07 18:55:02', '2020-02-04 08:26:54', NULL, b'0', NULL); INSERT INTO `t_user` VALUES (2, '52045f5f-a13f-4ccc-93dd-f7ee8270ad4c', 'admin', 'D1AGFL+Gx37t0NPG4d6biYP5Z31cNbwhK5w1lUeiHB2zagqbk8efYfSjYoh1Z/j1dkiRjHU+b0EpwzCh8IGsksJjzD65ci5LsnodQVf4Uj6D3pwoscXGqmkjjpzvSJbx42swwNTA+QoDU8YLo7JhtbUK2X0qCjFGpd+8eJ5BGvk=', '管理员', 30, 1, '2019-09-07 18:56:07', NULL, NULL, 3, 1, NULL, '2019-09-07 18:56:21', NULL, NULL, b'0', NULL); -- ---------------------------- -- Table structure for t_user_event_log -- ---------------------------- DROP TABLE IF EXISTS `t_user_event_log`; CREATE TABLE `t_user_event_log` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NULL DEFAULT NULL, `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `real_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `create_time` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of t_user_event_log -- ---------------------------- -- ---------------------------- -- Table structure for t_user_token -- ---------------------------- DROP TABLE IF EXISTS `t_user_token`; CREATE TABLE `t_user_token` ( `id` int NOT NULL AUTO_INCREMENT, `token` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `user_id` int NULL DEFAULT NULL, `wx_open_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `end_time` datetime NULL DEFAULT NULL, `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of t_user_token -- ---------------------------- SET FOREIGN_KEY_CHECKS = 1; 二者生成的pdm一致，用哪个都可以！
最后，导入完成sql文件，点击确认
成功生成13张表：
生成的pdm文件
注意Name想改成中文得自己改
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请联系我们，一经查实，本站将立刻删除。
如需转载请保留出处：https://51itzy.com/kjqy/49098.html