/*
Navicat MySQL Data Transfer

Source Server         : CBH-MySQL-192.168.0.7-3368
Source Server Version : 50733
Source Host           : 127.0.0.1:9011
Source Database       : obpm2

Target Server Type    : MYSQL
Target Server Version : 50733
File Encoding         : 65001

Date: 2025-07-11 17:46:50
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for tenant_xlcp
-- ----------------------------
DROP TABLE IF EXISTS `tenant_xlcp`;
CREATE TABLE `tenant_xlcp` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '姓名',
  `serial_number` varchar(100) NOT NULL COMMENT '业务编码',
  `project_name` varchar(255) NOT NULL COMMENT '测评项目名称',
  `number` varchar(255) DEFAULT NULL COMMENT '证件号码',
  `employee_id` varchar(100) NOT NULL COMMENT '雇员id',
  `union_id` varchar(100) NOT NULL COMMENT '工会id',
  `organization_id` varchar(100) NOT NULL COMMENT '企业id',
  `file_url` varchar(500) DEFAULT NULL COMMENT '附件',
  `suggestion` text COMMENT '建议',
  `content` text COMMENT '评语',
  `result` varchar(255) DEFAULT NULL COMMENT '测评结果',
  `result_rule_tip` varchar(500) DEFAULT NULL COMMENT '结果规则提示',
  `creator_created_time` datetime DEFAULT NULL,
  `creator_id` varchar(150) DEFAULT NULL,
  `creator_name` varchar(200) DEFAULT NULL,
  `last_modifier_created_time` datetime DEFAULT NULL,
  `last_modifier_id` varchar(150) DEFAULT NULL,
  `last_modifier_name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `serial_number` (`serial_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
