yygh_cmn数据库只含有一个表：dict 。该表存储医生的信息。

    1. /*
    2.  Navicat Premium Data Transfer
    4.  Source Server         : 本地连接
    5.  Source Server Type    : MySQL
    6.  Source Server Version : 80028
    7.  Source Host           : localhost:3306
    8.  Source Schema         : yygh_cmn
    10.  Target Server Type    : MySQL
    11.  Target Server Version : 80028
    12.  File Encoding         : 65001
    14.  Date: 30/03/2022 15:07:03
    15. */
    17. SET NAMES utf8mb4;
    18. SET FOREIGN_KEY_CHECKS = 0;
    20. -- ----------------------------
    21. -- Table structure for dict
    22. -- ----------------------------
    23. DROP TABLE IF EXISTS `dict`;
    24. CREATE TABLE `dict`  (
    25.   `id` bigint(0) NOT NULL DEFAULT 0 COMMENT 'id',
    26.   `parent_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '上级id',
    27.   `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称',
    28.   `value` bigint(0) NULL DEFAULT NULL COMMENT '值',
    29.   `dict_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',
    30.   `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
    31.   `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
    32.   `is_deleted` tinyint(0) NOT NULL DEFAULT 1 COMMENT '删除标记（0:不可用 1:可用）',
    33.   PRIMARY KEY (`id`) USING BTREE,
    34.   INDEX `idx_dict_code`(`dict_code`) USING BTREE,
    35.   INDEX `idx_parent_id`(`parent_id`) USING BTREE
    36. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组织架构表' ROW_FORMAT = Dynamic;
    38. SET FOREIGN_KEY_CHECKS = 1;

    image.png