用户中心mysql数据库表结构的脚本

/*
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 '0' COMMENT '整体',
`Send` smallint(1) NOT NULL DEFAULT '0' COMMENT '发送',
`Receive` smallint(1) NOT NULL DEFAULT '0',
`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 '0',
`AllowToPay` int(11) NOT NULL DEFAULT '0',
`MaxToPayment` int(11) NOT NULL DEFAULT '0',
`AllowGoodsPay` int(11) NOT NULL DEFAULT '0',
`MaxGoodsPayment` int(11) NOT NULL DEFAULT '0',
`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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(1) NOT NULL DEFAULT '0',
`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
`DelayDay` int(2) NOT NULL DEFAULT '0',
`Opening` smallint(1) NOT NULL DEFAULT '0',
`PrintMark` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`Statistics` smallint(1) NOT NULL DEFAULT '1',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0',
`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 '0' COMMENT '删除标记',
`Enabled` smallint(6) NOT NULL DEFAULT '1' 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 '0',
`ReadCount` int(11) DEFAULT '0',
`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 '0' COMMENT '删除标记',
`Enabled` smallint(6) NOT NULL DEFAULT '1' 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 '0',
`NewComment` int(11) NOT NULL DEFAULT '0',
`LastViewIP` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
`LastViewDate` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
`Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0' COMMENT '删除标记',
`Enabled` smallint(6) NOT NULL DEFAULT '1' 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 '0',
`FileSize` int(11) NOT NULL DEFAULT '0',
`Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` int(11) DEFAULT '0',
`Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0' COMMENT '删除标记',
`Enabled` smallint(6) NOT NULL DEFAULT '1' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`SortCode` int(11) DEFAULT NULL COMMENT '排序码',
`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0' COMMENT '树型结构',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0',
`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 '0' COMMENT '删除标记',
`Enabled` smallint(6) NOT NULL DEFAULT '1' 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 '0',
`ReadCount` int(11) NOT NULL DEFAULT '0',
`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 '0' COMMENT '删除标记',
`Enabled` smallint(6) NOT NULL DEFAULT '1' 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 '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标志',
`IsMenu` smallint(6) DEFAULT '0' COMMENT '是菜单项',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '是公开',
`Expand` smallint(6) NOT NULL DEFAULT '0' COMMENT '展开状态',
`IsScope` smallint(6) NOT NULL DEFAULT '0' COMMENT '权限域（需要数据权限）',
`IsVisible` smallint(6) NOT NULL DEFAULT '1' COMMENT '是可见',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`LastCall` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最后被调用日期',
`AuthorizedDays` smallint(11) NOT NULL DEFAULT '0' 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 '0',
`FileSize` int(11) NOT NULL DEFAULT '0',
`ImageUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
`HomePage` int(11) DEFAULT '0',
`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 '1' COMMENT '有效标志',
`SortCode` int(11) DEFAULT NULL COMMENT '排序码',
`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0',
`Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0',
`IsInnerOrganize` int(11) NOT NULL DEFAULT '0',
`SendAir` int(11) DEFAULT '0',
`CalculateComeFee` int(11) DEFAULT '0',
`CalculateReceiveFee` int(11) DEFAULT '0',
`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 '0' COMMENT '删除标记',
`Enabled` smallint(6) NOT NULL DEFAULT '1' 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 '0',
`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 '0' COMMENT '全部数据',
`Province` smallint(6) DEFAULT '0' COMMENT '所在省',
`City` smallint(6) DEFAULT '0' COMMENT '所在市',
`District` smallint(6) DEFAULT '0' COMMENT '所在区/县',
`Street` smallint(6) DEFAULT '0' COMMENT '所在街道',
`UserCompany` smallint(6) DEFAULT '0' COMMENT '用户所在公司的数据',
`UserSubCompany` smallint(6) DEFAULT '0' COMMENT '用户所在分公司的数据',
`UserDepartment` smallint(6) DEFAULT '0' COMMENT '用户所在部门的数据',
`UserSubDepartment` smallint(6) DEFAULT '0' COMMENT '用户所在子部门的数据',
`UserWorkgroup` smallint(6) DEFAULT '0' COMMENT '用户所在工作组的数据',
`OnlyOwnData` smallint(6) NOT NULL DEFAULT '1' COMMENT '仅仅用户自己的数据',
`NotAllowed` smallint(6) DEFAULT '0' COMMENT '不允许查看数据',
`ByDetails` smallint(6) DEFAULT '0' COMMENT '按明细设置',
`ContainChild` smallint(6) NOT NULL DEFAULT '0' COMMENT '包含子节点的数据',
`Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标示',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0',
`Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0' 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 '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsVisible` smallint(6) NOT NULL DEFAULT '1' COMMENT '可显示',
`SortCode` int(11) DEFAULT NULL COMMENT '排序码',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
`Enabled` smallint(6) NOT NULL DEFAULT '1' 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 '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsVisible` smallint(6) NOT NULL DEFAULT '1' COMMENT '可显示',
`SortCode` int(11) DEFAULT NULL COMMENT '排序码',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
`Enabled` smallint(6) NOT NULL DEFAULT '1' 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 '10000000',
`Reduction` int(11) NOT NULL DEFAULT '9999999',
`Step` int(11) NOT NULL DEFAULT '0',
`IsVisible` int(11) NOT NULL DEFAULT '0',
`Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT '0',
`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 '1' 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 '0' COMMENT '公开标记',
`ColumnAccess` int(11) DEFAULT '0',
`ColumnEdit` int(11) DEFAULT '0',
`ColumnDeney` int(11) DEFAULT '0',
`UseConstraint` int(11) NOT NULL DEFAULT '0',
`DataType` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`TargetTable` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
`Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0',
`IsVisible` smallint(1) NOT NULL DEFAULT '0',
`IsAdministrator` smallint(1) DEFAULT '0',
`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 '0',
`AuditStatus` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`Enabled` smallint(1) DEFAULT '0',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0',
`Mobile` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`MobileValiated` smallint(11) DEFAULT '0',
`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 '0',
`YiXin` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`YiXinValiated` smallint(1) NOT NULL DEFAULT '0',
`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 '0' COMMENT '用户金额',
`Rate` int(11) NOT NULL DEFAULT '0' COMMENT '费率',
`Category` int(1) NOT NULL DEFAULT '0' 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 '0',
`Salt` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`OpenIdTimeout` datetime DEFAULT NULL,
`MultiUserLogin` smallint(11) DEFAULT '0',
`ShowCount` int(11) NOT NULL DEFAULT '0',
`PasswordErrorCount` smallint(11) NOT NULL DEFAULT '0',
`UserOnLine` smallint(11) NOT NULL DEFAULT '0',
`CheckIPAddress` smallint(11) NOT NULL DEFAULT '0',
`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 '1',
`NeedModifyPassword` smallint(11) DEFAULT '0',
`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 '0',
`DeletionStateCode` smallint(1) DEFAULT '0',
`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 '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0' COMMENT '删除标记',
`Enabled` smallint(6) NOT NULL DEFAULT '1' 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 '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0' COMMENT '公开标记',
`Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`SortCode` int(11) DEFAULT NULL COMMENT '排序码',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`SortCode` int(11) DEFAULT NULL COMMENT '排序码',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`SortCode` int(11) DEFAULT NULL COMMENT '排序码',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`SortCode` int(11) DEFAULT NULL COMMENT '排序码',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0',
`AllowEdit` smallint(11) NOT NULL DEFAULT '0',
`AllowDelete` smallint(11) NOT NULL DEFAULT '0',
`IsPublic` smallint(11) NOT NULL DEFAULT '0',
`DeletionStateCode` smallint(11) NOT NULL DEFAULT '0',
`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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`SortCode` int(11) DEFAULT NULL COMMENT '排序码',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标志',
`IsMenu` smallint(6) DEFAULT '0' COMMENT '是菜单项',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '是公开',
`Expand` smallint(6) NOT NULL DEFAULT '0' COMMENT '展开状态',
`IsScope` smallint(6) NOT NULL DEFAULT '0' COMMENT '权限域（需要数据权限）',
`IsVisible` smallint(6) NOT NULL DEFAULT '1' COMMENT '是可见',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`LastCall` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最后被调用日期',
`AuthorizedDays` int(11) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsVisible` smallint(6) NOT NULL DEFAULT '1' COMMENT '可显示',
`SortCode` int(11) DEFAULT '0' COMMENT '排序码',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
`Enabled` smallint(6) NOT NULL DEFAULT '1' 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 '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0',
`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 '0',
`Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0' COMMENT '树型结构',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标志',
`IsMenu` smallint(6) DEFAULT '0' COMMENT '是菜单项',
`IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '是公开',
`Expand` smallint(6) NOT NULL DEFAULT '0' COMMENT '展开状态',
`IsScope` smallint(6) NOT NULL DEFAULT '0' COMMENT '权限域（需要数据权限）',
`IsVisible` smallint(6) NOT NULL DEFAULT '1' COMMENT '是可见',
`AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`LastCall` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最后被调用日期',
`AuthorizedDays` int(11) NOT NULL DEFAULT '0' 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 '0' COMMENT '全部数据',
`Province` smallint(6) DEFAULT '0' COMMENT '所在省',
`City` smallint(6) DEFAULT '0' COMMENT '所在市',
`District` smallint(6) DEFAULT '0' COMMENT '所在区/县',
`Street` smallint(6) DEFAULT '0' COMMENT '所在街道',
`UserCompany` smallint(6) DEFAULT '0' COMMENT '用户所在公司的数据',
`UserSubCompany` smallint(6) DEFAULT '0' COMMENT '用户所在分公司的数据',
`UserDepartment` smallint(6) DEFAULT '0' COMMENT '用户所在部门的数据',
`UserSubDepartment` smallint(6) DEFAULT '0' COMMENT '用户所在子部门的数据',
`UserWorkgroup` smallint(6) DEFAULT '0' COMMENT '用户所在工作组的数据',
`OnlyOwnData` smallint(6) NOT NULL DEFAULT '1' COMMENT '仅仅用户自己的数据',
`NotAllowed` smallint(6) DEFAULT '0' COMMENT '不允许查看数据',
`ByDetails` smallint(6) DEFAULT '0' COMMENT '按明细设置',
`ContainChild` smallint(6) NOT NULL DEFAULT '0' COMMENT '包含子节点的数据',
`Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标示',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '0' 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 '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '允许编辑',
`AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
`IsVisible` smallint(6) NOT NULL DEFAULT '1' COMMENT '可显示',
`SortCode` int(11) DEFAULT NULL COMMENT '排序码',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
`Enabled` smallint(6) NOT NULL DEFAULT '1' 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 '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 '1' COMMENT '有效标志',
`DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' 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 ;

这是最新的用户中心的mysql数据库表结构脚本，直接可以运行的。

执行都是成功的。

下面是区域表的数据写入脚本

执行也是可以的。

下载：http://files.cnblogs.com/files/wohexiaocai/%E7%9C%81%E5%B8%82%E5%8C%BAMysql%E7%89%88%E6%9C%AC.zip

这是自己平时工作一点点的随笔记录，就不放在首页了，用心做好每件事情不容易

很多问题不见得会出在你身上，但你亦需要想法解决问题，否则就会变成你的问题。