Created
May 10, 2024 19:51
-
-
Save nasirdn/4493210ca7ba2dcb7fa8969af520140b to your computer and use it in GitHub Desktop.
СР3 - код создания таблиц
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- MySQL Script generated by MySQL Workbench | |
-- Fri May 10 22:51:19 2024 | |
-- Model: New Model Version: 1.0 | |
-- MySQL Workbench Forward Engineering | |
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; | |
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; | |
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; | |
-- ----------------------------------------------------- | |
-- Schema sr3_3.1 | |
-- ----------------------------------------------------- | |
-- ----------------------------------------------------- | |
-- Schema sr3_3.1 | |
-- ----------------------------------------------------- | |
CREATE SCHEMA IF NOT EXISTS `sr3_3.1` DEFAULT CHARACTER SET utf8 ; | |
USE `sr3_3.1` ; | |
-- ----------------------------------------------------- | |
-- Table `sr3_3.1`.`client` | |
-- ----------------------------------------------------- | |
CREATE TABLE IF NOT EXISTS `sr3_3.1`.`client` ( | |
`id_client` VARCHAR(10) NOT NULL, | |
`lastname` VARCHAR(60) NULL, | |
`name` VARCHAR(60) NOT NULL, | |
`birthday` DATE NULL, | |
`tel_num` VARCHAR(45) NULL, | |
`e_mail` VARCHAR(100) NOT NULL, | |
`adres` VARCHAR(100) NULL, | |
PRIMARY KEY (`id_client`), | |
UNIQUE INDEX `id_client_UNIQUE` (`id_client` ASC) VISIBLE, | |
UNIQUE INDEX `e_mail_UNIQUE` (`e_mail` ASC) VISIBLE) | |
ENGINE = InnoDB; | |
-- ----------------------------------------------------- | |
-- Table `sr3_3.1`.`game` | |
-- ----------------------------------------------------- | |
CREATE TABLE IF NOT EXISTS `sr3_3.1`.`game` ( | |
`id_game` INT NOT NULL, | |
`name_game` VARCHAR(100) NOT NULL, | |
`manufacturer` VARCHAR(100) NOT NULL, | |
`min_players` TINYINT UNSIGNED NOT NULL, | |
`max_players` TINYINT UNSIGNED NOT NULL, | |
`min_year` TINYINT UNSIGNED NULL, | |
PRIMARY KEY (`id_game`), | |
UNIQUE INDEX `id_game_UNIQUE` (`id_game` ASC) VISIBLE) | |
ENGINE = InnoDB; | |
-- ----------------------------------------------------- | |
-- Table `sr3_3.1`.`woker` | |
-- ----------------------------------------------------- | |
CREATE TABLE IF NOT EXISTS `sr3_3.1`.`woker` ( | |
`tab_num` VARCHAR(10) NOT NULL, | |
`lastname_work` VARCHAR(100) NOT NULL, | |
`name_work` VARCHAR(100) NOT NULL, | |
`patron_work` VARCHAR(100) NOT NULL, | |
PRIMARY KEY (`tab_num`), | |
UNIQUE INDEX `tab_num_UNIQUE` (`tab_num` ASC) VISIBLE) | |
ENGINE = InnoDB; | |
-- ----------------------------------------------------- | |
-- Table `sr3_3.1`.`order` | |
-- ----------------------------------------------------- | |
CREATE TABLE IF NOT EXISTS `sr3_3.1`.`order` ( | |
`num_order` INT NOT NULL, | |
`receipt` VARCHAR(45) NOT NULL, | |
`created` DATETIME NOT NULL, | |
`tab_num` VARCHAR(10) NOT NULL, | |
`id_client` VARCHAR(10) NOT NULL, | |
PRIMARY KEY (`num_order`), | |
UNIQUE INDEX `num_order_UNIQUE` (`num_order` ASC) VISIBLE, | |
UNIQUE INDEX `created_UNIQUE` (`created` ASC) VISIBLE, | |
INDEX `tab_num_key_idx` (`tab_num` ASC) VISIBLE, | |
INDEX `id_client_key_idx` (`id_client` ASC) VISIBLE, | |
CONSTRAINT `tab_num_key` | |
FOREIGN KEY (`tab_num`) | |
REFERENCES `sr3_3.1`.`woker` (`tab_num`) | |
ON DELETE CASCADE | |
ON UPDATE CASCADE, | |
CONSTRAINT `id_client_key` | |
FOREIGN KEY (`id_client`) | |
REFERENCES `sr3_3.1`.`client` (`id_client`) | |
ON DELETE CASCADE | |
ON UPDATE CASCADE) | |
ENGINE = InnoDB; | |
-- ----------------------------------------------------- | |
-- Table `sr3_3.1`.`order_position` | |
-- ----------------------------------------------------- | |
CREATE TABLE IF NOT EXISTS `sr3_3.1`.`order_position` ( | |
`num_order` INT NOT NULL, | |
`id_game` INT NOT NULL, | |
`num_position` INT UNSIGNED NOT NULL, | |
PRIMARY KEY (`num_order`, `id_game`), | |
INDEX `id_game_key_idx` (`id_game` ASC) VISIBLE, | |
CONSTRAINT `num_order_key` | |
FOREIGN KEY (`num_order`) | |
REFERENCES `sr3_3.1`.`order` (`num_order`) | |
ON DELETE CASCADE | |
ON UPDATE CASCADE, | |
CONSTRAINT `id_game_key` | |
FOREIGN KEY (`id_game`) | |
REFERENCES `sr3_3.1`.`game` (`id_game`) | |
ON DELETE CASCADE | |
ON UPDATE CASCADE) | |
ENGINE = InnoDB; | |
SET SQL_MODE=@OLD_SQL_MODE; | |
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; | |
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment