| | |
|---|
| | | CREATE TABLE IF NOT EXISTS `project_role_user` ( |
|---|
| | | `id` bigint(20) NOT NULL AUTO_INCREMENT, |
|---|
| | | `project_role_id` bigint(20) NOT NULL, |
|---|
| | | `user_id` bigint(20) NOT NULL, |
|---|
| | | `user_id` bigint(20) NULL, |
|---|
| | | `department_id` bigint(20) NULL, |
|---|
| | | `register_id` bigint(20) NOT NULL, |
|---|
| | | `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
|---|
| | | `modify_id` bigint(20) NOT NULL, |
|---|
| | |
|---|
| | | PRIMARY KEY (`id`), |
|---|
| | | KEY `projectRoleIdAndUserIdIndex` (`project_role_id`,`user_id`), |
|---|
| | | KEY `userIdIndex` (`user_id`), |
|---|
| | | KEY `projectRoleIdIndex` (`project_role_id`) |
|---|
| | | KEY `projectRoleIdIndex` (`project_role_id`), |
|---|
| | | KEY `departmentIdIndex` (`department_id`) |
|---|
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
|---|
| | | |
|---|
| | | -- 테이블 데이터 owl_en_1.5.project_role_user:~0 rows (대략적) 내보내기 |
|---|
