xWTfp2qm

1-- Database export via SQLPro (https://www.sqlprostudio.com/allapps.html)
2-- Exported by maxwell at 05-05-2021 19:08.
3-- WARNING: This file may contain descructive statements such as DROPs.
4-- Please ensure that you are running the script at the proper location.
5
6
7-- BEGIN TABLE Accounts
8DROP TABLE IF EXISTS Accounts;
9CREATE TABLE `Accounts` (
10  `Username` varchar(20) NOT NULL,
11  `Password` varchar(20) DEFAULT NULL,
12  `UserID` varchar(20) DEFAULT NULL,
13  `CardNumber` int DEFAULT NULL,
14  `CVV` int DEFAULT NULL,
15  `ExDate` varchar(5) DEFAULT NULL,
16  PRIMARY KEY (`Username`),
17  KEY `UserID` (`UserID`),
18  CONSTRAINT `accounts_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `Users` (`UserID`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
20
21-- Table Accounts contains no data. No inserts have been genrated.
22-- Inserting 0 rows into Accounts
23
24
25-- END TABLE Accounts
26
27-- BEGIN TABLE Bookings
28DROP TABLE IF EXISTS Bookings;
29CREATE TABLE `Bookings` (
30  `BookingID` varchar(20) NOT NULL,
31  `UsrBknID` varchar(20) NOT NULL,
32  `Payment_Mode` int DEFAULT NULL,
33  `Reservation_Slot` time DEFAULT NULL,
34  `StationID` varchar(20) NOT NULL,
35  `Age_Rating` enum('G','PG','M','MA','R') DEFAULT NULL,
36  PRIMARY KEY (`BookingID`),
37  KEY `UsrBknID` (`UsrBknID`),
38  CONSTRAINT `bookings_ibfk_1` FOREIGN KEY (`UsrBknID`) REFERENCES `UserBookings` (`UsrBknID`),
39  CONSTRAINT `bookings_ibfk_2` FOREIGN KEY (`UsrBknID`) REFERENCES `UserBookings` (`UsrBknID`)
40) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
41
42-- Table Bookings contains no data. No inserts have been genrated.
43-- Inserting 0 rows into Bookings
44
45
46-- END TABLE Bookings
47
48-- BEGIN TABLE Stations
49DROP TABLE IF EXISTS Stations;
50CREATE TABLE `Stations` (
51  `STN_ID` varchar(20) NOT NULL,
52  `VR_Model` enum('Vive','Vive Pro','Valve Index') DEFAULT NULL,
53  `1-2` tinyint(1) DEFAULT '0',
54  `2-3` tinyint(1) DEFAULT '0',
55  `3-4` tinyint(1) DEFAULT '0',
56  `4-5` tinyint(1) DEFAULT '0',
57  `5-6` tinyint(1) DEFAULT '0',
58  PRIMARY KEY (`STN_ID`)
59) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
60
61-- Table Stations contains no data. No inserts have been genrated.
62-- Inserting 0 rows into Stations
63
64
65-- END TABLE Stations
66
67-- BEGIN TABLE UserBookings
68DROP TABLE IF EXISTS UserBookings;
69CREATE TABLE `UserBookings` (
70  `UsrBknID` varchar(20) NOT NULL,
71  `BookingID` varchar(20) NOT NULL,
72  `UserID` varchar(20) NOT NULL,
73  PRIMARY KEY (`UsrBknID`),
74  KEY `BookingID` (`BookingID`),
75  KEY `UserID` (`UserID`),
76  CONSTRAINT `userbookings_ibfk_1` FOREIGN KEY (`BookingID`) REFERENCES `Bookings` (`BookingID`),
77  CONSTRAINT `userbookings_ibfk_2` FOREIGN KEY (`UserID`) REFERENCES `Users` (`UserID`)
78) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
79
80-- Table UserBookings contains no data. No inserts have been genrated.
81-- Inserting 0 rows into UserBookings
82
83
84-- END TABLE UserBookings
85
86-- BEGIN TABLE Users
87DROP TABLE IF EXISTS Users;
88CREATE TABLE `Users` (
89  `UserID` varchar(20) NOT NULL,
90  `Firstname` char(25) DEFAULT NULL,
91  `Secondname` char(25) DEFAULT NULL,
92  `Email` varchar(50) DEFAULT NULL,
93  `Birthdate` date DEFAULT NULL,
94  `UsrBknID` varchar(20) DEFAULT NULL,
95  PRIMARY KEY (`UserID`),
96  KEY `UsrBknID` (`UsrBknID`),
97  CONSTRAINT `users_ibfk_1` FOREIGN KEY (`UsrBknID`) REFERENCES `UserBookings` (`UsrBknID`)
98) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
99
100-- Table Users contains no data. No inserts have been genrated.
101-- Inserting 0 rows into Users
102
103
104-- END TABLE Users