Database Table For Hotel Management System – Hotel Management System is Evergreen Project for real life as well for engineering students.Visitor or Client comes in hotel and book his/her room for some duration. Visitor will provide his own personal detail and will get room number according to availability. Yeah there will be charge for every room according to facility. After payment visitor will checkout from the hotel.
Many more things may consider but a core hotel management will structured in following database tables.
1. Guest Info. 2. Room availability 3. Room Category 4. Room Fare 5. Booking Info. 6. Cash Register
There may be another table for Room sub category in case , there are varieties of rooms available. Many More tables may be consider but these above tables are core part of Hotel Management Project.
This project can be developed in VB.NET, PHP, Android, C#.NET and many more. In the following we have shared tables and table columns.
Database Table For Hotel Management System:
Table
name: booking
Column
Type
Index
Description
Bookingid
int(10)
Primary key
Booking ID
roomid
int(10)
Foreign key
Room ID
customerid
int(10)
Foreign key
Customer ID
bookingdate
date
Notnull
Booking Date
checkin
datetime
Notnull
Check IN
checkout
datetime
Notnull
Check OUT
status
varchar(10)
Notnull
Status
Table
name: customer
Column
Type
Index
Description
customerid
int(10)
Primary key
Customer ID
customername
varchar(50)
Not null
Customer Name
address
text
Not null
Address
contactno
varchar(15)
Not null
Contact Number
gender
varchar(10)
Not null
Gender
idproof
varchar(100)
Not null
Id Proof
addressproof
varchar(100)
Not null
Address Proof
profileimage
varchar(100)
Not null
Profile Image
status
varchar(10)
Not null
Status
Table
name: employee
Column
Type
Index
Description
employeeid
int(10)
Primary key
Employee ID
empname
varchar(25)
Not null
Employee Name
loginid
varchar(25)
Not null
Login ID
password
varchar(100)
Not null
Password
emptype
varchar(25)
Not null
Employee Type
status
varchar(10)
Not null
Status
Table
name:expense
Column
Type
Index
Description
expenseid
int(10)
Primary key
Expense ID
employeeid
int(10)
Foreign key
Employee ID
expensetype
varchar(20)
Not null
Expense Type
expensedescription
text
Not null
Expense Description
expenseamt
float
Not null
Expense Amount
expensedate
date
Not null
Expense Date
status
varchar(10)
Not null
Status
Table
name: item
Column
Type
Index
Description
itemid
int(10)
Primary key
Item Id
itemtype
varchar(25)
Not null
Item Type
itemname
varchar(100)
Not null
Item Name
itemcost
float(10,2)
Not null
Item Cost
itemdetails
text
Not null
Item Details
status
varchar(10)
Not null
Status
Table
name: order
Column
Type
Index
Description
orderid
int(10)
Primary key
Order ID
itemid
int(10)
Foreign key
Item ID
bookingid
Int(10)
Foreign key
Booking ID
orderdate
date
Not null
Order Date
qty
Float(10,2)
Not null
Quantity
cost
Float(10,2)
Not null
Cost
status
varchar(10)
Not null
Status
Table
name: payment
Column
Type
Index
Description
paymentid
int(10)
Primary key
Payment ID
bookingid
int(10)
Foreign key
Booking ID
type
varchar(20)
Not null
Type
amount
float(10,2)
Not null
Amount
paymenttype
Varchar(20)
Not null
Payment Type
paymentdetail
text
Not null
Payment Detail
paymentdate
date
Not null
Payment Date
status
varchar(10)
Not null
Status
Table
name: reminder
Column
Type
Index
Description
reminderid
int(10)
Primary key
Reminder ID
bookingid
int(10)
Foreign key
Booking ID
remindertype
varchar(25)
Not null
Reminder Type
reminderdetail
text
Not null
Reminder Detail
datetime
Datetime
Not null
Date and Time
status
varchar(10)
Not null
Status
Table
name: room
Column
Type
Index
Description
Roomid
int(10)
Primary key
Room ID
Roomtypeid
Int(10)
Foreign key
Room Type ID
Roomnumber
Varchar(10)
Not null
Room Number
description
text
Not null
Description
status
varchar(10)
Not null
Status
Table
name: roomtype
Column
Type
Index
Description
roomtypeid
int(10)
Primary key
Roomtype ID
roomtype
varchar(100)
Not null
RoomTtype
roomimg
varchar(100)
Not null
Room Image
description
text
Not null
Description
cost
Float(10,2)
Not null
Cost
status
varchar(10)
Not null
Status
For Video tutorials refer following link ..
🔥8.1 K Views
0 Comments
Neeraja
March 20, 2022 - 2:39 PMCan you send hotel management project with whole documentation and source code using vb.net and sql server