数据结构

12144

表总览

普通表

_cache

• 缓存表

CREATE TABLE `_cache` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` varchar(255) NOT NULL COMMENT '用户Id',
  `content` longtext COMMENT '缓存数据',
  `recordStatus` varchar(255) DEFAULT 'active',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '缓存表'

_constant

• 常量表; 软删除未启用;

CREATE TABLE `_constant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `constantKey` varchar(255) DEFAULT NULL,
  `constantType` varchar(255) DEFAULT NULL COMMENT '常量类型; object, array',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `constantValue` text COMMENT '常量内容; object, array',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '常量表; 软删除未启用;'

_constant_ui

• 常量表;

CREATE TABLE `_constant_ui` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `constantKey` varchar(255) DEFAULT NULL,
  `constantType` varchar(255) DEFAULT NULL COMMENT '常量类型; object, array',
  `pageId` varchar(255) DEFAULT 'all' COMMENT '页面id',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `en` text COMMENT '常量内容; object, array',
  `zh` text COMMENT '常量内容; object, array',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `pageId_constantKey_unique` (`constantKey`, `pageId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8mb4 COMMENT = '常量表;'

_page

• 页面表; 软删除未启用;

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255) DEFAULT NULL COMMENT 'pageId',
  `pageFile` varchar(255) DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  `pageName` varchar(255) DEFAULT NULL COMMENT 'page name',
  `pageType` varchar(255) DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `pageIcon` longtext COMMENT '页面icon，svg格式',
  `sort` varchar(255) DEFAULT NULL,
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  `pageHook` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 45 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '页面表; 软删除未启用;'

_record_history

• 数据历史表

CREATE TABLE `_record_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `table` varchar(255) DEFAULT NULL COMMENT '表',
  `recordId` int(11) DEFAULT NULL COMMENT '数据在table中的主键id; recordContent.id',
  `recordContent` text NOT NULL COMMENT '数据',
  `packageContent` text NOT NULL COMMENT '当时请求的 package JSON',
  `operation` varchar(255) DEFAULT NULL COMMENT '操作; jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId; recordContent.operationByUserId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名; recordContent.operationByUser',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; recordContent.operationAt; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_record_id` (`recordId`) USING BTREE,
  KEY `index_table_action` (`table`, `operation`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 186 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '数据历史表'

_resource

• 请求资源表; 软删除未启用; resourceId=${appId}.${pageId}.${actionId}

CREATE TABLE `_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accessControlTable` varchar(255) DEFAULT NULL COMMENT '数据规则控制表',
  `resourceHook` text COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',
  `pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',
  `actionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `resourceType` varchar(255) DEFAULT NULL COMMENT 'resource 类型; E.g: auth service sql',
  `appDataSchema` text COMMENT 'appData 参数校验',
  `resourceData` text COMMENT 'resource 数据; { "service": "auth", "serviceFunction": "passwordLogin" } or  { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
  `requestDemo` text COMMENT '请求Demo',
  `responseDemo` text COMMENT '响应Demo',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 555 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'

_test_case

• 测试用例表

CREATE TABLE `_test_case` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255) DEFAULT NULL COMMENT '页面Id',
  `testId` varchar(255) DEFAULT NULL COMMENT '测试用例Id; 10000 ++',
  `testName` varchar(255) DEFAULT NULL COMMENT '测试用例名',
  `uiActionIdList` varchar(255) DEFAULT NULL COMMENT 'uiAction列表; 一个测试用例对应多个uiActionId',
  `testOpeartion` text COMMENT '测试用例步骤;',
  `expectedResult` text COMMENT '期望结果',
  `operation` varchar(255) DEFAULT NULL COMMENT '操作; jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId; recordContent.operationByUserId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名; recordContent.operationByUser',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; recordContent.operationAt; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '测试用例表'

_ui

• ui 施工方案

CREATE TABLE `_ui` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',
  `uiActionType` varchar(255) DEFAULT NULL COMMENT 'ui 动作类型，如：fetchData, postData, changeUi',
  `uiActionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  `uiActionConfig` text COMMENT 'ui 动作数据',
  `appDataSchema` text COMMENT 'ui 校验数据',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = 'ui 施工方案'

_user

• 用户表

CREATE TABLE `_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` varchar(255) DEFAULT NULL COMMENT '主键id',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名(登陆)',
  `clearTextPassword` varchar(255) DEFAULT NULL COMMENT '明文密码',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `md5Salt` varchar(255) DEFAULT NULL COMMENT 'md5Salt',
  `userStatus` varchar(255) DEFAULT 'active' COMMENT '用户账号状态：活跃或关闭',
  `userType` varchar(255) DEFAULT NULL COMMENT '用户类型; staff, student.',
  `config` mediumtext COMMENT '配置信息',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `username_index` (`username`) USING BTREE,
  UNIQUE KEY `userId_index` (`userId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '用户表'

_user_session

• 用户session表; deviceId 维度;软删除未启用;

CREATE TABLE `_user_session` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` varchar(255) DEFAULT NULL COMMENT '用户id',
  `userIp` varchar(255) DEFAULT NULL COMMENT '用户ip',
  `userIpRegion` varchar(255) DEFAULT NULL COMMENT '用户Ip区域',
  `userAgent` text COMMENT '请求的 agent',
  `deviceId` varchar(255) DEFAULT NULL COMMENT '设备id',
  `deviceType` varchar(255) DEFAULT 'web' COMMENT '设备类型; flutter, web, bot_databot, bot_chatbot, bot_xiaochengxu',
  `socketStatus` varchar(255) DEFAULT 'offline' COMMENT 'socket状态',
  `authToken` varchar(255) DEFAULT NULL COMMENT 'auth token',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `userId_index` (`userId`) USING BTREE,
  KEY `userId_deviceId_index` (`userId`, `deviceId`) USING BTREE,
  KEY `authToken_index` (`authToken`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 43 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '用户session表; deviceId 维度;软删除未启用;'

activity

• 活动记录表

CREATE TABLE `activity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `activityId` varchar(255) NOT NULL COMMENT '活动id; HD10000x',
  `activityType` varchar(255) NOT NULL COMMENT '活动类型; 跟进记录、商机阶段变更',
  `activityMethod` varchar(255) NOT NULL COMMENT '跟进方式;见面拜访、电话',
  `activityTarget` varchar(255) NOT NULL COMMENT '活动对象; 1 线索 2 客户 3 联系人 4 产品 5 商机 6 合同 7回款 8日志 9审批 10日程 11任务 12 发邮件',
  `activityTargetId` varchar(255) NOT NULL COMMENT '活动对象Id',
  `content` varchar(1024) DEFAULT NULL COMMENT '活动内容;',
  `nextTime` datetime DEFAULT NULL COMMENT '下次联系时间;',
  `address` varchar(255) DEFAULT NULL COMMENT '签到地址;',
  `businessIdList` varchar(255) DEFAULT NULL COMMENT '关联商机;',
  `contactsIdList` varchar(255) DEFAULT NULL COMMENT '关联联系人;',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_marketing_marketingId` (`activityId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '活动记录表'

amount_proportion

• 金额比例表

CREATE TABLE `amount_proportion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `targetType` varchar(255) NOT NULL COMMENT '类型; 商机、合同、回款',
  `targetId` varchar(255) NOT NULL COMMENT '业务Id; 商机ID、合同Id、回款Id',
  `userId` varchar(255) NOT NULL COMMENT '分配对象ID',
  `user` varchar(255) NOT NULL COMMENT '分配对象',
  `commissionRate` decimal(10, 2) DEFAULT NULL COMMENT '提成比例',
  `coefficient` decimal(17, 2) DEFAULT NULL COMMENT '系数',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_business_businessId` (`targetId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '金额比例表'

business

• 商机表

CREATE TABLE `business` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `customerId` varchar(255) NOT NULL COMMENT '客户ID',
  `customerName` varchar(255) DEFAULT NULL COMMENT '客户名称',
  `businessId` varchar(255) NOT NULL COMMENT '商机ID; SJ10000x',
  `businessName` varchar(255) NOT NULL DEFAULT '' COMMENT '商机名称',
  `money` decimal(18, 2) DEFAULT NULL COMMENT '商机金额',
  `discountRate` decimal(10, 2) DEFAULT NULL COMMENT '整单折扣',
  `productTotalPrice` decimal(17, 2) DEFAULT NULL COMMENT '产品总金额',
  `expireDealDate` datetime DEFAULT NULL COMMENT '预计成交日期',
  `status` varchar(255) DEFAULT NULL COMMENT '状态; 赢单、输单、无效',
  `statusRemark` varchar(255) DEFAULT NULL,
  `businessTypeId` varchar(255) DEFAULT NULL COMMENT '商机组',
  `businessTypeName` varchar(255) DEFAULT NULL COMMENT '商机状态组名称',
  `stage` varchar(255) DEFAULT NULL COMMENT '商机阶段; 验证客户、需求分析、方案/报价',
  `primaryContactId` varchar(255) DEFAULT NULL COMMENT '首要联系人ID',
  `contactsId` varchar(255) DEFAULT NULL COMMENT '联系人ID;用,分隔',
  `ownerUserId` varchar(255) DEFAULT NULL COMMENT '负责人ID',
  `ownerUser` varchar(255) DEFAULT NULL COMMENT '负责人',
  `isFollowup` varchar(255) DEFAULT '未跟进' COMMENT '跟进状态; 未跟进、已跟进',
  `lastContent` varchar(1024) DEFAULT NULL COMMENT '最后跟进内容',
  `lastTime` datetime DEFAULT NULL COMMENT '最后跟进时间',
  `nextTime` datetime DEFAULT NULL COMMENT '下次联系时间',
  `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人ID',
  `createUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_business_businessId` (`businessId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '商机表'

business_status

• 商机状态表

CREATE TABLE `business_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `businessTypeId` varchar(255) NOT NULL COMMENT '商机状态组ID; SJZTZ10000x',
  `businessTypeName` varchar(255) NOT NULL DEFAULT '' COMMENT '商机状态组名称',
  `statusId` varchar(255) NOT NULL COMMENT '状态ID; SJZT0000x',
  `statusName` varchar(255) NOT NULL COMMENT '状态名称',
  `rate` varchar(255) DEFAULT NULL COMMENT '赢单率',
  `orderNum` int(11) DEFAULT NULL COMMENT '排序',
  `task` text COMMENT '阶段工作',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_business_businessId` (`businessTypeId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '商机状态表'

business_type

• 商机状态组表

CREATE TABLE `business_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `businessTypeId` varchar(255) NOT NULL COMMENT '商机状态组ID; SJZTZ10000x',
  `businessTypeName` varchar(255) NOT NULL DEFAULT '' COMMENT '商机状态组名称',
  `status` varchar(255) NOT NULL DEFAULT '启用' COMMENT '状态;禁用、启用',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_business_businessId` (`businessTypeId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '商机状态组表'

contacts

• 联系人表

CREATE TABLE `contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id; ',
  `customerId` varchar(255) NOT NULL COMMENT '客户ID',
  `customerName` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '客户名称',
  `contactsId` varchar(255) NOT NULL COMMENT '联系人ID; LHR10000x',
  `name` varchar(255) DEFAULT NULL COMMENT '联系人名称',
  `gender` varchar(255) DEFAULT NULL COMMENT '性别',
  `contactInfo` varchar(255) DEFAULT NULL COMMENT '联系方式;手机、电话',
  `email` varchar(255) DEFAULT NULL COMMENT '电子邮箱',
  `post` varchar(255) DEFAULT NULL COMMENT '职务',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `isKeyDecisionMaker` varchar(255) DEFAULT NULL COMMENT '是否关键决策人;是、否',
  `isFollowup` varchar(255) DEFAULT '未跟进' COMMENT '跟进状态; 未跟进、已跟进',
  `lastContent` varchar(1024) DEFAULT NULL COMMENT '最后跟进内容',
  `lastTime` datetime DEFAULT NULL COMMENT '最后跟进时间',
  `nextTime` datetime DEFAULT NULL COMMENT '下次联系时间',
  `ownerUserId` varchar(255) DEFAULT NULL COMMENT '负责人ID',
  `ownerUser` varchar(255) DEFAULT NULL COMMENT '负责人',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_contacts_contactsId` (`contactsId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '联系人表'

contract

• 合同表

CREATE TABLE `contract` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `customerId` varchar(255) NOT NULL COMMENT '客户ID',
  `customerName` varchar(255) DEFAULT NULL COMMENT '客户名称',
  `businessId` varchar(255) DEFAULT NULL COMMENT '商机ID',
  `contractId` varchar(255) NOT NULL COMMENT '合同ID; HT10000x',
  `contractName` varchar(255) NOT NULL DEFAULT '' COMMENT '合同名称',
  `contractNum` varchar(255) NOT NULL DEFAULT '' COMMENT '合同编号',
  `contractType` varchar(255) NOT NULL DEFAULT '' COMMENT '合同类型; 直销合同、代理合同、服务合同、快销合同',
  `orderDate` datetime DEFAULT NULL COMMENT '下单日期',
  `startTime` datetime DEFAULT NULL COMMENT '开始时间',
  `endTime` datetime DEFAULT NULL COMMENT '结束时间',
  `money` decimal(18, 2) DEFAULT NULL COMMENT '合同金额',
  `receivedMoney` decimal(18, 2) DEFAULT NULL COMMENT '已收款金额',
  `unreceivedMoney` decimal(18, 2) DEFAULT NULL COMMENT '未收款金额',
  `discountRate` decimal(10, 2) DEFAULT NULL COMMENT '整单折扣',
  `productTotalPrice` decimal(17, 2) DEFAULT NULL COMMENT '产品总金额',
  `paymentType` varchar(255) DEFAULT NULL COMMENT '付款方式',
  `businessName` varchar(255) DEFAULT '' COMMENT '商机名称',
  `contractUserId` varchar(255) DEFAULT NULL COMMENT '客户签约人ID',
  `contractUser` varchar(255) DEFAULT NULL COMMENT '客户签约人',
  `companyUserId` varchar(255) DEFAULT NULL COMMENT '公司签约人ID',
  `companyUser` varchar(255) DEFAULT NULL COMMENT '公司签约人',
  `primaryContactId` varchar(255) DEFAULT NULL COMMENT '首要联系人ID',
  `contactsId` varchar(255) DEFAULT NULL COMMENT '联系人ID;用,分隔',
  `ownerUserId` varchar(255) DEFAULT NULL COMMENT '负责人ID',
  `ownerUser` varchar(255) DEFAULT NULL COMMENT '负责人',
  `isFollowup` varchar(255) DEFAULT '未跟进' COMMENT '跟进状态; 未跟进、已跟进',
  `lastContent` varchar(1024) DEFAULT NULL COMMENT '最后跟进内容',
  `lastTime` datetime DEFAULT NULL COMMENT '最后跟进时间',
  `nextTime` datetime DEFAULT NULL COMMENT '下次联系时间',
  `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人ID',
  `createUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `status` varchar(255) NOT NULL DEFAULT '正常' COMMENT '合同状态; 正常、完成、终止、作废',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_contract_contractId` (`contractId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '合同表'

customer

• 客户表

CREATE TABLE `customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `customerId` varchar(255) NOT NULL COMMENT '客户ID; KH10000x',
  `customerName` varchar(255) NOT NULL DEFAULT '' COMMENT '客户名称',
  `customerSource` varchar(255) NOT NULL DEFAULT '' COMMENT '客户来源',
  `telephone` varchar(255) DEFAULT NULL COMMENT '电话',
  `wechat` varchar(255) DEFAULT NULL COMMENT '微信',
  `qq` varchar(255) DEFAULT NULL COMMENT 'QQ',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `website` varchar(255) DEFAULT NULL COMMENT '网址',
  `fax` varchar(255) DEFAULT NULL COMMENT '传真',
  `personnelSize` varchar(255) DEFAULT NULL COMMENT '人员规模',
  `industry` varchar(255) NOT NULL DEFAULT '' COMMENT '客户行业',
  `level` varchar(255) NOT NULL DEFAULT '' COMMENT '客户级别',
  `isLock` varchar(255) DEFAULT '未锁定' COMMENT '锁定状态; 已锁定、未锁定',
  `isDeal` varchar(255) DEFAULT '未成交' COMMENT '成交状态; 已成交、未成交',
  `dealTime` datetime DEFAULT NULL COMMENT '成交时间',
  `isFollowup` varchar(255) DEFAULT '未跟进' COMMENT '跟进状态; 未跟进、已跟进',
  `lastContent` varchar(1024) DEFAULT NULL COMMENT '最后跟进内容',
  `lastTime` datetime DEFAULT NULL COMMENT '最后跟进时间',
  `nextTime` datetime DEFAULT NULL COMMENT '下次联系时间',
  `customerPoolId` varchar(255) DEFAULT NULL COMMENT '公海ID',
  `customerPoolName` varchar(255) DEFAULT NULL COMMENT '公海名称',
  `customerPoolTime` datetime DEFAULT NULL COMMENT '放入公海时间',
  `customerPoolReason` varchar(255) NOT NULL DEFAULT '' COMMENT '放入公海理由',
  `preOwnerUserId` varchar(255) DEFAULT NULL COMMENT '进入公海前负责人id',
  `contactId` varchar(255) DEFAULT NULL COMMENT '首要联系人ID',
  `contactUser` varchar(255) DEFAULT NULL COMMENT '首要联系人',
  `isReceive` varchar(255) DEFAULT '未分配' COMMENT '分配状态; 未分配、已分配、已领取',
  `receiveTime` datetime DEFAULT NULL COMMENT '接收到客户时间',
  `ownerUserId` varchar(255) DEFAULT NULL COMMENT '负责人ID',
  `ownerUser` varchar(255) DEFAULT NULL COMMENT '负责人',
  `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人ID',
  `createUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `status` varchar(255) NOT NULL DEFAULT '正常' COMMENT '客户状态; 正常、删除',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_customer_customerId` (`customerId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '客户表'

customer_address

• 客户地址表

CREATE TABLE `customer_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customerId` varchar(255) NOT NULL COMMENT '客户ID; KH10000x',
  `customerName` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '客户名称',
  `addressType` varchar(255) DEFAULT NULL COMMENT '地址类型',
  `postalCode` varchar(255) DEFAULT NULL COMMENT '邮政编码',
  `userId` varchar(255) DEFAULT NULL COMMENT '联系人ID',
  `user` varchar(255) DEFAULT NULL COMMENT '联系人',
  `contactInfo` varchar(255) DEFAULT NULL COMMENT '联系方式;手机、电话',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `isPrimaryAddress` varchar(255) DEFAULT NULL COMMENT '是否主要地址；是、否',
  `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人ID',
  `createUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '客户地址表'

customer_invoice_headup

• 客户发票抬头表

CREATE TABLE `customer_invoice_headup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customerId` varchar(255) NOT NULL COMMENT '客户ID; KH10000x',
  `customerName` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '客户名称',
  `titleType` varchar(255) DEFAULT NULL COMMENT '抬头类型;单位、个人',
  `invoiceTitle` varchar(255) DEFAULT NULL COMMENT '开票抬头',
  `taxNumber` varchar(255) DEFAULT NULL COMMENT '纳税识别号',
  `depositBank` varchar(255) DEFAULT NULL COMMENT '开户行',
  `depositAccount` varchar(255) DEFAULT NULL COMMENT '开户账户',
  `depositAddress` varchar(255) DEFAULT NULL COMMENT '开票地址',
  `telephone` varchar(255) DEFAULT NULL COMMENT '电话',
  `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人ID',
  `createUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '客户发票抬头表'

customer_pool

• 公海表

CREATE TABLE `customer_pool` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `customerPoolId` varchar(255) NOT NULL COMMENT '公海ID; GH10000x',
  `customerPoolname` varchar(255) NOT NULL DEFAULT '' COMMENT '公海名称',
  `status` varchar(255) NOT NULL DEFAULT '启用' COMMENT '状态; 停用、启用',
  `adminUserIdList` varchar(255) NOT NULL DEFAULT '' COMMENT '公海管理员ID列表; 多个用,分割',
  `adminUserList` varchar(255) NOT NULL DEFAULT '' COMMENT '公海管理员列表; 多个用,分割',
  `memberUserIdList` varchar(255) NOT NULL DEFAULT '' COMMENT '公海成员ID列表; 多个用,分割',
  `memberUserList` varchar(255) NOT NULL DEFAULT '' COMMENT '公海成员列表; 多个用,分割',
  `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人ID',
  `createUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_customer_pool_customerPoolId` (`customerPoolId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '公海表'

invoice

• 发票表

CREATE TABLE `invoice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `customerId` varchar(255) NOT NULL COMMENT '客户ID',
  `customerName` varchar(255) DEFAULT NULL COMMENT '客户名称',
  `contractId` varchar(255) NOT NULL COMMENT '合同ID',
  `contractName` varchar(255) DEFAULT '' COMMENT '合同名称',
  `contractNum` varchar(255) DEFAULT '' COMMENT '合同编号',
  `contractMoney` decimal(18, 2) DEFAULT NULL COMMENT '合同金额',
  `receivablesId` varchar(255) DEFAULT NULL COMMENT '回款ID; HK10000x',
  `receivablesNumber` varchar(255) DEFAULT NULL COMMENT '回款编号',
  `invoiceId` varchar(255) NOT NULL COMMENT '发票id; FP10000x',
  `invoiceApplyNumber` varchar(255) NOT NULL COMMENT '发票申请编号',
  `invoiceDate` date DEFAULT NULL COMMENT '开票日期',
  `invoiceType` varchar(255) NOT NULL COMMENT '开票类型',
  `invoiceStatus` varchar(255) NOT NULL DEFAULT '未开票' COMMENT '开票状态; 未开票、已开票',
  `invoiceMoney` decimal(10, 2) NOT NULL COMMENT '开票金额',
  `titleType` varchar(255) DEFAULT NULL COMMENT '抬头类型;单位、个人',
  `invoiceTitle` varchar(255) NOT NULL COMMENT '开票抬头',
  `taxNumber` varchar(255) NOT NULL COMMENT '纳税识别号',
  `depositBank` varchar(255) NOT NULL COMMENT '开户行',
  `depositAccount` varchar(255) NOT NULL COMMENT '开户账户',
  `depositAddress` varchar(255) NOT NULL COMMENT '开票地址',
  `telephone` varchar(255) NOT NULL COMMENT '电话',
  `contactsName` varchar(255) NOT NULL COMMENT '联系人名称',
  `contactsMobile` varchar(255) NOT NULL COMMENT '联系方式',
  `contactsAddress` varchar(255) NOT NULL COMMENT '邮寄地址',
  `invoiceNumber` varchar(32) DEFAULT NULL COMMENT '发票号码',
  `realInvoiceDate` varchar(255) DEFAULT NULL COMMENT '实际开票日期',
  `logisticsNumber` varchar(255) NOT NULL COMMENT '物流单号',
  `detail` text COMMENT '开票明细',
  `ownerUserId` varchar(255) DEFAULT NULL COMMENT '负责人ID',
  `ownerUser` varchar(255) DEFAULT NULL COMMENT '负责人',
  `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人ID',
  `createUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_invoice_invoiceId` (`invoiceId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '发票表'

leads

• 线索表

CREATE TABLE `leads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `leadsId` varchar(255) NOT NULL COMMENT '线索ID; XS10000x',
  `leadsName` varchar(255) NOT NULL DEFAULT '' COMMENT '线索名称',
  `leadsSource` varchar(255) NOT NULL DEFAULT '' COMMENT '线索来源',
  `telephone` varchar(255) DEFAULT NULL COMMENT '电话',
  `wechat` varchar(255) DEFAULT NULL COMMENT '微信',
  `qq` varchar(255) DEFAULT NULL COMMENT 'QQ',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `industry` varchar(255) DEFAULT NULL COMMENT '客户行业',
  `level` varchar(255) DEFAULT NULL COMMENT '客户级别',
  `isTransform` varchar(255) DEFAULT '未转化' COMMENT '转化状态; 已转化、未转化',
  `customerId` varchar(255) DEFAULT NULL COMMENT '客户id;转化为客户之后产生的',
  `isFollowup` varchar(255) DEFAULT '未跟进' COMMENT '跟进状态; 未跟进、已跟进',
  `lastContent` varchar(1024) DEFAULT NULL COMMENT '最后跟进内容',
  `lastTime` datetime DEFAULT NULL COMMENT '最后跟进时间',
  `nextTime` datetime DEFAULT NULL COMMENT '下次联系时间',
  `isReceive` varchar(255) DEFAULT '未分配' COMMENT '分配状态; 已分配、未分配',
  `ownerUserId` varchar(255) DEFAULT NULL COMMENT '负责人ID',
  `ownerUser` varchar(255) DEFAULT NULL COMMENT '负责人',
  `leadsPoolId` varchar(255) DEFAULT NULL COMMENT '线索池ID;',
  `leadsPoolName` varchar(255) DEFAULT NULL COMMENT '线索池名称; ',
  `leadsPoolReason` varchar(255) DEFAULT NULL COMMENT '移入线索池理由 ',
  `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人ID',
  `createUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_leads_leadsId` (`leadsId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '线索表'

leads_pool

• 线索池表

CREATE TABLE `leads_pool` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `leadsPoolId` varchar(255) NOT NULL COMMENT '线索池ID; XSC10000x',
  `leadsPoolName` varchar(255) NOT NULL DEFAULT '' COMMENT '线索池名称',
  `status` varchar(255) NOT NULL DEFAULT '启用' COMMENT '状态; 停用、启用',
  `adminUserIdList` varchar(255) NOT NULL DEFAULT '' COMMENT '线索池管理员ID列表; 多个用,分割',
  `adminUserList` varchar(255) NOT NULL DEFAULT '' COMMENT '线索池管理员列表; 多个用,分割',
  `memberUserIdList` varchar(255) NOT NULL DEFAULT '' COMMENT '线索池成员ID列表; 多个用,分割',
  `memberUserList` varchar(255) NOT NULL DEFAULT '' COMMENT '线索池成员列表; 多个用,分割',
  `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人ID',
  `createUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_leads_pool_leadsPoolId` (`leadsPoolId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '线索池表'

marketing

• 营销表

CREATE TABLE `marketing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `marketingId` varchar(255) NOT NULL COMMENT '营销id; YX10000x',
  `marketingName` varchar(255) NOT NULL COMMENT '营销名称',
  `marketingType` varchar(255) DEFAULT NULL COMMENT '活动类型',
  `marketingMoney` decimal(11, 2) DEFAULT NULL COMMENT '活动金额',
  `status` varchar(255) NOT NULL DEFAULT '启用' COMMENT '状态; 启用、停用',
  `targetType` varchar(255) NOT NULL DEFAULT '' COMMENT '营销目的类型; 线索、客户',
  `startTime` datetime DEFAULT NULL COMMENT '开始时间',
  `endTime` datetime NOT NULL COMMENT '截止时间',
  `synopsis` longtext COMMENT '简介',
  `address` varchar(255) DEFAULT NULL COMMENT '活动地址',
  `browse` int(11) DEFAULT '0' COMMENT '浏览数',
  `shareNum` int(11) DEFAULT '0' COMMENT '分享数',
  `submitNum` int(11) DEFAULT '0' COMMENT '提交数',
  `mainImage` text COMMENT '活动主图url',
  `detailImage` text COMMENT '活动详情图url',
  `relationUserId` varchar(255) DEFAULT NULL COMMENT '关联人员ID;多个用逗号分隔',
  `relationUser` varchar(255) DEFAULT NULL COMMENT '关联人员',
  `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人ID',
  `createUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_marketing_marketingId` (`marketingId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '营销表'

marketing_data

• 营销数据表

CREATE TABLE `marketing_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `marketingDataId` varchar(255) NOT NULL COMMENT '活动数据ID; HDSJ10000x',
  `customerName` varchar(255) CHARACTER SET utf8  DEFAULT NULL COMMENT '客户名称',
  `customerSource` varchar(255) NOT NULL DEFAULT '' COMMENT '客户来源',
  `telephone` varchar(255) DEFAULT NULL COMMENT '电话',
  `wechat` varchar(255) DEFAULT NULL COMMENT '微信',
  `qq` varchar(255) DEFAULT NULL COMMENT 'QQ',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `industry` varchar(255) NOT NULL DEFAULT '' COMMENT '客户行业',
  `level` varchar(255) NOT NULL DEFAULT '' COMMENT '客户级别',
  `isTransform` varchar(255) DEFAULT '未转化' COMMENT '转化状态; 已转化、未转化',
  `customerId` varchar(255) NOT NULL DEFAULT 'KH10000' COMMENT '客户id;转化为客户之后产生的',
  `nextTime` datetime DEFAULT NULL COMMENT '下次联系时间',
  `submitTime` datetime DEFAULT NULL COMMENT '提交时间',
  `submitAddress` varchar(255) DEFAULT NULL COMMENT '提交地点',
  `ownerUserId` varchar(255) DEFAULT NULL COMMENT '负责人ID',
  `ownerUser` varchar(255) DEFAULT NULL COMMENT '负责人',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_leads_leadsId` (`marketingDataId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '营销数据表'

product

• 产品表

CREATE TABLE `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `productId` varchar(255) NOT NULL COMMENT '产品id; CP10000x',
  `productName` varchar(255) DEFAULT NULL COMMENT '产品名称',
  `productNum` varchar(255) DEFAULT NULL COMMENT '产品编码',
  `status` varchar(255) DEFAULT '上架' COMMENT '状态; 上架、下架',
  `unit` varchar(255) DEFAULT NULL COMMENT '单位',
  `price` decimal(18, 2) DEFAULT '0.00' COMMENT '价格',
  `categoryId` varchar(255) DEFAULT NULL COMMENT '产品分类ID',
  `description` text COMMENT '产品描述',
  `mainImage` text COMMENT '产品主图url',
  `detailImage` text COMMENT '产品详情图url',
  `ownerUserId` varchar(255) DEFAULT NULL COMMENT '负责人ID',
  `ownerUser` varchar(255) DEFAULT NULL COMMENT '负责人',
  `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人ID',
  `createUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_product_productId` (`productId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '产品表'

receivables

• 回款表

CREATE TABLE `receivables` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `customerId` varchar(255) NOT NULL COMMENT '客户ID',
  `customerName` varchar(255) DEFAULT NULL COMMENT '客户名称',
  `contractId` varchar(255) NOT NULL COMMENT '合同ID',
  `receivablesId` varchar(255) DEFAULT NULL COMMENT '回款ID; HK10000x',
  `receivablesNumber` varchar(255) DEFAULT NULL COMMENT '回款编号',
  `returnTime` date DEFAULT NULL COMMENT '回款日期',
  `returnType` varchar(255) DEFAULT NULL COMMENT '回款方式',
  `money` decimal(10, 2) DEFAULT NULL COMMENT '回款金额',
  `detail` text COMMENT '回款明细',
  `receivablesPlanId` varchar(255) DEFAULT NULL COMMENT '回款计划ID',
  `contractName` varchar(255) DEFAULT '' COMMENT '合同名称',
  `contractNum` varchar(255) DEFAULT '' COMMENT '合同编号',
  `contractMoney` decimal(18, 2) DEFAULT NULL COMMENT '合同金额',
  `ownerUserId` varchar(255) DEFAULT NULL COMMENT '负责人ID',
  `ownerUser` varchar(255) DEFAULT NULL COMMENT '负责人',
  `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人ID',
  `createUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_receivables_receivablesId` (`receivablesId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '回款表'

receivables_plan

• 回款计划表

CREATE TABLE `receivables_plan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `customerId` varchar(255) NOT NULL COMMENT '客户ID',
  `customerName` varchar(255) DEFAULT NULL COMMENT '客户名称',
  `contractId` varchar(255) NOT NULL COMMENT '合同ID',
  `contractName` varchar(255) NOT NULL DEFAULT '' COMMENT '合同名称',
  `contractNum` varchar(255) NOT NULL DEFAULT '' COMMENT '合同编号',
  `receivablesPlanId` varchar(255) DEFAULT NULL COMMENT '回款计划ID; HKJH10000x',
  `num` int(11) DEFAULT NULL COMMENT '期数;合同的第几期回款计划，根据contractId的已有回款计划期数自动累加',
  `money` decimal(18, 2) DEFAULT NULL COMMENT '计划回款金额',
  `returnDate` datetime DEFAULT NULL COMMENT '计划回款日期',
  `returnType` varchar(255) DEFAULT NULL COMMENT '计划回款方式',
  `preRemindDay` int(11) DEFAULT NULL COMMENT '提前几天提醒',
  `remindDate` datetime DEFAULT NULL COMMENT '提醒日期',
  `realReceivedMoney` decimal(18, 2) DEFAULT NULL COMMENT '实际回款金额',
  `realReturnDate` datetime DEFAULT NULL COMMENT '实际回款日期',
  `unreceivedMoney` decimal(18, 2) DEFAULT NULL COMMENT '未回款金额',
  `receivedStatus` varchar(255) DEFAULT '待回款' COMMENT '回款状态;待回款、回款完成、部分回款、作废、逾期',
  `receivablesId` varchar(255) DEFAULT NULL COMMENT '回款ID',
  `ownerUserId` varchar(255) DEFAULT NULL COMMENT '负责人ID',
  `ownerUser` varchar(255) DEFAULT NULL COMMENT '负责人',
  `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人ID',
  `createUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_receivables_plan_receivablesPlanId` (`receivablesPlanId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '回款计划表'

return_visit

• 回访表

CREATE TABLE `return_visit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `customerId` varchar(255) NOT NULL COMMENT '客户ID',
  `customerName` varchar(255) DEFAULT NULL COMMENT '客户名称',
  `contractId` varchar(255) NOT NULL COMMENT '合同ID',
  `visitId` varchar(255) NOT NULL COMMENT '回访id; HF10000x',
  `visitNumber` varchar(255) NOT NULL COMMENT '回访编号',
  `visitTime` datetime DEFAULT NULL COMMENT '回访时间',
  `visitUserId` varchar(255) NOT NULL COMMENT '回访人id',
  `visitUser` varchar(255) NOT NULL COMMENT '回访人',
  `visitType` varchar(255) NOT NULL COMMENT '回访形式;见面拜访,电话,短信,邮件,微信',
  `satisficing` varchar(255) NOT NULL COMMENT '客户满意度;很满意,满意,一般,不满意,很不满意',
  `fliedItvzix` varchar(255) NOT NULL COMMENT '客户反馈',
  `contractName` varchar(255) DEFAULT '' COMMENT '合同名称',
  `contractNum` varchar(255) DEFAULT '' COMMENT '合同编号',
  `contactsId` varchar(255) NOT NULL COMMENT '联系人id',
  `contactsUser` varchar(255) NOT NULL COMMENT '联系人名称',
  `ownerUserId` varchar(255) DEFAULT NULL COMMENT '负责人ID',
  `ownerUser` varchar(255) DEFAULT NULL COMMENT '负责人',
  `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人ID',
  `createUser` varchar(255) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_return_visit_visitId` (`visitId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '回访表'

sale_product

• 销售产品表

CREATE TABLE `sale_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `targetType` varchar(255) NOT NULL COMMENT '类型; 商机、合同',
  `targetId` varchar(255) NOT NULL COMMENT '业务Id; 商机ID、合同Id',
  `productId` varchar(255) NOT NULL COMMENT '产品ID',
  `productName` varchar(255) NOT NULL COMMENT '产品名称',
  `productType` varchar(255) NOT NULL COMMENT '产品类型',
  `price` decimal(18, 2) NOT NULL COMMENT '产品单价',
  `salesPrice` decimal(18, 2) NOT NULL COMMENT '销售价格',
  `num` decimal(10, 2) NOT NULL COMMENT '数量',
  `discount` int(11) NOT NULL COMMENT '折扣',
  `subtotal` decimal(18, 2) NOT NULL COMMENT '小计（折扣后价格）',
  `unit` varchar(255) DEFAULT NULL COMMENT '单位',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '销售产品表'

star

• 关注表

CREATE TABLE `star` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSequence` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '自增id',
  `starId` varchar(255) NOT NULL COMMENT '关注id; GZ10000x',
  `starType` varchar(255) DEFAULT NULL COMMENT '关注类型; 线索、客户、联系人、商机、合同、发票、回访、产品',
  `itemId` varchar(255) NOT NULL DEFAULT '' COMMENT '主体id',
  `itemName` varchar(255) NOT NULL DEFAULT '' COMMENT '主体名称',
  `userId` varchar(255) DEFAULT NULL COMMENT '关注人id',
  `user` varchar(255) DEFAULT NULL COMMENT '关注人',
  `remark` text COMMENT '备注',
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_marketing_marketingId` (`starId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC COMMENT = '关注表'

视图

_directory_user_session

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`localhost` SQL SECURITY DEFINER VIEW `_directory_user_session` AS
select
  `jh_enterprise_v2_data_repository`.`enterprise_directory_user_session`.`id` AS `id`,
  `jh_enterprise_v2_data_repository`.`enterprise_directory_user_session`.`userId` AS `userId`,
  `jh_enterprise_v2_data_repository`.`enterprise_directory_user_session`.`userIp` AS `userIp`,
  `jh_enterprise_v2_data_repository`.`enterprise_directory_user_session`.`userIpRegion` AS `userIpRegion`,
  `jh_enterprise_v2_data_repository`.`enterprise_directory_user_session`.`userAgent` AS `userAgent`,
  `jh_enterprise_v2_data_repository`.`enterprise_directory_user_session`.`deviceId` AS `deviceId`,
  `jh_enterprise_v2_data_repository`.`enterprise_directory_user_session`.`deviceType` AS `deviceType`,
  `jh_enterprise_v2_data_repository`.`enterprise_directory_user_session`.`socketStatus` AS `socketStatus`,
  `jh_enterprise_v2_data_repository`.`enterprise_directory_user_session`.`authToken` AS `authToken`,
  `jh_enterprise_v2_data_repository`.`enterprise_directory_user_session`.`operation` AS `operation`,
  `jh_enterprise_v2_data_repository`.`enterprise_directory_user_session`.`operationByUserId` AS `operationByUserId`,
  `jh_enterprise_v2_data_repository`.`enterprise_directory_user_session`.`operationByUser` AS `operationByUser`,
  `jh_enterprise_v2_data_repository`.`enterprise_directory_user_session`.`operationAt` AS `operationAt`
from
  `jh_enterprise_v2_data_repository`.`enterprise_directory_user_session`

_group

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`localhost` SQL SECURITY DEFINER VIEW `_group` AS
select
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`id` AS `id`,
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`groupId` AS `groupId`,
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`groupLastId` AS `groupLastId`,
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`groupPath` AS `groupPath`,
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`groupName` AS `groupName`,
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`groupDeptName` AS `groupDeptName`,
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`groupAllName` AS `groupAllName`,
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`principalId` AS `principalId`,
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`headId` AS `headId`,
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`leadId` AS `leadId`,
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`groupDesc` AS `groupDesc`,
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`operation` AS `operation`,
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`operationByUserId` AS `operationByUserId`,
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`operationByUser` AS `operationByUser`,
  `jh_enterprise_v2_data_repository`.`enterprise_group`.`operationAt` AS `operationAt`
from
  `jh_enterprise_v2_data_repository`.`enterprise_group`

_role

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`localhost` SQL SECURITY DEFINER VIEW `_role` AS
select
  `jh_enterprise_v2_data_repository`.`enterprise_role`.`id` AS `id`,
  `jh_enterprise_v2_data_repository`.`enterprise_role`.`roleId` AS `roleId`,
  `jh_enterprise_v2_data_repository`.`enterprise_role`.`roleName` AS `roleName`,
  `jh_enterprise_v2_data_repository`.`enterprise_role`.`roleType` AS `roleType`,
  `jh_enterprise_v2_data_repository`.`enterprise_role`.`roleDesc` AS `roleDesc`,
  `jh_enterprise_v2_data_repository`.`enterprise_role`.`operation` AS `operation`,
  `jh_enterprise_v2_data_repository`.`enterprise_role`.`operationByUserId` AS `operationByUserId`,
  `jh_enterprise_v2_data_repository`.`enterprise_role`.`operationByUser` AS `operationByUser`,
  `jh_enterprise_v2_data_repository`.`enterprise_role`.`operationAt` AS `operationAt`
from
  `jh_enterprise_v2_data_repository`.`enterprise_role`

_user_group_role

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`localhost` SQL SECURITY DEFINER VIEW `_user_group_role` AS
select
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role`.`id` AS `id`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role`.`userId` AS `userId`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role`.`groupId` AS `groupId`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role`.`roleId` AS `roleId`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role`.`roleDeadline` AS `roleDeadline`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role`.`operation` AS `operation`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role`.`operationByUserId` AS `operationByUserId`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role`.`operationByUser` AS `operationByUser`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role`.`operationAt` AS `operationAt`
from
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role`

_user_group_role_page

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`localhost` SQL SECURITY DEFINER VIEW `_user_group_role_page` AS
select
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`id` AS `id`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`appId` AS `appId`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`user` AS `user`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`group` AS `group`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`role` AS `role`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`page` AS `page`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`allowOrDeny` AS `allowOrDeny`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`desc` AS `desc`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`source` AS `source`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`operation` AS `operation`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`operationByUserId` AS `operationByUserId`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`operationByUser` AS `operationByUser`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`operationAt` AS `operationAt`
from
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`
where
  (
    (
      `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`appId` = 'jianghu-crm'
    )
    or (
      `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_page`.`appId` = '*'
    )
  )

_user_group_role_resource

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`localhost` SQL SECURITY DEFINER VIEW `_user_group_role_resource` AS
select
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`id` AS `id`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`appId` AS `appId`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`user` AS `user`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`group` AS `group`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`role` AS `role`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`resource` AS `resource`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`allowOrDeny` AS `allowOrDeny`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`desc` AS `desc`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`source` AS `source`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`operation` AS `operation`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`operationByUserId` AS `operationByUserId`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`operationByUser` AS `operationByUser`,
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`operationAt` AS `operationAt`
from
  `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`
where
  (
    (
      `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`appId` = 'jianghu-crm'
    )
    or (
      `jh_enterprise_v2_data_repository`.`enterprise_user_group_role_resource`.`appId` = '*'
    )
  )

_view01_user

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`localhost` SQL SECURITY DEFINER VIEW `_view01_user` AS
select
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`id` AS `id`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`idSequence` AS `idSequence`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`userId` AS `userId`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`username` AS `username`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`phoneNumber` AS `phoneNumber`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`email` AS `email`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`userStatus` AS `userStatus`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`hrOrgRoleList` AS `hrOrgRoleList`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`qiweiId` AS `qiweiId`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`wechatId` AS `wechatId`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`userConfig` AS `userConfig`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`password` AS `password`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`md5Salt` AS `md5Salt`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`clearTextPassword` AS `clearTextPassword`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`operation` AS `operation`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`operationByUserId` AS `operationByUserId`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`operationByUser` AS `operationByUser`,
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`.`operationAt` AS `operationAt`
from
  `jh_enterprise_v2_data_repository`.`enterprise_view01_user`

_view02_user_app

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`localhost` SQL SECURITY DEFINER VIEW `_view02_user_app` AS
select
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`id` AS `id`,
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`userId` AS `userId`,
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId` AS `appId`
from
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`
where
  (
    `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId` = 'jianghu-crm'
  )