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

Reservation Information

Add New Reservation

Reservation ID Invoice ID Room ID Customer ID DateFrom DateTo Delete Update

Add New Reservation