SQL历理 neirongxitong的数据库结构

/*
SQLyog 企业版 - MySQL GUI v8.14 
MySQL - 5.6.28 : Database - neirongxitong
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`neirongxitong` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `neirongxitong`;

/*Table structure for table `d_cont` */

DROP TABLE IF EXISTS `d_cont`;

CREATE TABLE `d_cont` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `user_id` int(6) NOT NULL COMMENT '用户编号',
  `modify_time` datetime NOT NULL COMMENT '修改时间',
  `logout` tinyint(1) DEFAULT '0' COMMENT '注销',
  `title` varchar(250) NOT NULL COMMENT '标题',
  `picture` varchar(250) NOT NULL COMMENT '图片',
  `cont` text NOT NULL COMMENT '内容',
  `score_id` int(6) NOT NULL COMMENT '评分编号',
  `cont_depa_id` int(6) NOT NULL COMMENT '文章科室编号',
  `cont_disease_id` int(6) NOT NULL COMMENT '文章病种编号',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=627 DEFAULT CHARSET=utf8 COMMENT='文章表';

/*Table structure for table `d_cont_depa` */

DROP TABLE IF EXISTS `d_cont_depa`;

CREATE TABLE `d_cont_depa` (
  `id` int(6) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `depa_name` varchar(100) NOT NULL COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='织梦文章科室表';

/*Table structure for table `d_cont_disease` */

DROP TABLE IF EXISTS `d_cont_disease`;

CREATE TABLE `d_cont_disease` (
  `id` int(6) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `disease_name` varchar(100) NOT NULL COMMENT '名称',
  `cont_depa_id` int(6) NOT NULL COMMENT '父编号',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=78 DEFAULT CHARSET=utf8 COMMENT='织梦文章病种表';

/*Table structure for table `d_cont_put` */

DROP TABLE IF EXISTS `d_cont_put`;

CREATE TABLE `d_cont_put` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `website_id` int(6) NOT NULL COMMENT '站点编号',
  `domain` varchar(100) NOT NULL COMMENT '域名',
  `dede_type_id` bigint(20) NOT NULL COMMENT '文章科室编号',
  `session_name` varchar(100) NOT NULL COMMENT 'Session用户',
  `now_time` datetime NOT NULL COMMENT '记录时间',
  `title` varchar(250) NOT NULL COMMENT '标题',
  `picture` varchar(250) NOT NULL COMMENT '图片',
  `cont` text NOT NULL COMMENT '内容',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=215 DEFAULT CHARSET=utf8 COMMENT='数据库记录表';

/*Table structure for table `d_cont_record` */

DROP TABLE IF EXISTS `d_cont_record`;

CREATE TABLE `d_cont_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `cont_id` bigint(20) NOT NULL COMMENT '文章编号',
  `user_id` int(6) NOT NULL COMMENT '用户编号',
  `session_name` varchar(100) NOT NULL COMMENT 'Session用户',
  `now_time` datetime NOT NULL COMMENT '记录时间',
  `title` varchar(250) NOT NULL COMMENT '标题',
  `picture` varchar(250) NOT NULL COMMENT '图片',
  `cont` text NOT NULL COMMENT '内容',
  `score_id` int(6) NOT NULL COMMENT '评分编号',
  `cont_depa_id` int(6) NOT NULL COMMENT '文章科室编号',
  `cont_disease_id` int(6) NOT NULL COMMENT '文章病种编号',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=547 DEFAULT CHARSET=utf8 COMMENT='文章记录表';

/*Table structure for table `d_score` */

DROP TABLE IF EXISTS `d_score`;

CREATE TABLE `d_score` (
  `id` int(6) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `score_name` varchar(100) NOT NULL COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='织梦评分表';

/*Table structure for table `d_zt` */

DROP TABLE IF EXISTS `d_zt`;

CREATE TABLE `d_zt` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `user_id` int(6) NOT NULL COMMENT '用户编号',
  `modify_time` datetime NOT NULL COMMENT '修改时间',
  `logout` tinyint(1) DEFAULT '0' COMMENT '注销',
  `title` varchar(250) NOT NULL COMMENT '标题',
  `route` varchar(250) NOT NULL COMMENT '路径',
  `score_id` int(6) NOT NULL COMMENT '评分编号',
  `zt_type_id` int(6) NOT NULL COMMENT '专题类型编号',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='专题表';

/*Table structure for table `d_zt_record` */

DROP TABLE IF EXISTS `d_zt_record`;

CREATE TABLE `d_zt_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `zt_id` bigint(20) NOT NULL COMMENT '专题编号',
  `user_id` int(6) NOT NULL COMMENT '用户编号',
  `session_name` varchar(100) NOT NULL COMMENT 'Session用户',
  `now_time` datetime NOT NULL COMMENT '记录时间',
  `title` varchar(250) NOT NULL COMMENT '标题',
  `route` varchar(250) NOT NULL COMMENT '路径',
  `score_id` int(6) NOT NULL COMMENT '评分编号',
  `zt_type_id` int(6) NOT NULL COMMENT '专题类型编号',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='数据库记录表';

/*Table structure for table `d_zt_type` */

DROP TABLE IF EXISTS `d_zt_type`;

CREATE TABLE `d_zt_type` (
  `id` int(6) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `zt_name` varchar(100) NOT NULL COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='专题种类表';

/*Table structure for table `r_register` */

DROP TABLE IF EXISTS `r_register`;

CREATE TABLE `r_register` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `patient` varchar(50) NOT NULL COMMENT '患者姓名',
  `contact` varchar(50) NOT NULL COMMENT '联系方式',
  `vis_time` datetime NOT NULL COMMENT '就诊时间',
  `bewrite` text NOT NULL COMMENT '病情描述',
  `ps` text NOT NULL COMMENT '备注',
  `state_id` int(6) NOT NULL COMMENT '状态编号',
  `logout` tinyint(1) DEFAULT '0' COMMENT '注销',
  `user_id` int(6) NOT NULL COMMENT '用户编号',
  `now_time` datetime NOT NULL COMMENT '当前时间',
  `furl` varchar(250) NOT NULL COMMENT '来源URL',
  `fip` varchar(30) NOT NULL COMMENT '获取IP',
  `fcity` varchar(100) NOT NULL COMMENT '获取城市',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='挂号表';

/*Table structure for table `r_register_record` */

DROP TABLE IF EXISTS `r_register_record`;

CREATE TABLE `r_register_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `register_id` bigint(20) NOT NULL COMMENT '挂号编号',
  `patient` varchar(50) NOT NULL COMMENT '患者姓名',
  `contact` varchar(50) NOT NULL COMMENT '联系方式',
  `vis_time` datetime NOT NULL COMMENT '就诊时间',
  `bewrite` text NOT NULL COMMENT '病情描述',
  `ps` text NOT NULL COMMENT '备注',
  `state_id` int(6) NOT NULL COMMENT '状态编号',
  `user_id` int(6) NOT NULL COMMENT '用户编号',
  `now_time` datetime NOT NULL COMMENT '当前时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='挂号记录表';

/*Table structure for table `r_register_state` */

DROP TABLE IF EXISTS `r_register_state`;

CREATE TABLE `r_register_state` (
  `id` int(6) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `state_name` varchar(100) NOT NULL COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='挂号状态表';

/*Table structure for table `u_depa` */

DROP TABLE IF EXISTS `u_depa`;

CREATE TABLE `u_depa` (
  `id` int(2) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `depa_name` varchar(50) NOT NULL COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='用户部门表';

/*Table structure for table `u_record` */

DROP TABLE IF EXISTS `u_record`;

CREATE TABLE `u_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `user_id` int(6) NOT NULL COMMENT '操作者',
  `now_time` datetime NOT NULL COMMENT '操作时间',
  `record_cont` varchar(250) NOT NULL COMMENT '操作记录',
  `record_ip` varchar(50) NOT NULL COMMENT '客户端的IP',
  `record_city` varchar(100) NOT NULL COMMENT '客户端的城市',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=410 DEFAULT CHARSET=utf8 COMMENT='用户操作记录表';

/*Table structure for table `u_role` */

DROP TABLE IF EXISTS `u_role`;

CREATE TABLE `u_role` (
  `id` int(2) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `role_name` varchar(50) NOT NULL COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='用户超级权限表';

/*Table structure for table `u_user` */

DROP TABLE IF EXISTS `u_user`;

CREATE TABLE `u_user` (
  `id` int(6) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `zh_name` varchar(20) NOT NULL COMMENT '中文姓名',
  `en_name` varchar(20) NOT NULL COMMENT '英文名',
  `pwd` varchar(250) NOT NULL COMMENT '密码',
  `now_time` datetime NOT NULL COMMENT '操作时间',
  `logout` tinyint(1) DEFAULT '0' COMMENT '注销',
  `depa_id` int(2) NOT NULL COMMENT '部门编号',
  `role_id` int(2) NOT NULL COMMENT '超级权限编号',
  `session_id` varchar(100) NOT NULL COMMENT 'SessionID',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='用户表';

/*Table structure for table `w_website` */

DROP TABLE IF EXISTS `w_website`;

CREATE TABLE `w_website` (
  `id` int(6) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `user_id` int(6) NOT NULL COMMENT '用户编号',
  `logout` tinyint(1) DEFAULT '0' COMMENT '注销',
  `domain` varchar(100) NOT NULL COMMENT '域名',
  `now_time` datetime NOT NULL COMMENT '操作时间',
  `admin_domain` varchar(100) NOT NULL COMMENT '后台域名',
  `admin_user` varchar(100) NOT NULL COMMENT '账号',
  `admin_pwd` varchar(250) NOT NULL COMMENT '密码',
  `dbhost` varchar(100) NOT NULL COMMENT '数据库IP',
  `dbname` varchar(100) NOT NULL COMMENT '数据库用户',
  `dbuser` varchar(100) NOT NULL COMMENT '数据库账号',
  `dbpwd` varchar(250) NOT NULL COMMENT '数据库密码',
  `ps` text NOT NULL COMMENT '备注',
  `picture` varchar(100) NOT NULL COMMENT '图片路径',
  `website_type_id` int(6) NOT NULL COMMENT '科室类别编号',
  `website_hos_id` int(6) NOT NULL COMMENT '医院名称编号',
  `website_sem_id` int(6) NOT NULL COMMENT '推广方式编号',
  `website_mpc_id` int(6) NOT NULL COMMENT '手机/PC编号',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=utf8 COMMENT='站点表';

/*Table structure for table `w_website_hos` */

DROP TABLE IF EXISTS `w_website_hos`;

CREATE TABLE `w_website_hos` (
  `id` int(6) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `hos_name` varchar(100) NOT NULL COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='站点医院名称';

/*Table structure for table `w_website_mpc` */

DROP TABLE IF EXISTS `w_website_mpc`;

CREATE TABLE `w_website_mpc` (
  `id` int(6) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `mpc_name` varchar(100) NOT NULL COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='站点手机/PC';

/*Table structure for table `w_website_record` */

DROP TABLE IF EXISTS `w_website_record`;

CREATE TABLE `w_website_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `website_id` int(6) NOT NULL COMMENT '站点编号',
  `session_name` varchar(100) NOT NULL COMMENT 'Session用户',
  `user_id` int(6) NOT NULL COMMENT '用户编号',
  `logout` tinyint(1) DEFAULT '0' COMMENT '注销',
  `domain` varchar(100) NOT NULL COMMENT '域名',
  `now_time` datetime NOT NULL COMMENT '操作时间',
  `admin_domain` varchar(100) NOT NULL COMMENT '后台域名',
  `admin_user` varchar(100) NOT NULL COMMENT '账号',
  `admin_pwd` varchar(250) NOT NULL COMMENT '密码',
  `dbhost` varchar(100) NOT NULL COMMENT '数据库IP',
  `dbname` varchar(100) NOT NULL COMMENT '数据库用户',
  `dbuser` varchar(100) NOT NULL COMMENT '数据库账号',
  `dbpwd` varchar(250) NOT NULL COMMENT '数据库密码',
  `ps` text NOT NULL COMMENT '备注',
  `picture` varchar(100) NOT NULL COMMENT '图片路径',
  `website_type_id` int(6) NOT NULL COMMENT '科室类别编号',
  `website_hos_id` int(6) NOT NULL COMMENT '医院名称编号',
  `website_sem_id` int(6) NOT NULL COMMENT '推广方式编号',
  `website_mpc_id` int(6) NOT NULL COMMENT '手机/PC编号',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=145 DEFAULT CHARSET=utf8 COMMENT='站点记录表';

/*Table structure for table `w_website_sem` */

DROP TABLE IF EXISTS `w_website_sem`;

CREATE TABLE `w_website_sem` (
  `id` int(6) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `sem_name` varchar(100) NOT NULL COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='站点推广方式';

/*Table structure for table `w_website_type` */

DROP TABLE IF EXISTS `w_website_type`;

CREATE TABLE `w_website_type` (
  `id` int(6) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `type_name` varchar(100) NOT NULL COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='站点科室类别';

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
posted @ 2024-05-28 20:02 onestopweb 阅读(7) 评论(0) 编辑收藏举报
刷新页面返回顶部
登录后才能查看或发表评论，立即登录或者逛逛博客园首页
公告

昵称： onestopweb
园龄： 2年4个月
粉丝： 0
关注： 0
+加关注
2025年3月
日
一
二
三
四
五
六
onestopweb

万物皆数，有数必有公式。

SQL历理 neirongxitong的数据库结构

公告

搜索

常用链接

随笔分类

随笔档案

文章分类

阅读排行榜
