bt_bs_pm

2023-09-15 {owner_id}_bs_pm mysql

-- 需求反馈
CREATE TABLE `pm_project_need_feedback` (
  `FEEDBACK_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'newid()' COMMENT '反馈ID',
  `REMARK` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci  NOT NULL  DEFAULT '' COMMENT '反馈说明',
  `TARGET_USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '目标用户',
  `TARGET_USER_PUSH_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '目标用户名',
  `TAGS` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '反馈标签',
  `SOURCE_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '所属需求',
  `PARENT_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '上级反馈',
  `IS_ENABLED` int DEFAULT '1' COMMENT '启用',
  `SORT_ID` int DEFAULT '0' COMMENT '排序',  `CREATE_TIME` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `MODIFY_TIME` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `CREATE_USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建用户',
  `MODIFY_USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`FEEDBACK_ID`) USING BTREE,
  UNIQUE KEY `idx_uq_pm_project_need_feedback` (`FEEDBACK_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 项目反馈

CREATE TABLE `pm_project_info_feedback` (
  `FEEDBACK_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'newid()' COMMENT '反馈ID',
  `REMARK` varchar(1000) NOT NULL DEFAULT '' COMMENT '反馈说明',
  `TARGET_USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '目标用户',

  `TARGET_USER_PUSH_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '目标用户名',
  `TAGS` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '反馈标签',
  `SOURCE_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL  DEFAULT '' COMMENT '所属项目',
  `PARENT_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '上级反馈',
  `IS_ENABLED` int DEFAULT '1' COMMENT '启用',
  `SORT_ID` int DEFAULT '0' COMMENT '排序',  `CREATE_TIME` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `MODIFY_TIME` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `CREATE_USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建用户',
  `MODIFY_USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`FEEDBACK_ID`) USING BTREE,
  UNIQUE KEY `idx_uq_pm_project_info_feedback` (`FEEDBACK_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- 任务反馈

CREATE TABLE `pm_project_task_feedback` (
  `FEEDBACK_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'newid()' COMMENT '反馈ID',
  `REMARK` varchar(1000) NOT NULL DEFAULT ''NULL COMMENT '反馈说明',
  `TARGET_USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '目标用户',
  `TARGET_USER_PUSH_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '目标用户名',
  `TAGS` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '反馈标签',
  `SOURCE_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL  DEFAULT '' COMMENT '所属项目',
  `PARENT_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '上级反馈',
  `IS_ENABLED` int DEFAULT '1' COMMENT '启用',
  `SORT_ID` int DEFAULT '0' COMMENT '排序',  `CREATE_TIME` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `MODIFY_TIME` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `CREATE_USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建用户',
  `MODIFY_USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`FEEDBACK_ID`) USING BTREE,
  UNIQUE KEY `idx_uq_pm_project_task_feedback` (`FEEDBACK_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;