| | |
|---|
| | | ALTER TABLE `user` ADD COLUMN `level_id` BIGINT(11) NULL; |
|---|
| | | ALTER TABLE `user` ADD COLUMN `department_id` BIGINT(11) NULL; |
|---|
| | | |
|---|
| | | CREATE TABLE `department_management`( |
|---|
| | | CREATE TABLE `department_manage`( |
|---|
| | | `id` BIGINT(11) AUTO_INCREMENT, |
|---|
| | | `department_name` VARCHAR(50) NOT NULL, |
|---|
| | | `department_description` VARCHAR(255) NOT NULL, |
|---|
| | |
|---|
| | | `default_yn` VARCHAR (1) NOT NULL DEFAULT 'N', |
|---|
| | | `basic_user` VARCHAR (1) NOT NULL DEFAULT 'N', |
|---|
| | | PRIMARY KEY (`id`) USING btree |
|---|
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
|---|
| | | |
|---|
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
|---|
