Witam
Przy wpisaniu SELECT * FROM store tabela jest pusta. Wszystkie tabele pokazują dane, tylko nie tabela store. Czy ktoś może mi wytłumaczyć dlaczego tak się dzieje ?.
CREATE TABLE book (
`book_id` INT NOT NULL ,
`book_title` VARCHAR(100) ,
`book_genre` VARCHAR(100) ,
`book_author` VARCHAR(100) ,
`book_release_date` DATE ,
`book_language` TEXT ,
PRIMARY KEY (
`book_id`
)
);
INSERT INTO book (book_id,book_title,book_genre,book_author,book_release_date,book_language)
VALUES
("4567","Jan Ban","Horror","Tom Lasinski","2000-01-23","Polish"),
("4168","Jan Ban","Horror","Tom Lasinski","2000-01-23","Polish"),
("6754","Black Weed","Criminal","Lucy Lu","2010-06-12","English"),
("7543","Piotruś Pan","Fantasy","Li Mig","1995-11-26","Polish"),
("9532","Goliath","Fantasy","Anna Witney","2017-05-13","English"),
("7521","Me or You","Romance","Kate Uphill","1999-12-30","English"),
("9854","King Edward II","Historical","Robert Palmer","2003-07-03","English"),
("6523","WW II True Story","Historical","John Lambert","2013-04-11","English"),
("3687","Legend Of Hercules","Fantasy","Romus Polpus","1980-06-14","English"),
("8865","Powstanie 1994","Historical","Adam Kolodziej","2002-03-14","Polish"),
("1977","Hurricane","Criminal","Andrew Lake","1999-10-04","English"),
("5543","Crystal Tower","Fantasy","James Howard","1978-02-18","English"),
("5544","Crystal Tower","Fantasy","James Howard","1978-02-18","English"),
("5545","Crystal Tower","Fantasy","James Howard","1978-02-18","English"),
("7843","Tom Romin","Biography","Jessica Apton","2020-07-25","English"),
("1194","Last Summer","Criminal","Anton Kliczko","2014-10-16","English"),
("4821","Love in Florence","Romance","Antonio Campera","1999-08-06","English"),
("3321","Bella Vita","Romance","Giuseppe Gavari","1970-06-12","Italian"),
("6009","Quelcumen","Horror","Roberto Jesus","2021-12-01","English")
;
CREATE TABLE employee (
`employee_id` INT AUTO_INCREMENT NOT NULL UNIQUE,
`name` VARCHAR(100) NOT NULL ,
`surname` VARCHAR(100) NOT NULL ,
`phone` INT NOT NULL ,
`email` VARCHAR(100) NOT NULL ,
PRIMARY KEY (
`employee_id`
)
);
INSERT INTO employee (name,surname,phone,email)
VALUES ("Adam","Kowalski","183178","[email protected]"),
("Kasia","Mela","2435345","[email protected]"),
("Lucjan","Stachowicz","4235235","[email protected]"),
("Marta","Tomczak","2434523","[email protected]")
;
CREATE TABLE customer (
`customer_id` INT AUTO_INCREMENT NOT NULL UNIQUE,
`name` VARCHAR(100) NOT NULL ,
`surname` VARCHAR(100) NOT NULL ,
`street` VARCHAR(100) NOT NULL ,
`city` VARCHAR(100) NOT NULL ,
`zipcode` INT NOT NULL ,
`phone` INT NOT NULL ,
`email` VARCHAR(100) NOT NULL ,
PRIMARY KEY (
`customer_id`
)
);
INSERT INTO customer (name,surname,street,city,zipcode,phone,email)
VALUES ("Adam","Lucik","Polna 16","Warszawa","21314","321451","[email protected]"),
("Tomasz","Breja","Szkolna 16/13","Warszawa","11314","354331","[email protected]"),
("Lukasz","Klodziej","Romuald 1/2","Warszawa","12114","453246","[email protected]"),
("Marta","Lens","Slosa 5/12","Warszawa","21424","432423","[email protected]"),
("Adam","Stanko","Kuklej 21/12","Warszawa","43314","43213251","[email protected]"),
("Karolina","Andrysz","Holasa 14/2","Warszawa","24354","625362","[email protected]"),
("Krzysztof","Kanis","Holendrow 11","Warszawa","23314","5433234","[email protected]")
;
CREATE TABLE store (
`place_id` INT AUTO_INCREMENT ,
`shelf_number` INT ,
`book_id` INT ,
FOREIGN KEY (book_id) REFERENCES book(book_id) ON UPDATE CASCADE ON DELETE CASCADE ,
`book_in_store` INT ,
`book_rented` INT ,
PRIMARY KEY (
`place_id`
)
);
INSERT INTO store (shelf_number,book_id,book_in_store,book_rented)
VALUES
("1","4567","2","1"),
("3","6754","1","0"),
("6","7543","3","2"),
("2","9532","4","1"),
("2","7521","2","2"),
("2","9854","3","1"),
("4","6523","4","0"),
("4","3687","1","0"),
("3","8865","2","1"),
("5","0977","1","1"),
("3","5543","3","3"),
("2","7843","2","0"),
("6","1194","1","1"),
("4","4821","1","1"),
("2","3321","2","1"),
("1","6009","3","0")
;
CREATE TABLE rent (
`rent_id` INT AUTO_INCREMENT NOT NULL UNIQUE,
`book_id` INT ,
FOREIGN KEY(book_id) REFERENCES book(book_id) ON UPDATE CASCADE ON DELETE CASCADE,
`rent_date` DATE ,
`rent_end_date` DATE ,
`employee_id` INT ,
FOREIGN KEY(employee_id) REFERENCES employee(employee_id) ON UPDATE CASCADE ON DELETE CASCADE,
`customer_id` INT ,
FOREIGN KEY(customer_id) REFERENCES customer(customer_id) ON UPDATE CASCADE ON DELETE CASCADE,
PRIMARY KEY (
`rent_id`
)
);
INSERT INTO rent (book_id,rent_date,rent_end_date,employee_id,customer_id)
VALUES ("4567","2023-02-01","2023-02-05","1","3"),
("8865","2023-01-25","2023-02-01","1","3"),
("1977","2023-02-01","2023-02-06","1","2"),
("5543","2023-02-06","2023-02-12","2","4"),
("1194","2023-02-01","2023-02-12","1","4"),
("4821","2023-02-06","2023-02-12","3","2"),
("3321","2023-01-26","2023-02-05","1","4"),
("7543","2023-02-10","2023-02-15","4","5"),
("9532","2023-01-30","2023-02-10","2","2"),
("7521","2023-02-02","2023-02-10","4","6"),
("9854","2023-02-13","2023-02-23","1","1")
;