Apple shop

create database shop;
use shop;

set SQL_SAFE_UPDATES=0;

create table Person
(
id int primary key auto_increment,

email varchar(22),

passwordUser varchar(15),

role enum ('admin', 'user', 'guest')not null,

is_deleted bool
);
create table Category(
id int primary key auto_increment,
categoryName varchar(20),
model varchar(25)
);

create table Color(
id int primary key auto_increment,
colorName varchar(20)
);


create table Material(
id int primary key auto_increment,
material varchar(20)
);

create table Size(
id int primary key auto_increment,
size varchar(50)
);

create table Production(
id int primary key auto_increment,

category_id int,

price double,

description_id int ,

is_deleted bool
);

create table Basket
(
id int primary key auto_increment,

person_id int,

product_id int,

dataship varchar(50),

is_deleted bool
);

alter table Person add constraint unique (email);

alter table Basket add foreign key (person_id) references Person(id);

alter table Basket add foreign key (product_id) references Production(id);

alter table Production add foreign key (description_id) references Color(id);
alter table Production add foreign key (description_id) references Material(id);
alter table Production add foreign key (description_id) references Size(id);
alter table Production add foreign key (category_id) references Category(id);