PMxzM2Up

1DROP TABLE IF EXISTS Booking;
2DROP TABLE IF EXISTS Trip;
3DROP TABLE IF EXISTS Person;
4DROP TABLE IF EXISTS Location;
5
6CREATE TABLE Location (
7		LocationID int NOT NULL, 
8        Location varchar(255) NOT NULL,
9        City varchar(255),
10        
11        PRIMARY KEY (LocationID)
12);
13
14CREATE TABLE Person (
15	PersonID int NOT NULL, 
16    FirstName varchar(255),
17    LastName varchar(255),
18    Email varchar(255),
19    PassKey varchar(255),
20    BirthDate Date,
21    TypeUser int NOT NULL,
22    
23    PRIMARY KEY (PersonID)
24);
25
26CREATE TABLE Trip (
27	TripID int NOT NULL,
28    Transport varchar(255),
29    Price double,
30    StartDate Date,
31    EndDate Date,
32    Places int, 
33    Country varchar(255),
34    City varchar(255),
35    Title varchar(255),
36    
37    LocationID int,
38
39    FOREIGN KEY (LocationID) REFERENCES Location(LocationID),
40    
41    PRIMARY KEY (TripID)
42    
43);
44
45CREATE TABLE Booking (
46	BookingID int NOT NULL, 
47    Persons int NOT NULL, 
48    Payed boolean,
49    Note varchar(255),
50    
51    TripID int, 
52    PersonID int,
53    
54    PRIMARY KEY (BookingID),
55    
56    FOREIGN KEY (TripID) REFERENCES Trip(TripID),
57    FOREIGN KEY (PersonID) REFERENCES Person(PersonID)
58);