forked from satyamnaithani/Roomer
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Roomer Database.txt
13 lines (7 loc) · 940 Bytes
/
Roomer Database.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
> CREATE DATABASE rooms;
>USE rooms;
> CREATE TABLE register(fullName varchar(30), country varchar(10), mobileNo varchar(15), password varchar(30) PRIMARY KEY(mobileNo))
> create table register_partner(partnerName varchar(20), password varchar(30), phoneNo varchar(15) PRIMARY KEY(phoneNo))
> CREATE TABLE hotel(partnerName varchar(20), hotelName varchar(20), city varchar(15), location varchar(20), description varchar(150) PRIMARY KEY(hotelName))
> CREATE TABLE hotelrooms(partnerName varchar(20), hotelName varchar(20), roomNo varchar(8), roomSize varchar(10), AC varchar(10), TV varchar(5), breakfast varchar(5), wifi varchar(5), price varchar(6) PRIMARY KEY(roomNo))
> create table booked_rooms(fullName varchar(30), mobileNo varchar(15), partnerName varchar(20), hotelName varchar(20), roomNo varchar(8), roomSize varchar(10), AC varchar(10), TV varchar(5), breakfast varchar(5), wifi varchar(5), price varchar(6))