· 5 years ago · May 29, 2020, 04:18 PM
1-- MySQL Script generated by MySQL Workbench
2-- Fri May 29 18:12:38 2020
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @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';
9
10-- -----------------------------------------------------
11-- Schema projekt
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema projekt
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `projekt` ;
18USE `projekt` ;
19
20-- -----------------------------------------------------
21-- Table `projekt`.`customer`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `projekt`.`customer` (
24 `customer_id` INT NOT NULL AUTO_INCREMENT,
25 `first_name` VARCHAR(45) NOT NULL,
26 `last_name` VARCHAR(45) NOT NULL,
27 `addres_id` INT NULL,
28 `password` VARCHAR(45) NULL,
29 PRIMARY KEY (`customer_id`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `projekt`.`address`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `projekt`.`address` (
37 `address_id` INT NOT NULL AUTO_INCREMENT,
38 `address` VARCHAR(50) NOT NULL,
39 `street` VARCHAR(50) NULL,
40 `house_number` VARCHAR(10) NOT NULL,
41 `postal_code` VARCHAR(6) NOT NULL,
42 `email` VARCHAR(50) NOT NULL,
43 `phone` VARCHAR(20) NOT NULL,
44 PRIMARY KEY (`address_id`))
45ENGINE = InnoDB;
46
47
48-- -----------------------------------------------------
49-- Table `projekt`.`staff`
50-- -----------------------------------------------------
51CREATE TABLE IF NOT EXISTS `projekt`.`staff` (
52 `staff_id` INT NOT NULL AUTO_INCREMENT,
53 `first_neme` VARCHAR(45) NOT NULL,
54 `last_name` VARCHAR(45) NOT NULL,
55 `address_id` INT NOT NULL,
56 `password` VARCHAR(45) NOT NULL,
57 PRIMARY KEY (`staff_id`))
58ENGINE = InnoDB;
59
60
61-- -----------------------------------------------------
62-- Table `projekt`.`mail`
63-- -----------------------------------------------------
64CREATE TABLE IF NOT EXISTS `projekt`.`mail` (
65 `mail_id` INT NOT NULL AUTO_INCREMENT,
66 `sender` VARCHAR(50) NOT NULL,
67 `reciver` VARCHAR(50) NOT NULL,
68 `content` VARCHAR(500) NOT NULL,
69 PRIMARY KEY (`mail_id`))
70ENGINE = InnoDB;
71
72
73-- -----------------------------------------------------
74-- Table `projekt`.`services`
75-- -----------------------------------------------------
76CREATE TABLE IF NOT EXISTS `projekt`.`services` (
77 `services_id` INT NOT NULL AUTO_INCREMENT,
78 `name` VARCHAR(150) NOT NULL,
79 `description` VARCHAR(500) NOT NULL,
80 `time` INT NOT NULL,
81 `time_type` VARCHAR(45) NOT NULL,
82 `prices` DECIMAL NOT NULL,
83 PRIMARY KEY (`services_id`),
84 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
85ENGINE = InnoDB;
86
87
88-- -----------------------------------------------------
89-- Table `projekt`.`orders`
90-- -----------------------------------------------------
91CREATE TABLE IF NOT EXISTS `projekt`.`orders` (
92 `orders_id` INT NOT NULL AUTO_INCREMENT,
93 `customer_id` INT NOT NULL,
94 `services_id` INT NOT NULL,
95 `staff_id` INT NOT NULL,
96 `animal_id` INT NOT NULL,
97 `date_start` DATETIME NOT NULL,
98 `date_end` DATETIME NOT NULL,
99 `complete` TINYINT NOT NULL,
100 `note` VARCHAR(250) NULL,
101 PRIMARY KEY (`orders_id`))
102ENGINE = InnoDB;
103
104
105-- -----------------------------------------------------
106-- Table `projekt`.`animals`
107-- -----------------------------------------------------
108CREATE TABLE IF NOT EXISTS `projekt`.`animals` (
109 `animal_id` INT NOT NULL AUTO_INCREMENT,
110 `customer_id` INT NOT NULL,
111 `species_id` VARCHAR(45) NOT NULL,
112 `breed_id` VARCHAR(45) NOT NULL,
113 `animalscol` VARCHAR(45) NULL,
114 PRIMARY KEY (`animal_id`))
115ENGINE = InnoDB;
116
117
118-- -----------------------------------------------------
119-- Table `projekt`.`gatunek`
120-- -----------------------------------------------------
121CREATE TABLE IF NOT EXISTS `projekt`.`gatunek` (
122)
123ENGINE = InnoDB;
124
125
126-- -----------------------------------------------------
127-- Table `projekt`.`rasa`
128-- -----------------------------------------------------
129CREATE TABLE IF NOT EXISTS `projekt`.`rasa` (
130)
131ENGINE = InnoDB;
132
133
134SET SQL_MODE=@OLD_SQL_MODE;
135SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
136SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;