| | |
|---|
| | | -- 테이블 owl_en_1.5.issue_user 구조 내보내기 |
|---|
| | | CREATE TABLE IF NOT EXISTS `issue_user` ( |
|---|
| | | `id` bigint(20) NOT NULL AUTO_INCREMENT, |
|---|
| | | `user_id` bigint(20) NOT NULL, |
|---|
| | | `user_id` bigint(20) NULL, |
|---|
| | | `department_id` bigint(20) NOT NULL, |
|---|
| | | `issue_id` bigint(20) NOT NULL, |
|---|
| | | `workspace_id` bigint(20) NOT NULL, |
|---|
| | | `register_id` bigint(20) NOT NULL, |
|---|
| | |
|---|
| | | KEY `userIdAndIssueIdIndex` (`user_id`,`issue_id`), |
|---|
| | | KEY `issueIdIndex` (`issue_id`), |
|---|
| | | KEY `workspaceIdIndex` (`workspace_id`), |
|---|
| | | KEY `userIdIndex` (`user_id`) |
|---|
| | | KEY `userIdIndex` (`user_id`), |
|---|
| | | KEY `departmentIdIndex` (`department_id`) |
|---|
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
|---|
| | | |
|---|
| | | -- 테이블 데이터 owl_en_1.5.issue_user:~0 rows (대략적) 내보내기 |
|---|
