CREATE TABLE `sb_investor` ( `id` int(11) NOT NULL AUTO_INCREMENT , `userid` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间' , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `investors_type` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出资人类型' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出资人姓名' , `id_number` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出资人身份证号' , `nation` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '民族' , `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址' , `national` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国籍' , `sex` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别' , `phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号' , `nowaddress` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址' , `funded_number` decimal(14,2) NULL DEFAULT NULL COMMENT '出资金额' , `stock_proportion` decimal(2,2) NULL DEFAULT NULL COMMENT '股份占比' , INDEX `ak_sb_investor_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ROW_FORMAT=COMPACT ; CREATE TABLE `investor` ( `id` int(11) NOT NULL AUTO_INCREMENT , `userid` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '修改时间' , `update_time` datetime NULL DEFAULT NULL , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `investors_type` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出资人类型' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出资人姓名' , `id_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '出资人身份证号' , `nation` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '民族' , `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '户籍' , `national` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国籍' , `sex` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别' , `nowaddress` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址' , `funded_number` decimal(14,2) NULL DEFAULT NULL COMMENT '出资金额' , `stock_proportion` decimal(2,2) NULL DEFAULT NULL COMMENT '股份占比' , INDEX `ak_investor_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ROW_FORMAT=COMPACT ; CREATE TABLE `subsidiary` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间' , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码' , `company_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分公司名称' , `register_address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分公司注册地址' , `business_place` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经营地址' , `company_principal` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司负责人' , `company_principal_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名' , `company_principal_phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司负责人电话' , `money_principal` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出资负责人' , `money_principal_phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出资负责人手机' , `money_principal_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出资负责人身份证号' , `filing_authority_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备案机关编码' , `filing_authority_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备案机关名称' , `filing_authority_date` datetime NULL DEFAULT NULL COMMENT '备案机关日期' , `job_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员职务' , `phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员联系方式' , `job_level` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员职业技能等级' , `job_type` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员职业类型' , `education` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员学历' , `manager_license_type` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员证件类型' , `manager_id` int(20) NULL DEFAULT NULL COMMENT '管理人员证件号' , INDEX `ak_subsidiary_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT ; CREATE TABLE `sb_subsidiary_base` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间' , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码' , `company_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分公司名称' , `register_address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分公司注册地址' , `business_place` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经营地址' , `filing_authority_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备案机关编码' , `filing_authority_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备案机关名称' , `filing_authority_date` datetime NULL DEFAULT NULL COMMENT '备案机关日期' , `money_principal` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出资负责人' , `money_principal_phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出资负责人手机' , `money_principal_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出资负责人身份证号' , INDEX `ak_sb_subsidiary_base_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT ; CREATE TABLE `sb_subsidiary_manager` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间' , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `job_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员职务' , `phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员联系方式' , `job_level` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员职业技能等级' , `job_type` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员职业类型' , `education` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员学历' , `manager_license_type` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员证件类型' , `manager_id` int(20) NULL DEFAULT NULL COMMENT '管理人员证件号' , INDEX `ak_sb_subsidiary_manager_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ROW_FORMAT=COMPACT ; CREATE TABLE `business_management` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间' , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `cross_city_business` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '跨区经营市县' , `cross_city_address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '跨区经营地址' , `tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式' , `security_services_type` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保安服务类型' , `principal` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人' , `principal_phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人电话' , `principal_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人身份证号' , `job_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人职务' , `filing_authority_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备案机关名称' , `filing_authority_date` datetime NULL DEFAULT NULL COMMENT '经营起始时间' , `business_start_time` datetime NULL , INDEX `ak_business_management_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT ; CREATE TABLE `business_outside_management` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间' , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `national` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '涉外经营国别' , `business_start_time` datetime NULL DEFAULT NULL COMMENT '经营起始时间' , `business_end_time` datetime NULL DEFAULT NULL COMMENT '经营结束时间' , `security_services_type` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保安服务类型' , `business_model` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经营模式' , `filing_authority_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备案公安机关名称' , `filing_authority_date` datetime NULL DEFAULT NULL COMMENT '备案日期' , INDEX `ak_business_outside_management_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT ; CREATE TABLE `sb_business_outside_management` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间' , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `national` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '涉外经营国别' , `security_scope` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '安保范围' , `business_start_time` datetime NULL DEFAULT NULL COMMENT '经营起始时间' , `business_end_time` datetime NULL DEFAULT NULL COMMENT '经营结束时间' , `business_model` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经营模式' , `filing_authority_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备案公安机关名称' , `filing_authority_date` datetime NULL DEFAULT NULL COMMENT '备案日期' , INDEX `ak_business_outside_management_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT ; CREATE TABLE `management_info` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间' , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `manager_license_type` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员证件类型' , `manager_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员证件号' , `job_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职务' , `phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式' , `job_level` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职业技能等级' , `education` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学历' , `share_ratio` decimal(2,2) NULL DEFAULT NULL COMMENT '股份占比' , INDEX `ak_business_outside_management_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT ; CREATE TABLE `sb_management_info` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间' , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `manager_license_type` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员证件类型' , `manager_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理人员证件号' , `job_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职务' , `phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式' , `job_level` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职业技能等级' , `education` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学历' , INDEX `ak_business_outside_management_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT ; CREATE TABLE `contract_info` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间' , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `contract_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同编号' , `contract_limit_time` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同期限' , `contract_start_time` datetime NULL DEFAULT NULL COMMENT '合同起始时间' , `contract_end_time` datetime NULL DEFAULT NULL COMMENT '合同结束时间' , `contract_sign_time` datetime NULL DEFAULT NULL COMMENT '合同签订时间' , `contract_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同名称' , `service_object` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '服务对象' , INDEX `ak_contract_info_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT ; CREATE TABLE `security_good_thing` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间' , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名' , `id_number` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号' , `department` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称' , `good_thing_date` datetime NULL DEFAULT NULL COMMENT '日期' , `content` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容' , `remark` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' , INDEX `ak_security_good_thing_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ROW_FORMAT=COMPACT ; CREATE TABLE `sb_reward` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间' , `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名' , `idnumber` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号' , `employeeid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '员工编号' , `departname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称' , `rewarddate` datetime NULL DEFAULT NULL COMMENT '奖励日期' , `rewardcontext` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '奖励内容' , `rewardreason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '奖励原因' , `rewardcompany` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '奖励单位' , `remarks` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' , INDEX `ak_sb_reward_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT ; CREATE TABLE `sb_punish` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间' , `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名' , `idnumber` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号' , `employeeid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '员工编号' , `departname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称' , `punishdate` datetime NULL DEFAULT NULL COMMENT '处罚日期' , `punishcontext` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处罚内容' , `punishreason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处罚原因' , `punishcompany` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处罚单位' , `remarks` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' , INDEX `ak_sb_reward_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT ; CREATE TABLE `common_complaint` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间' , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `context` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容' , `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号' , `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱' , INDEX `ak_common_complaint_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT ; CREATE TABLE `cy_serverht` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间' , `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `serverobj` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '服务对象' , `htname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同名称' , `htstartdate` datetime NULL DEFAULT NULL COMMENT '合同签订日期' , `htenddate` datetime NULL DEFAULT NULL COMMENT '合同结束日期' , `htnum` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同编号' , `htlife` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同年限' , INDEX `ak_common_complaint_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT ; CREATE TABLE `cy_association` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间' , `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称' , `numno` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号' , `hzname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会长名称' , `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话' , `cardnumber` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号' , `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址' , `establishdate` datetime NULL DEFAULT NULL COMMENT '成立日期' , INDEX `ak_cy_association_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ROW_FORMAT=COMPACT ; CREATE TABLE `cy_check` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID' , `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间' , `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间' , `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' , `active` bit(1) NULL DEFAULT NULL COMMENT '是否可用' , `numno` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号' , `companyname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位名称' , `companyno` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位编号' , `checkcontext` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检查内容' , `checkresult` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检查结果' , `checkdate` datetime NULL DEFAULT NULL COMMENT '检查日期' , INDEX `ak_cy_association_key` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ROW_FORMAT=COMPACT ;