- 워크플로우 담당부서 테이블 생성

jhjang

2021-11-25 5f695a6891d31a502d61e91fd12acc79c292f734

 src/main/resources/migration/V1_11__Alter_Table.sql

@@ -187,3 +187,22 @@
ALTER TABLE `issue_table_config` ADD COLUMN  `issue_id` BIGINT(20) NOT NULL;
ALTER TABLE `issue_table_config` ADD COLUMN  `issue_table_type` INT(11) NOT NULL;
ALTER TABLE `issue_table_config` ADD INDEX `issueTableTypeIndex`(`issue_table_type`);

-- issue_risk 테이블 부서변경 카운트 컬럼 추가
ALTER TABLE `issue_risk` ADD COLUMN `change_department_count` BIGINT(20) NOT NULL DEFAULT '0';

-- 워크 플로우 상태 담당부서 지정
CREATE TABLE `workflow_department`(
                                      `id` BIGINT(11) AUTO_INCREMENT,
                                      `workflow_id` BIGINT(11),
                                      `issue_status_id` BIGINT(11),
                                      `department_id` BIGINT(11),
                                      `register_id` BIGINT(20) NOT NULL,
                                      `register_date` TIMESTAMP NULL,
                                      `modify_id` BIGINT(20) NOT NULL,
                                      `modify_date` TIMESTAMP NULL,
                                      PRIMARY KEY (`id`) USING BTREE,
                                      INDEX `workflowIdIndex` (`workflow_id`) USING BTREE,
                                      INDEX `issueStatusIdIndex` (`issue_status_id`) USING BTREE,
                                      INDEX `departmentIdIndex` (`department_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;