/*

Navicat MySQL Data Transfer

Source Server : rm-m5e3xn7k26i026e75o.mysql.rds.aliyuncs.com

Source Server Version : 50629

Source Host : rm-m5e3xn7k26i026e75o.mysql.rds.aliyuncs.com:3306

Source Database : base

Target Server Type : MYSQL

Target Server Version : 50629

File Encoding : 65001

Date: 2016-09-19 12:37:16

*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for basearea

-- ----------------------------

DROP TABLE IF EXISTS `basearea`;

CREATE TABLE `basearea` (

`Id` varchar(11) COLLATE utf8_unicode_ci NOT NULL,

`ParentId` int(11) DEFAULT NULL COMMENT '父节点',

`Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '内码',

`FullName` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '全名',

`ShortName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '短名',

`Layer` int(11) DEFAULT NULL,

`Whole` smallint(1) NOT NULL DEFAULT '' COMMENT '整体',

`Send` smallint(1) NOT NULL DEFAULT '' COMMENT '发送',

`Receive` smallint(1) NOT NULL DEFAULT '',

`Postalcode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`Province` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`City` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`District` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`QuickQuery` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`SimpleSpelling` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Longitude` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,

`Latitude` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,

`NetworkOrders` int(11) DEFAULT '',

`AllowToPay` int(11) NOT NULL DEFAULT '',

`MaxToPayment` int(11) NOT NULL DEFAULT '',

`AllowGoodsPay` int(11) NOT NULL DEFAULT '',

`MaxGoodsPayment` int(11) NOT NULL DEFAULT '',

`ManageCompanyId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ManageCompanyCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ManageCompany` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Mark` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`OutOfRange` smallint(1) DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(1) NOT NULL DEFAULT '',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`DelayDay` int(2) NOT NULL DEFAULT '',

`Opening` smallint(1) NOT NULL DEFAULT '',

`PrintMark` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Statistics` smallint(1) NOT NULL DEFAULT '',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`),

KEY `ParentId` (`ParentId`) USING BTREE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basecomment

-- ----------------------------

DROP TABLE IF EXISTS `basecomment`;

CREATE TABLE `basecomment` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`ParentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`DepartmentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`DepartmentName` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ObjectId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Worked` smallint(6) DEFAULT '',

`Contents` text COLLATE utf8_unicode_ci,

`IPAddress` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`TargetURL` varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL,

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basecontact

-- ----------------------------

DROP TABLE IF EXISTS `basecontact`;

CREATE TABLE `basecontact` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`ParentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Title` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Contents` varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL,

`Priority` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`SendCount` int(11) DEFAULT '',

`ReadCount` int(11) DEFAULT '',

`ReplyCount` int(11) DEFAULT NULL,

`IsOpen` int(11) DEFAULT NULL,

`CommentUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CommentUserRealName` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`CommentDate` datetime DEFAULT NULL,

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basecontactdetails

-- ----------------------------

DROP TABLE IF EXISTS `basecontactdetails`;

CREATE TABLE `basecontactdetails` (

`Id` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ContactId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Category` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ReceiverId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ReceiverRealName` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`IsNew` int(11) NOT NULL DEFAULT '',

`NewComment` int(11) NOT NULL DEFAULT '',

`LastViewIP` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`LastViewDate` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basedepartment

-- ----------------------------

DROP TABLE IF EXISTS `basedepartment`;

CREATE TABLE `basedepartment` (

`ID` varchar(40) COLLATE utf8_unicode_ci NOT NULL,

`PARENTID` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CODE` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`SHORTNAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`FULLNAME` varchar(200) COLLATE utf8_unicode_ci NOT NULL,

`CATEGORYCODE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`OUTERPHONE` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`INNERPHONE` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`FAX` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`DESCRIPTION` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,

`CREATEON` datetime DEFAULT NULL,

`CREATEUSERID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`CREATEBY` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`MODIFIEDON` datetime DEFAULT NULL,

`MODIFIEDUSERID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`MODIFIEDBY` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`MANAGER` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`MANAGERMOBILE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`MANAGERQQ` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`PARENTNAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`COMPANYID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`COMPANYNAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`COMPANYCODE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`PARENTCODE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`CATEGORYNAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`MANAGERID` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`STANDARDNAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`STANDARDCODE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`ID`),

KEY `BASEDEPARTMENT_I` (`COMPANYID`,`CATEGORYCODE`,`DeletionStateCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseexception

-- ----------------------------

DROP TABLE IF EXISTS `baseexception`;

CREATE TABLE `baseexception` (

`LogId` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`SystemCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`EventId` int(11) DEFAULT NULL,

`Category` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,

`Priority` int(11) DEFAULT NULL,

`Severity` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,

`Title` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,

`Timestamp` datetime DEFAULT NULL,

`MachineName` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,

`IPAddress` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`AppDomainName` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL,

`ProcessId` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,

`ProcessName` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL,

`ThreadName` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL,

`Win32ThreadId` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,

`Message` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL,

`FormattedMessage` text COLLATE utf8_unicode_ci,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`LogId`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basefile

-- ----------------------------

DROP TABLE IF EXISTS `basefile`;

CREATE TABLE `basefile` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,

`FolderId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`FileName` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`FilePath` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,

`ImageUrl` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,

`Contents` blob,

`ReadCount` int(11) NOT NULL DEFAULT '',

`FileSize` int(11) NOT NULL DEFAULT '',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basefolder

-- ----------------------------

DROP TABLE IF EXISTS `basefolder`;

CREATE TABLE `basefolder` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`ParentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`FolderName` varchar(400) COLLATE utf8_unicode_ci NOT NULL,

`StateCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`SortCode` int(11) NOT NULL,

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` int(11) DEFAULT '',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseholidays

-- ----------------------------

DROP TABLE IF EXISTS `baseholidays`;

CREATE TABLE `baseholidays` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`Holiday` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseitemdetails

-- ----------------------------

DROP TABLE IF EXISTS `baseitemdetails`;

CREATE TABLE `baseitemdetails` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseitems

-- ----------------------------

DROP TABLE IF EXISTS `baseitems`;

CREATE TABLE `baseitems` (

`Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',

`ParentId` int(11) DEFAULT NULL COMMENT '父节点主键',

`Code` varchar(200) COLLATE utf8_unicode_ci NOT NULL COMMENT '编号',

`FullName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',

`TargetTable` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '目标存储表',

`IsTree` smallint(6) NOT NULL DEFAULT '' COMMENT '树型结构',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseknowledge

-- ----------------------------

DROP TABLE IF EXISTS `baseknowledge`;

CREATE TABLE `baseknowledge` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`ParentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`DepartmentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`DepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CategoryCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ObjectId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Worked` smallint(11) DEFAULT NULL,

`Contents` text COLLATE utf8_unicode_ci,

`Important` smallint(11) DEFAULT '',

`PriorityId` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`IPAddress` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`TargetURL` varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL,

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baselog

-- ----------------------------

DROP TABLE IF EXISTS `baselog`;

CREATE TABLE `baselog` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,

`StartTime` datetime NOT NULL,

`TaskId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Service` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ElapsedTicks` int(11) DEFAULT NULL,

`UserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`UserRealName` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ClientIP` varchar(50) COLLATE utf8_unicode_ci NOT NULL,

`ServerIP` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`WebUrl` varchar(1600) COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Parameters` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`UrlReferrer` varchar(1600) COLLATE utf8_unicode_ci DEFAULT NULL,

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basemessage

-- ----------------------------

DROP TABLE IF EXISTS `basemessage`;

CREATE TABLE `basemessage` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`FunctionCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CategoryCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ObjectId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ReceiverDepartmentId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ReceiverDepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ReceiverId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ReceiverRealname` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`QQ` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Telephone` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Title` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,

`Contents` text COLLATE utf8_unicode_ci,

`IsNew` int(11) NOT NULL DEFAULT '',

`ReadCount` int(11) NOT NULL DEFAULT '',

`ReadDate` datetime DEFAULT NULL,

`IPAddress` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`TargetURL` varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateDepartmentId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateDepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basemessagerecent

-- ----------------------------

DROP TABLE IF EXISTS `basemessagerecent`;

CREATE TABLE `basemessagerecent` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`UserId` varchar(200) COLLATE utf8_unicode_ci NOT NULL,

`TargetCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`TargetId` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`RealName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`DepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basemodifyrecord

-- ----------------------------

DROP TABLE IF EXISTS `basemodifyrecord`;

CREATE TABLE `basemodifyrecord` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`TableCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`TableDescription` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`ColumnCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ColumnDescription` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`RecordKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`OldKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`OldValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`NewKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`NewValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`IPAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=2538 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basemodule

-- ----------------------------

DROP TABLE IF EXISTS `basemodule`;

CREATE TABLE `basemodule` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'UUID主键',

`ParentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '父节点主键',

`Code` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '编号',

`FullName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',

`CategoryCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT 'Application' COMMENT '分类',

`ImagUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图标图片地址',

`ImageIndex` smallint(6) DEFAULT NULL COMMENT '图标编号',

`SelectedImageIndex` smallint(6) DEFAULT NULL COMMENT '选中状态图标编号',

`NavigateUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '导航地址',

`Target` varchar(200) COLLATE utf8_unicode_ci DEFAULT 'fraContent' COMMENT '目标窗体中打开',

`WebBrowser` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '浏览器',

`FormName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '窗体名',

`AssemblyName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '动态连接库',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标志',

`IsMenu` smallint(6) DEFAULT '' COMMENT '是菜单项',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '是公开',

`Expand` smallint(6) NOT NULL DEFAULT '' COMMENT '展开状态',

`IsScope` smallint(6) NOT NULL DEFAULT '' COMMENT '权限域（需要数据权限）',

`IsVisible` smallint(6) NOT NULL DEFAULT '' COMMENT '是可见',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`LastCall` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最后被调用日期',

`AuthorizedDays` smallint(11) NOT NULL DEFAULT '' COMMENT '默认授权天数、默认多少天有数、0表示无限制',

`Description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basenews

-- ----------------------------

DROP TABLE IF EXISTS `basenews`;

CREATE TABLE `basenews` (

`Id` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`FolderId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Title` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`FilePath` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,

`Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CategoryCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Source` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`Introduction` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,

`Keywords` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,

`Contents` text COLLATE utf8_unicode_ci,

`ReadCount` int(11) NOT NULL DEFAULT '',

`FileSize` int(11) NOT NULL DEFAULT '',

`ImageUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`HomePage` int(11) DEFAULT '',

`SubPage` int(11) DEFAULT NULL,

`DepartmentId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`DepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`AuditStatus` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basenotice

-- ----------------------------

DROP TABLE IF EXISTS `basenotice`;

CREATE TABLE `basenotice` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ParameterId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ParameterCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ParameterContent` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL,

`Worked` smallint(11) NOT NULL DEFAULT '',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseorganize

-- ----------------------------

DROP TABLE IF EXISTS `baseorganize`;

CREATE TABLE `baseorganize` (

`Id` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,

`ParentId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`ParentName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`Code` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`FullName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`ShortName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`StandardName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`StandardCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`StatisticalName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`QuickQuery` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`SimpleSpelling` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`CategoryCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`OuterPhone` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`InnerPhone` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`Fax` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`Postalcode` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`ProvinceId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`Province` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`CityId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`City` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`DistrictId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`District` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`StreetId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`Street` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyId` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyCode` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyName` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`Area` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`CostCenter` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`FinancialCenter` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`Address` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`Web` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`Bank` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`BankAccount` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`Layer` int(11) DEFAULT NULL,

`JoiningMethods` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`Longitude` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`Latitude` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`ContainChildNodes` int(11) NOT NULL DEFAULT '',

`IsInnerOrganize` int(11) NOT NULL DEFAULT '',

`SendAir` int(11) DEFAULT '',

`CalculateComeFee` int(11) DEFAULT '',

`CalculateReceiveFee` int(11) DEFAULT '',

`BillBalanceSite` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`LevelTwoTransferCenter` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`ProvinceSite` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`BigArea` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`SendFee` decimal(10,0) DEFAULT NULL,

`LevelTwoTransferFee` decimal(10,0) DEFAULT NULL,

`BillSubsidy` decimal(10,0) DEFAULT NULL,

`CostCenterId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`FinancialCenterId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`ManageId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`ManageName` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`IsCheckBalance` smallint(6) DEFAULT '',

`WeightRatio` int(11) DEFAULT NULL,

`Master` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`MasterMobile` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`MasterQQ` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`ManagerMobile` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`ManagerQQ` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`EmergencyCall` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`BusinessPhone` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`Manager` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Table structure for baseorganizescope

-- ----------------------------

DROP TABLE IF EXISTS `baseorganizescope`;

CREATE TABLE `baseorganizescope` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '自增主键',

`ResourceCategory` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么类型的',

`ResourceId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么资源主键',

`PermissionId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '有什么权限（模块菜单）主键',

`AllData` smallint(6) DEFAULT '' COMMENT '全部数据',

`Province` smallint(6) DEFAULT '' COMMENT '所在省',

`City` smallint(6) DEFAULT '' COMMENT '所在市',

`District` smallint(6) DEFAULT '' COMMENT '所在区/县',

`Street` smallint(6) DEFAULT '' COMMENT '所在街道',

`UserCompany` smallint(6) DEFAULT '' COMMENT '用户所在公司的数据',

`UserSubCompany` smallint(6) DEFAULT '' COMMENT '用户所在分公司的数据',

`UserDepartment` smallint(6) DEFAULT '' COMMENT '用户所在部门的数据',

`UserSubDepartment` smallint(6) DEFAULT '' COMMENT '用户所在子部门的数据',

`UserWorkgroup` smallint(6) DEFAULT '' COMMENT '用户所在工作组的数据',

`OnlyOwnData` smallint(6) NOT NULL DEFAULT '' COMMENT '仅仅用户自己的数据',

`NotAllowed` smallint(6) DEFAULT '' COMMENT '不允许查看数据',

`ByDetails` smallint(6) DEFAULT '' COMMENT '按明细设置',

`ContainChild` smallint(6) NOT NULL DEFAULT '' COMMENT '包含子节点的数据',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标示',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseorganize_log

-- ----------------------------

DROP TABLE IF EXISTS `baseorganize_log`;

CREATE TABLE `baseorganize_log` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`TableCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`TableDescription` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`ColumnCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ColumnDescription` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`RecordKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`OldKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`OldValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`NewKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`NewValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`IPAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseparameter

-- ----------------------------

DROP TABLE IF EXISTS `baseparameter`;

CREATE TABLE `baseparameter` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ParameterId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ParameterCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ParameterContent` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL,

`Worked` smallint(11) NOT NULL DEFAULT '',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basepermission

-- ----------------------------

DROP TABLE IF EXISTS `basepermission`;

CREATE TABLE `basepermission` (

`Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',

`ResourceCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资料类别',

`ResourceId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源主键',

`PermissionId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限（菜单模块）主键',

`CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '公司主键',

`CompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '公司名称',

`PermissionConstraint` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限条件限制',

`Enabled` smallint(6) DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT NULL COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT NULL COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basepermissionscope

-- ----------------------------

DROP TABLE IF EXISTS `basepermissionscope`;

CREATE TABLE `basepermissionscope` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '自增主键',

`ResourceCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么类型的',

`ResourceId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么资源主键',

`TargetCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '对什么类型的',

`TargetId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '对什么资源主键',

`PermissionId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '有什么权限（模块菜单）主键',

`ContainChild` smallint(6) NOT NULL DEFAULT '' COMMENT '包含子节点',

`PermissionConstraint` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '有什么权限约束表达式',

`StartDate` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '开始生效日期',

`EndDate` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '结束生效日期',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baserole

-- ----------------------------

DROP TABLE IF EXISTS `baserole`;

CREATE TABLE `baserole` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '主键',

`OrganizeId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '组织机构主键',

`Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色编号',

`RealName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色名称',

`CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '分类',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsVisible` smallint(6) NOT NULL DEFAULT '' COMMENT '可显示',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseroleorganize

-- ----------------------------

DROP TABLE IF EXISTS `baseroleorganize`;

CREATE TABLE `baseroleorganize` (

`Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',

`RoleId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '角色主键',

`OrganizeId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '组织机构主键',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime NOT NULL COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baserole_deleted

-- ----------------------------

DROP TABLE IF EXISTS `baserole_deleted`;

CREATE TABLE `baserole_deleted` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '主键',

`OrganizeId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '组织机构主键',

`Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色编号',

`RealName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色名称',

`CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '分类',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsVisible` smallint(6) NOT NULL DEFAULT '' COMMENT '可显示',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basesequence

-- ----------------------------

DROP TABLE IF EXISTS `basesequence`;

CREATE TABLE `basesequence` (

`Id` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`FullName` varchar(100) COLLATE utf8_unicode_ci NOT NULL,

`Prefix` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Delimiter` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Sequence` int(11) NOT NULL DEFAULT '',

`Reduction` int(11) NOT NULL DEFAULT '',

`Step` int(11) NOT NULL DEFAULT '',

`IsVisible` int(11) NOT NULL DEFAULT '',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT '',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basestaff

-- ----------------------------

DROP TABLE IF EXISTS `basestaff`;

CREATE TABLE `basestaff` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`UserId` int(11) DEFAULT NULL,

`UserName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`RealName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`QuickQuery` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`SubCompanyId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`DepartmentId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`DepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`WorkgroupId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`WorkgroupName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`DutyId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Gender` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Birthday` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Age` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Height` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`Weight` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`IdentificationCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`IDCard` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Nation` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Education` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`School` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`Major` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Degree` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`TitleId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`TitleDate` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`TitleLevel` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`WorkingDate` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`JoinInDate` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`OfficePostCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`OfficeAddress` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`OfficeFax` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`OfficePhone` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`HomePostCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`HomeAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`HomeFax` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`HomePhone` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CarCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`RewarCard` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`MedicalCard` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`UnionMember` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Email` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Mobile` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ShortNumber` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Telephone` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Extension` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`EmergencyContact` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`QQ` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`DimissionDate` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`DimissionCause` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`DimissionWhither` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`NativePlace` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`BankName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`BankCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`BankUserName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Province` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`City` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`District` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CurrentProvince` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CurrentCity` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basestafforganize

-- ----------------------------

DROP TABLE IF EXISTS `basestafforganize`;

CREATE TABLE `basestafforganize` (

`Id` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`StaffId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`OrganizeId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` int(11) DEFAULT NULL,

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for basetablecolumns

-- ----------------------------

DROP TABLE IF EXISTS `basetablecolumns`;

CREATE TABLE `basetablecolumns` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`TableCode` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ColumnCode` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ColumnName` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`ColumnAccess` int(11) DEFAULT '',

`ColumnEdit` int(11) DEFAULT '',

`ColumnDeney` int(11) DEFAULT '',

`UseConstraint` int(11) NOT NULL DEFAULT '',

`DataType` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`TargetTable` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseuser

-- ----------------------------

DROP TABLE IF EXISTS `baseuser`;

CREATE TABLE `baseuser` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,

`UserFrom` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ManagerId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`UserName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`RealName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`NickName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Code` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`IDCard` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`QuickQuery` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`SimpleSpelling` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`SubCompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`SubCompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`DepartmentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`DepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`SubDepartmentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`SubDepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`WorkgroupId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`WorkgroupName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`WorkCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`SecurityLevel` int(11) DEFAULT NULL,

`Title` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Duty` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Lang` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Gender` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Birthday` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Score` int(11) DEFAULT NULL,

`Fans` int(11) DEFAULT NULL,

`HomeAddress` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`Signature` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`Theme` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`IsStaff` smallint(1) NOT NULL DEFAULT '',

`IsVisible` smallint(1) NOT NULL DEFAULT '',

`IsAdministrator` smallint(1) DEFAULT '',

`Province` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`City` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`District` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`MANAGERAUDITSTATUS` int(11) DEFAULT NULL,

`MANAGERAUDITDATE` date DEFAULT NULL,

`IsCheckBalance` smallint(1) DEFAULT '',

`AuditStatus` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(1) DEFAULT '',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`),

KEY `USERNAME` (`UserName`) USING HASH

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseuseraddress

-- ----------------------------

DROP TABLE IF EXISTS `baseuseraddress`;

CREATE TABLE `baseuseraddress` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`UserId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`RealName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ProvinceId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Province` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CityId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`City` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`DistrictId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`District` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Address` varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL,

`PostCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Phone` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Mobile` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Fax` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Email` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`DeliverCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`DeletionStateCode` int(11) DEFAULT NULL,

`Enabled` int(11) DEFAULT NULL,

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseusercontact

-- ----------------------------

DROP TABLE IF EXISTS `baseusercontact`;

CREATE TABLE `baseusercontact` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,

`CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Email` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`EmailValiated` smallint(11) NOT NULL DEFAULT '',

`Mobile` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`MobileValiated` smallint(11) DEFAULT '',

`MobileVerificationDate` datetime DEFAULT NULL,

`ShowMobile` smallint(1) DEFAULT NULL,

`ShortNumber` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Telephone` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Extension` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`QQ` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`WW` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`WeChat` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`WeChatValiated` smallint(1) NOT NULL DEFAULT '',

`YiXin` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`YiXinValiated` smallint(1) NOT NULL DEFAULT '',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseuserextend

-- ----------------------------

DROP TABLE IF EXISTS `baseuserextend`;

CREATE TABLE `baseuserextend` (

`Id` varchar(40) NOT NULL COMMENT '用户ID',

`Fund` int(11) NOT NULL DEFAULT '' COMMENT '用户金额',

`Rate` int(11) NOT NULL DEFAULT '' COMMENT '费率',

`Category` int(1) NOT NULL DEFAULT '' COMMENT '用户类别',

`SMSContent` varchar(255) DEFAULT NULL COMMENT '消息内容',

`CardId` varchar(20) DEFAULT NULL COMMENT '身份卡ID',

`Express` varchar(50) DEFAULT NULL COMMENT '快递',

`Email` varchar(50) DEFAULT NULL COMMENT '邮箱',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Table structure for baseuserlogon

-- ----------------------------

DROP TABLE IF EXISTS `baseuserlogon`;

CREATE TABLE `baseuserlogon` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,

`CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`UserPassword` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`OpenId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`AllowStartTime` datetime DEFAULT NULL,

`AllowEndTime` datetime DEFAULT NULL,

`LockStartDate` datetime DEFAULT NULL,

`LockEndDate` datetime DEFAULT NULL,

`FirstVisit` datetime DEFAULT NULL,

`PreviousVisit` datetime DEFAULT NULL,

`LastVisit` datetime DEFAULT NULL,

`ChangePasswordDate` datetime DEFAULT NULL,

`LogOnCount` int(11) NOT NULL DEFAULT '',

`Salt` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`OpenIdTimeout` datetime DEFAULT NULL,

`MultiUserLogin` smallint(11) DEFAULT '',

`ShowCount` int(11) NOT NULL DEFAULT '',

`PasswordErrorCount` smallint(11) NOT NULL DEFAULT '',

`UserOnLine` smallint(11) NOT NULL DEFAULT '',

`CheckIPAddress` smallint(11) NOT NULL DEFAULT '',

`VerificationCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`IPAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`MACAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Question` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`AnswerQuestion` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT NULL,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT NULL,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`SystemCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`IPAddressName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`PasswordStrength` int(11) DEFAULT NULL,

`Enabled` smallint(11) NOT NULL DEFAULT '',

`NeedModifyPassword` smallint(11) DEFAULT '',

`ComputerName` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseuserorganize

-- ----------------------------

DROP TABLE IF EXISTS `baseuserorganize`;

CREATE TABLE `baseuserorganize` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`UserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`SubCompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`DepartmentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`SubDepartmentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`WorkgroupId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(1) NOT NULL DEFAULT '',

`DeletionStateCode` smallint(1) DEFAULT '',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseuserrole

-- ----------------------------

DROP TABLE IF EXISTS `baseuserrole`;

CREATE TABLE `baseuserrole` (

`Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',

`UserId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '用户主键',

`CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`RoleId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '角色主键',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime NOT NULL COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`),

KEY `UserId` (`UserId`,`Enabled`,`DeletionStateCode`)

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseuserscore

-- ----------------------------

DROP TABLE IF EXISTS `baseuserscore`;

CREATE TABLE `baseuserscore` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`UserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Username` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Score` int(11) DEFAULT NULL,

`FunctionCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ObjectId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`Contents` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for baseuser_log

-- ----------------------------

DROP TABLE IF EXISTS `baseuser_log`;

CREATE TABLE `baseuser_log` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`TableCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`TableDescription` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`ColumnCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ColumnDescription` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`RecordKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`OldKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`OldValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`NewKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`NewValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`IPAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------

-- Table structure for base_loginlog

-- ----------------------------

DROP TABLE IF EXISTS `base_loginlog`;

CREATE TABLE `base_loginlog` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,

`Companyid` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyName` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`UserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`UserName` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`SystemCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`LoginStatus` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`MACAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`IPAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`IPAddressName` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`ElapsedTicks` int(11) DEFAULT NULL,

`Service` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for businesscard

-- ----------------------------

DROP TABLE IF EXISTS `businesscard`;

CREATE TABLE `businesscard` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`FullName` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`Company` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`Title` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`Phone` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`Postalcode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`Mobile` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`Address` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`Email` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`OfficePhone` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`QQ` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`Fax` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`Web` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`BankName` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`BankAccount` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`TaxAccount` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`Personal` smallint(11) DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsallowdelete

-- ----------------------------

DROP TABLE IF EXISTS `itemsallowdelete`;

CREATE TABLE `itemsallowdelete` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsallowedit

-- ----------------------------

DROP TABLE IF EXISTS `itemsallowedit`;

CREATE TABLE `itemsallowedit` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsauditidea

-- ----------------------------

DROP TABLE IF EXISTS `itemsauditidea`;

CREATE TABLE `itemsauditidea` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsauditstatus

-- ----------------------------

DROP TABLE IF EXISTS `itemsauditstatus`;

CREATE TABLE `itemsauditstatus` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsbuglevel

-- ----------------------------

DROP TABLE IF EXISTS `itemsbuglevel`;

CREATE TABLE `itemsbuglevel` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemscondition

-- ----------------------------

DROP TABLE IF EXISTS `itemscondition`;

CREATE TABLE `itemscondition` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsdegree

-- ----------------------------

DROP TABLE IF EXISTS `itemsdegree`;

CREATE TABLE `itemsdegree` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsdeletionstatecode

-- ----------------------------

DROP TABLE IF EXISTS `itemsdeletionstatecode`;

CREATE TABLE `itemsdeletionstatecode` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsduty

-- ----------------------------

DROP TABLE IF EXISTS `itemsduty`;

CREATE TABLE `itemsduty` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemseducation

-- ----------------------------

DROP TABLE IF EXISTS `itemseducation`;

CREATE TABLE `itemseducation` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsenabled

-- ----------------------------

DROP TABLE IF EXISTS `itemsenabled`;

CREATE TABLE `itemsenabled` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsgender

-- ----------------------------

DROP TABLE IF EXISTS `itemsgender`;

CREATE TABLE `itemsgender` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsindustry

-- ----------------------------

DROP TABLE IF EXISTS `itemsindustry`;

CREATE TABLE `itemsindustry` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsleavecategory

-- ----------------------------

DROP TABLE IF EXISTS `itemsleavecategory`;

CREATE TABLE `itemsleavecategory` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemslinks

-- ----------------------------

DROP TABLE IF EXISTS `itemslinks`;

CREATE TABLE `itemslinks` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemslockwaitminute

-- ----------------------------

DROP TABLE IF EXISTS `itemslockwaitminute`;

CREATE TABLE `itemslockwaitminute` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsmarriage

-- ----------------------------

DROP TABLE IF EXISTS `itemsmarriage`;

CREATE TABLE `itemsmarriage` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsnationality

-- ----------------------------

DROP TABLE IF EXISTS `itemsnationality`;

CREATE TABLE `itemsnationality` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsnewscategory

-- ----------------------------

DROP TABLE IF EXISTS `itemsnewscategory`;

CREATE TABLE `itemsnewscategory` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsorganizecategory

-- ----------------------------

DROP TABLE IF EXISTS `itemsorganizecategory`;

CREATE TABLE `itemsorganizecategory` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsparty

-- ----------------------------

DROP TABLE IF EXISTS `itemsparty`;

CREATE TABLE `itemsparty` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemspriority

-- ----------------------------

DROP TABLE IF EXISTS `itemspriority`;

CREATE TABLE `itemspriority` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsrolecategory

-- ----------------------------

DROP TABLE IF EXISTS `itemsrolecategory`;

CREATE TABLE `itemsrolecategory` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemssecuritylevel

-- ----------------------------

DROP TABLE IF EXISTS `itemssecuritylevel`;

CREATE TABLE `itemssecuritylevel` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemssystem

-- ----------------------------

DROP TABLE IF EXISTS `itemssystem`;

CREATE TABLE `itemssystem` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`LogonUrl` varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(11) NOT NULL DEFAULT '',

`AllowEdit` smallint(11) NOT NULL DEFAULT '',

`AllowDelete` smallint(11) NOT NULL DEFAULT '',

`IsPublic` smallint(11) NOT NULL DEFAULT '',

`DeletionStateCode` smallint(11) NOT NULL DEFAULT '',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemstablepermissionscope

-- ----------------------------

DROP TABLE IF EXISTS `itemstablepermissionscope`;

CREATE TABLE `itemstablepermissionscope` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemstitle

-- ----------------------------

DROP TABLE IF EXISTS `itemstitle`;

CREATE TABLE `itemstitle` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsunits

-- ----------------------------

DROP TABLE IF EXISTS `itemsunits`;

CREATE TABLE `itemsunits` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsworkcategory

-- ----------------------------

DROP TABLE IF EXISTS `itemsworkcategory`;

CREATE TABLE `itemsworkcategory` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsworkflowactivitycategories

-- ----------------------------

DROP TABLE IF EXISTS `itemsworkflowactivitycategories`;

CREATE TABLE `itemsworkflowactivitycategories` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsworkflowactivityname

-- ----------------------------

DROP TABLE IF EXISTS `itemsworkflowactivityname`;

CREATE TABLE `itemsworkflowactivityname` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsworkflowcategories

-- ----------------------------

DROP TABLE IF EXISTS `itemsworkflowcategories`;

CREATE TABLE `itemsworkflowcategories` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsworkingproperty

-- ----------------------------

DROP TABLE IF EXISTS `itemsworkingproperty`;

CREATE TABLE `itemsworkingproperty` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsworkstatus

-- ----------------------------

DROP TABLE IF EXISTS `itemsworkstatus`;

CREATE TABLE `itemsworkstatus` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for itemsyesno

-- ----------------------------

DROP TABLE IF EXISTS `itemsyesno`;

CREATE TABLE `itemsyesno` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`ParentId` int(11) DEFAULT NULL,

`ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '公开标记',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for presalemodule

-- ----------------------------

DROP TABLE IF EXISTS `presalemodule`;

CREATE TABLE `presalemodule` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT 'UUID主键',

`ParentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '父节点主键',

`Code` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '编号',

`FullName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',

`CategoryCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT 'Application' COMMENT '分类',

`ImagUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图标图片地址',

`ImageIndex` smallint(6) DEFAULT NULL COMMENT '图标编号',

`SelectedImageIndex` smallint(6) DEFAULT NULL COMMENT '选中状态图标编号',

`NavigateUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '导航地址',

`Target` varchar(200) COLLATE utf8_unicode_ci DEFAULT 'fraContent' COMMENT '目标窗体中打开',

`WebBrowser` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '浏览器',

`FormName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '窗体名',

`AssemblyName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '动态连接库',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标志',

`IsMenu` smallint(6) DEFAULT '' COMMENT '是菜单项',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '是公开',

`Expand` smallint(6) NOT NULL DEFAULT '' COMMENT '展开状态',

`IsScope` smallint(6) NOT NULL DEFAULT '' COMMENT '权限域（需要数据权限）',

`IsVisible` smallint(6) NOT NULL DEFAULT '' COMMENT '是可见',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`LastCall` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最后被调用日期',

`AuthorizedDays` int(11) NOT NULL DEFAULT '' COMMENT '默认授权天数、默认多少天有数、0表示无限制',

`Description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------

-- Table structure for presalepermission

-- ----------------------------

DROP TABLE IF EXISTS `presalepermission`;

CREATE TABLE `presalepermission` (

`Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',

`ResourceCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资料类别',

`ResourceId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源主键',

`PermissionId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限（菜单模块）主键',

`CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '公司主键',

`CompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '公司名称',

`PermissionConstraint` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限条件限制',

`Enabled` smallint(6) DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`),

KEY `Permission` (`ResourceCategory`,`ResourceId`,`PermissionId`,`Enabled`,`DeletionStateCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------

-- Table structure for presalerole

-- ----------------------------

DROP TABLE IF EXISTS `presalerole`;

CREATE TABLE `presalerole` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT 'UUID主键',

`OrganizeId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '组织机构主键',

`Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色编号',

`RealName` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色名称',

`CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '分类',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsVisible` smallint(6) NOT NULL DEFAULT '' COMMENT '可显示',

`SortCode` int(11) DEFAULT '' COMMENT '排序码',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------

-- Table structure for presaleuserrole

-- ----------------------------

DROP TABLE IF EXISTS `presaleuserrole`;

CREATE TABLE `presaleuserrole` (

`Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',

`UserId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '用户主键',

`CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`RoleId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '角色主键',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime NOT NULL COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`),

KEY `userid` (`UserId`) USING BTREE,

KEY `roleid` (`RoleId`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------

-- Table structure for smssentlog

-- ----------------------------

DROP TABLE IF EXISTS `smssentlog`;

CREATE TABLE `smssentlog` (

`Id` bigint(20) NOT NULL DEFAULT '',

`Channel` smallint(6) DEFAULT NULL,

`SystemCode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyId` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyCode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`CompanyName` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`UserId` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`UserCode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`UserName` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`AccountCode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`ApplicationCode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`MessageID` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`MessageContent` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,

`MessageCode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`ExtendCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`DestinationAddress` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CustomerName` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

`SendType` int(11) DEFAULT NULL,

`SendTime` datetime DEFAULT NULL,

`IsWapPush` int(255) DEFAULT NULL,

`MessageCount` smallint(6) DEFAULT NULL,

`WapUrl` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateTime` datetime DEFAULT NULL,

`GatawayStatus` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`),

KEY `Company_User_Address` (`CompanyId`,`UserId`,`DestinationAddress`) USING BTREE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for systemparameter

-- ----------------------------

DROP TABLE IF EXISTS `systemparameter`;

CREATE TABLE `systemparameter` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ParameterId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ParameterCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ParameterContent` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL,

`Worked` smallint(11) NOT NULL DEFAULT '',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------

-- Table structure for test_area

-- ----------------------------

DROP TABLE IF EXISTS `test_area`;

CREATE TABLE `test_area` (

`Id` int(11) NOT NULL,

`ParentId` int(11) DEFAULT NULL,

`Name` varchar(20) NOT NULL,

`QuickQuery` varchar(20) NOT NULL,

`SimpleSpelling` varchar(20) NOT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Table structure for test_items

-- ----------------------------

DROP TABLE IF EXISTS `test_items`;

CREATE TABLE `test_items` (

`Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',

`ParentId` int(11) DEFAULT NULL COMMENT '父节点主键',

`Code` varchar(200) COLLATE utf8_unicode_ci NOT NULL COMMENT '编号',

`FullName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',

`TargetTable` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '目标存储表',

`IsTree` smallint(6) NOT NULL DEFAULT '' COMMENT '树型结构',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for test_module

-- ----------------------------

DROP TABLE IF EXISTS `test_module`;

CREATE TABLE `test_module` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'UUID主键',

`ParentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '父节点主键',

`Code` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '编号',

`FullName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',

`CategoryCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT 'Application' COMMENT '分类',

`ImagUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图标图片地址',

`ImageIndex` smallint(6) DEFAULT NULL COMMENT '图标编号',

`SelectedImageIndex` smallint(6) DEFAULT NULL COMMENT '选中状态图标编号',

`NavigateUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '导航地址',

`Target` varchar(200) COLLATE utf8_unicode_ci DEFAULT 'fraContent' COMMENT '目标窗体中打开',

`WebBrowser` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '浏览器',

`FormName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '窗体名',

`AssemblyName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '动态连接库',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标志',

`IsMenu` smallint(6) DEFAULT '' COMMENT '是菜单项',

`IsPublic` smallint(6) NOT NULL DEFAULT '' COMMENT '是公开',

`Expand` smallint(6) NOT NULL DEFAULT '' COMMENT '展开状态',

`IsScope` smallint(6) NOT NULL DEFAULT '' COMMENT '权限域（需要数据权限）',

`IsVisible` smallint(6) NOT NULL DEFAULT '' COMMENT '是可见',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`LastCall` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最后被调用日期',

`AuthorizedDays` int(11) NOT NULL DEFAULT '' COMMENT '默认授权天数、默认多少天有数、0表示无限制',

`Description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for test_organizescope

-- ----------------------------

DROP TABLE IF EXISTS `test_organizescope`;

CREATE TABLE `test_organizescope` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '自增主键',

`ResourceCategory` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么类型的',

`ResourceId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么资源主键',

`PermissionId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '有什么权限（模块菜单）主键',

`AllData` smallint(6) DEFAULT '' COMMENT '全部数据',

`Province` smallint(6) DEFAULT '' COMMENT '所在省',

`City` smallint(6) DEFAULT '' COMMENT '所在市',

`District` smallint(6) DEFAULT '' COMMENT '所在区/县',

`Street` smallint(6) DEFAULT '' COMMENT '所在街道',

`UserCompany` smallint(6) DEFAULT '' COMMENT '用户所在公司的数据',

`UserSubCompany` smallint(6) DEFAULT '' COMMENT '用户所在分公司的数据',

`UserDepartment` smallint(6) DEFAULT '' COMMENT '用户所在部门的数据',

`UserSubDepartment` smallint(6) DEFAULT '' COMMENT '用户所在子部门的数据',

`UserWorkgroup` smallint(6) DEFAULT '' COMMENT '用户所在工作组的数据',

`OnlyOwnData` smallint(6) NOT NULL DEFAULT '' COMMENT '仅仅用户自己的数据',

`NotAllowed` smallint(6) DEFAULT '' COMMENT '不允许查看数据',

`ByDetails` smallint(6) DEFAULT '' COMMENT '按明细设置',

`ContainChild` smallint(6) NOT NULL DEFAULT '' COMMENT '包含子节点的数据',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标示',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for test_permission

-- ----------------------------

DROP TABLE IF EXISTS `test_permission`;

CREATE TABLE `test_permission` (

`Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',

`ResourceCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资料类别',

`ResourceId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源主键',

`PermissionId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限（菜单模块）主键',

`CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '公司主键',

`CompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '公司名称',

`PermissionConstraint` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限条件限制',

`Enabled` smallint(6) DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT NULL COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT NULL COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for test_permissionscope

-- ----------------------------

DROP TABLE IF EXISTS `test_permissionscope`;

CREATE TABLE `test_permissionscope` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '自增主键',

`ResourceCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么类型的',

`ResourceId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么资源主键',

`TargetCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '对什么类型的',

`TargetId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '对什么资源主键',

`PermissionId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '有什么权限（模块菜单）主键',

`ContainChild` smallint(6) NOT NULL DEFAULT '' COMMENT '包含子节点',

`PermissionConstraint` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '有什么权限约束表达式',

`StartDate` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '开始生效日期',

`EndDate` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '结束生效日期',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for test_role

-- ----------------------------

DROP TABLE IF EXISTS `test_role`;

CREATE TABLE `test_role` (

`Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '主键',

`OrganizeId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '组织机构主键',

`Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色编号',

`RealName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色名称',

`CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '分类',

`AllowEdit` smallint(6) NOT NULL DEFAULT '' COMMENT '允许编辑',

`AllowDelete` smallint(6) NOT NULL DEFAULT '' COMMENT '允许删除',

`IsVisible` smallint(6) NOT NULL DEFAULT '' COMMENT '可显示',

`SortCode` int(11) DEFAULT NULL COMMENT '排序码',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for test_roleorganize

-- ----------------------------

DROP TABLE IF EXISTS `test_roleorganize`;

CREATE TABLE `test_roleorganize` (

`Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',

`RoleId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '角色主键',

`OrganizeId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '组织机构主键',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime NOT NULL COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Table structure for test_userrole

-- ----------------------------

DROP TABLE IF EXISTS `test_userrole`;

CREATE TABLE `test_userrole` (

`Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',

`UserId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '用户主键',

`CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,

`RoleId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '角色主键',

`Enabled` smallint(6) NOT NULL DEFAULT '' COMMENT '有效标志',

`DeletionStateCode` smallint(6) NOT NULL DEFAULT '' COMMENT '删除标记',

`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',

`CreateOn` datetime NOT NULL COMMENT '创建日期',

`CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',

`CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',

`ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',

`ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',

`ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB AUTO_INCREMENT=449 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TRIGGER IF EXISTS `TR_BaseCommentId`;

DELIMITER ;;

CREATE TRIGGER `TR_BaseCommentId` BEFORE INSERT ON `basecomment` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_BaseContactId`;

DELIMITER ;;

CREATE TRIGGER `TR_BaseContactId` BEFORE INSERT ON `basecontact` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_BaseContactDetailsId`;

DELIMITER ;;

CREATE TRIGGER `TR_BaseContactDetailsId` BEFORE INSERT ON `basecontactdetails` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_BaseExceptionId`;

DELIMITER ;;

CREATE TRIGGER `TR_BaseExceptionId` BEFORE INSERT ON `baseexception` FOR EACH ROW if(NEW.LogId='' or NEW.LogId is null) then set NEW.LogId = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_BaseFolderId`;

DELIMITER ;;

CREATE TRIGGER `TR_BaseFolderId` BEFORE INSERT ON `basefolder` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_BaseKnowledgeId`;

DELIMITER ;;

CREATE TRIGGER `TR_BaseKnowledgeId` BEFORE INSERT ON `baseknowledge` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_BaseModule`;

DELIMITER ;;

CREATE TRIGGER `TR_BaseModule` BEFORE INSERT ON `basemodule` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_BaseNewsId`;

DELIMITER ;;

CREATE TRIGGER `TR_BaseNewsId` BEFORE INSERT ON `basenews` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_BaseParameterId`;

DELIMITER ;;

CREATE TRIGGER `TR_BaseParameterId` BEFORE INSERT ON `baseparameter` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_BaseSequenceId`;

DELIMITER ;;

CREATE TRIGGER `TR_BaseSequenceId` BEFORE INSERT ON `basesequence` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_BaseStaffOrganizeId`;

DELIMITER ;;

CREATE TRIGGER `TR_BaseStaffOrganizeId` BEFORE INSERT ON `basestafforganize` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_BaseUserLogOnId`;

DELIMITER ;;

CREATE TRIGGER `TR_BaseUserLogOnId` BEFORE INSERT ON `baseuserlogon` FOR EACH ROW if(NEW.OpenId='' or NEW.OpenId is null) then set NEW.OpenId = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_BusinessCardId`;

DELIMITER ;;

CREATE TRIGGER `TR_BusinessCardId` BEFORE INSERT ON `businesscard` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_presaleModule`;

DELIMITER ;;

CREATE TRIGGER `TR_presaleModule` BEFORE INSERT ON `presalemodule` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_presaleRole`;

DELIMITER ;;

CREATE TRIGGER `TR_presaleRole` BEFORE INSERT ON `presalerole` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `TR_module`;

DELIMITER ;;

CREATE TRIGGER `TR_module` BEFORE INSERT ON `test_module` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if

;;

DELIMITER ;