Создание индексов - проект бд

gistfile1.txt

Для таблицы Attestation
CREATE UNIQUE INDEX `id_attestation_UNIQUE` ON `project_bd`.`attestation` (`id_attestation` ASC) VISIBLE;

CREATE UNIQUE INDEX `num_of_admis_order_UNIQUE` ON `project_bd`.`attestation` (`num_of_admis_order` ASC) VISIBLE;


Для таблицы Rank
CREATE UNIQUE INDEX `name_UNIQUE` ON `project_bd`.`rank` (`name` ASC) VISIBLE;

Для таблицы Position
CREATE UNIQUE INDEX `id_position_UNIQUE` ON `project_bd`.`position` (`id_position` ASC) VISIBLE;

CREATE UNIQUE INDEX `name_UNIQUE` ON `project_bd`.`position` (`name` ASC) VISIBLE;

Для таблицы Employee
CREATE UNIQUE INDEX `id_employee_UNIQUE` ON `project_bd`.`employee` (`id_employee` ASC) VISIBLE;

CREATE UNIQUE INDEX `identification_UNIQUE` ON `project_bd`.`employee` (`identification` ASC) VISIBLE;

CREATE INDEX `position_key_idx` ON `project_bd`.`employee` (`position` ASC) VISIBLE;

CREATE INDEX `rank_key_idx` ON `project_bd`.`employee` (`rank` ASC) VISIBLE;

Для таблицы Exercise
CREATE UNIQUE INDEX `id_exercise_UNIQUE` ON `project_bd`.`exercise` (`id_exercise` ASC) VISIBLE;

CREATE INDEX `type_key_idx` ON `project_bd`.`exercise` (`type` ASC) VISIBLE;

Для таблицы Type of exercise
CREATE UNIQUE INDEX `name_UNIQUE` ON `project_bd`.`type_of_exercise` (`name` ASC) VISIBLE;

Для таблицы EmployeesExercise
CREATE INDEX `emp_id_idx` ON `project_bd`.`EmployeesExercise` (`employee_ id` ASC) VISIBLE;

CREATE INDEX `ex_key_idx` ON `project_bd`.`EmployeesExercise` (`exercise_id` ASC) VISIBLE;


Для таблицы EmployeesAttes
CREATE INDEX `attes_key_idx` ON `project_bd`.`EmployeesAttes` (`attestation_id` ASC) VISIBLE;