SQL Tables: Customer Information Reservations Invoices Guest Rooms Guest Room Gallery Promotions User Management

SQL Objects: SP - Mapped Data SP - Invoices View - Mapped Data View - Payment Summary Trigger - Audit Function - Invoice

Viewing All SQL Data - Using a View that contains mapped data from all SQL Tables.

Please click on the Invoice ID to view invoice details.

Invoice
ID		 Reservation
ID		 Room
Rate		 Total
Nights		 Total
Guests		 Promo
ID		 Total
Cost		 Invoice
Status		 Processed
By User ID		 Reservation
ID		 Room
ID		 Customer
ID		 Date
From		 Date
To		 Customer
ID		 First
Name		 Middle
Name		 Last
Name		 Address Line 1 Address Line 2 City State ZipCode Billing
Address Line1		 Billing
Address Line2		 Billing City Billing
State		 Billing
Zip Code		 Customer
Phone		 Customer Email
Address		 Emergency
Contact Name		 Emergency
Contact Phone		 Emergency Email Date
Entered		 Customer
Status		 Promo
ID		 Promo
Name		 Promo
Description		 Promo
Discount		 Promo
Status		 User
ID		 User
FullName		 User
LoginName		 User
Password		 EmailAddress Email
Validation		 Token Token Time Room
Picture ID		 Room
ID		 Picture Name Picture Description Picture Directory Room
ID		 Room
No		 Room
Type ID		 Room
Picture ID		 Capacity Rate Room Status Room
Type ID		 Room Name Room
Description