/*
SQLyog Ultimate - MySQL GUI v8.2
MySQL - 5.0.87-community-nt : Database - jxdb
*********************************************************************
*/
/*!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*/`jxdb` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `jxdb`;
/*Table structure for table `access_log_p` */
DROP TABLE IF EXISTS `access_log_p`;
CREATE TABLE `access_log_p` (
`ACCESS_LOG_ID` varchar(40) NOT NULL,
`DEPT_NAME` varchar(100) default NULL,
`USER_NAME` varchar(40) default NULL,
`MODULE_NAME` varchar(200) default NULL,
`CURL` varchar(400) default NULL,
`CREATE_BY` varchar(40) default NULL,
`CREATE_TIME` datetime default NULL,
PRIMARY KEY (`ACCESS_LOG_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `access_log_p` */
/*Table structure for table `business_position_p` */
DROP TABLE IF EXISTS `business_position_p`;
CREATE TABLE `business_position_p` (
`BUSINESS_POSITION_ID` varchar(40) NOT NULL,
`NAME` varchar(100) default NULL,
`RESPONSIBILITY` varchar(500) default NULL,
`IS_USE` char(1) default NULL,
`ORDER_NO` int(11) default NULL,
PRIMARY KEY (`BUSINESS_POSITION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `business_position_p` */
/*Table structure for table `dept_p` */
DROP TABLE IF EXISTS `dept_p`;
CREATE TABLE `dept_p` (
`DEPT_ID` varchar(40) NOT NULL,
`DEPT_NAME` varchar(100) default NULL,
`DEPT_NAME_SHORT` varchar(100) default NULL,
`DEPT_NAME_FULL` varchar(100) default NULL,
`DEPT_DESC` varchar(100) default NULL,
`PARENT_ID` varchar(40) default NULL,
`PARENT_NAME` varchar(100) default NULL,
`LAYER_NUM` int(11) default NULL,
`IS_DUTY_LEVEL` char(1) default NULL,
`IS_TEAM` char(1) default NULL,
`IS_LEAF` char(1) default NULL,
`IS_USE` char(1) default NULL,
`ORDER_NO` int(11) default NULL,
`DEPT_LEVEL` int(11) default NULL,
`CREATED_BY` varchar(40) default NULL,
`CREATED_TIME` datetime default NULL,
`UPDATED_BY` varchar(40) default NULL,
`UPDATED_TIME` datetime default NULL,
`BASED_TIME` datetime default NULL,
`DUTY_LEVEL` varchar(40) default NULL,
PRIMARY KEY (`DEPT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `dept_p` */
insert into `dept_p`(`DEPT_ID`,`DEPT_NAME`,`DEPT_NAME_SHORT`,`DEPT_NAME_FULL`,`DEPT_DESC`,`PARENT_ID`,`PARENT_NAME`,`LAYER_NUM`,`IS_DUTY_LEVEL`,`IS_TEAM`,`IS_LEAF`,`IS_USE`,`ORDER_NO`,`DEPT_LEVEL`,`CREATED_BY`,`CREATED_TIME`,`UPDATED_BY`,`UPDATED_TIME`,`BASED_TIME`,`DUTY_LEVEL`) values ('0','组织机构','组织机构','组织机构','root','-1',NULL,1,'1','0','0','1',1,0,NULL,'2010-09-16 16:01:37',NULL,'2010-09-16 16:01:37',NULL,'0'),('0001','杰信商贸','杰信商贸','杰信商贸','组织机构','0',NULL,1,'1','0','0','1',1,1,NULL,'2009-05-23 11:23:39',NULL,'2009-05-23 11:23:39',NULL,'0001'),('0001001','开发部','开发部','开发部','','0001','杰信商贸',2,'1','0','1','1',NULL,NULL,'001','2011-07-16 07:38:37',NULL,NULL,NULL,'0001001'),('0001002','销售部','销售部','销售部','','0001','杰信商贸',2,'1','1','1','1',NULL,NULL,'001','2011-07-16 07:39:18',NULL,NULL,NULL,'0001002'),('0001003','船务部','船务部','船务部','','0001','杰信商贸',2,'1','0','1','1',NULL,NULL,'001','2011-07-16 07:39:56',NULL,NULL,NULL,'0001003'),('0001004','财务部','财务部','财务部','','0001','杰信商贸',2,'1','0','1','1',NULL,NULL,'001','2011-07-16 07:40:18',NULL,NULL,NULL,'0001004');
/*Table structure for table `exam_paper_c` */
DROP TABLE IF EXISTS `exam_paper_c`;
CREATE TABLE `exam_paper_c` (
`EXAM_PAPER_ID` varchar(40) NOT NULL,
`REPORT_CARD_ID` varchar(40) default NULL,
`TITLE` varchar(200) default NULL COMMENT '冗余=TEST_QUESTION_C',
`CONTENT` varchar(2000) default NULL COMMENT '冗余=TEST_QUESTION_C',
`ANSWER` varchar(2000) default NULL COMMENT '冗余=TEST_QUESTION_C',
`INPUT_ANSWER` varchar(2000) default NULL,
`CTYPE` int(11) default NULL COMMENT '冗余=TEST_QUESTION_C',
`SCORE` decimal(8,2) default NULL COMMENT '冗余=TEST_QUESTION_C',
`TOTAL_SCORE` decimal(8,2) default NULL,
`ORDER_NO` int(11) default NULL,
PRIMARY KEY (`EXAM_PAPER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `exam_paper_c` */
insert into `exam_paper_c`(`EXAM_PAPER_ID`,`REPORT_CARD_ID`,`TITLE`,`CONTENT`,`ANSWER`,`INPUT_ANSWER`,`CTYPE`,`SCORE`,`TOTAL_SCORE`,`ORDER_NO`) values ('402880ee410310d00141031f71580003','402880ee410310d00141031f71580002','1','2','A','A',1,'5.00',NULL,NULL),('402880ee410310d00141031f71580004','402880ee410310d00141031f71580002','遵守教学纪律，无迟到，提前下课，上课拨接手机等现象','A.非常满意|B.比较满意|C.基本满意|D.不太满意|E.非常不满意','A','A',1,'10.00',NULL,NULL),('402880ee410310d00141031f71580005','402880ee410310d00141031f71580002','3','4','A','A',1,'7.00',NULL,NULL),('402880ee410310d00141032789ac0007','402880ee410310d00141032789ac0006','3','4','A','A',1,'7.00',NULL,NULL),('402880ee410310d00141032789ac0008','402880ee410310d00141032789ac0006','1','2','A','A',1,'5.00',NULL,NULL),('402880ee410310d00141032789ac0009','402880ee410310d00141032789ac0006','遵守教学纪律，无迟到，提前下课，上课拨接手机等现象','A.非常满意|B.比较满意|C.基本满意|D.不太满意|E.非常不满意','A','A',1,'10.00',NULL,NULL);
/*Table structure for table `factory_c` */
DROP TABLE IF EXISTS `factory_c`;
CREATE TABLE `factory_c` (
`FACTORY_ID` varchar(40) NOT NULL,
`FULL_NAME` varchar(200) default NULL,
`FACTORY_NAME` varchar(50) default NULL,
`CONTRACTOR` varchar(30) default NULL,
`PHONE` varchar(20) default NULL,
`MOBILE` varchar(20) default NULL,
`FAX` varchar(20) default NULL,
`CTYPE` int(11) default NULL,
`CNOTE` text,
`STATE` int(11) default NULL,
`CREATE_BY` varchar(40) default NULL,
`CREATE_DEPT` varchar(40) default NULL,
`CREATE_TIME` datetime default NULL,
`INSPECTOR` varchar(30) default NULL,
`ORDER_NO` int(11) default NULL,
PRIMARY KEY (`FACTORY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `factory_c` */
insert into `factory_c`(`FACTORY_ID`,`FULL_NAME`,`FACTORY_NAME`,`CONTRACTOR`,`PHONE`,`MOBILE`,`FAX`,`CTYPE`,`CNOTE`,`STATE`,`CREATE_BY`,`CREATE_DEPT`,`CREATE_TIME`,`INSPECTOR`,`ORDER_NO`) values ('402880e6413519870141354e97f30002','1','','','','','',1,'',NULL,NULL,NULL,NULL,'',1),('402880e64135198701413553e6980003','2','','','','','',2,'',NULL,NULL,NULL,NULL,'',2),('402880e641351987014135544a340004','3','','','','','',3,'',NULL,NULL,NULL,NULL,'',3),('402880e6413519870141355da8850005','4','','','','','',2,'',NULL,NULL,NULL,NULL,'',4),('402880e6413519870141355dbd070006','5','','','','','',2,'',NULL,NULL,NULL,NULL,'',5),('402880e6413519870141355dd12b0007','6','','','','','',3,'',NULL,NULL,NULL,NULL,'',6),('402880e6413519870141355e83930008','7','','','','','',3,'',NULL,NULL,NULL,NULL,'',7),('402880e6413519870141355e96ad0009','8','','','','','',4,'',NULL,NULL,NULL,NULL,'',8),('402880e6413519870141355eab7e000a','9','','','','','',4,'',NULL,NULL,NULL,NULL,'',9),('402880e6413519870141355ec34b000b','10','','','','','',4,'',NULL,NULL,NULL,NULL,'',10),('402880e64135198701413562dbc2000c','11','','','','','',3,'',NULL,NULL,NULL,NULL,'',11);
/*Table structure for table `fast_menu_b` */
DROP TABLE IF EXISTS `fast_menu_b`;
CREATE TABLE `fast_menu_b` (
`ID` varchar(40) NOT NULL,
`NAME` varchar(30) default NULL,
`CNNAME` varchar(30) default NULL,
`CURL` varchar(150) default NULL,
`CLICK_NUM` int(11) default NULL,
`BELONG_USER`
