Z1yjEd22

1DROP TABLE IF EXISTS TrainStop;
2Drop TABLE if EXISTS Ticket;
3DROP TABLE IF EXISTS Seat;
4DROP TABLE IF EXISTS Waggon;
5DROP TABLE IF EXISTS Train;
6
7CREATE TABLE Train
8(
9ID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
10TrainName varchar(10)
11);
12
13CREATE TABLE Waggon(
14ID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
15TrainID int,
16 FOREIGN KEY (TrainID) REFERENCES Train(ID)
17);
18
19CREATE TABLE Seat
20(
21ID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
22WaggonID int ,
23 FOREIGN KEY (WaggonID) REFERENCES Waggon(ID)
24);
25
26CREATE TABLE Ticket
27(
28ID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
29Price int,
30Millage int,
31PlaceOfStart varchar(20),
32Destynation varchar(20),
33DepartureDate Date,
34ArivalDate Date,
35SeatID int,
36 FOREIGN KEY (ID) REFERENCES Seat(ID)
37 );
38 
39 
40 Create TABLE TrainStop
41(
42ID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
43StopName varchar(30),
44StopID int,
45 FOREIGN KEY (StopID) REFERENCES Ticket(ID)
46
47);