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

Report: Customer Audit

New ID Old ID Revision
Date		 First Name Last Name Street Address City State Zip Code Phone Number Email Address Emerg. Contact Emerg. Phone No
1 3 2023-04-17 00:01:34 Crystal Bryant 7198 Redwood Lane Bethlehem PA 18015 (832) 777-1703 smallpaul@gmail.com Denzel Gonzales (605) 521-5456
2 6 2023-04-17 00:54:08 Danielle Raymond 7571 Andover Ave. Clifton Park NY 12065 (992) 577-9345 squirrel@gmail.com Remington Singleton (370) 766-5009
3 6 2023-04-17 00:55:16 Danielle Raymond 7571 Andover Ave. Clifton Park NY 12065 (212) 577-9345 squirrel@gmail.com Remington Singleton (370) 766-5009
4 6 2023-04-17 00:56:41 Danielle Raymond 7571 Andover Ave. Clifton Park NY 12065 (212) 577-9345 rsingleton@gmail.com Remie Singleton (370) 766-5009
5 6 2023-04-17 00:58:11 Danielle Raymond 7571 Andover Ave. Clifton Park NY 12065 (212) 577-9345 rsingleton@gmail.com Remzie Singleton (370) 766-5009
6 28 2023-04-17 00:59:37 Erin Bell 8 Richardson Dr. Tacoma WA 98444 (811) 912-7310 tubesteak@yahoo.com Giada Rollins (790) 240-6968
7 28 2023-04-17 01:00:23 Erin Bell 8 Richardson Dr. Tacoma WA 98444 (811) 555-1212 tubesteak@yahoo.com Claudia Rollins (790) 240-6968
8 28 2023-04-17 21:40:36 Erin Bell 8 Richardson Dr. Tacoma WA 98444 (811) 555-1212 tubesteak@yahoo.com Claudia Rollins (790) 240-6968
9 28 2023-04-17 21:41:34 Erin Bell 8 Richardson Dr. Tacoma WA 98444 (811) 555-1212 erinbell@yahoo.com Claudia Rollins (790) 240-6968
10 58 2023-04-17 21:51:58 222 222 222 22 22 22 22 22@gmail.com 22 22
11 58 2023-04-18 00:48:59 Test Test 222 22 22 22 22 22@gmail.com 22 22
40 70 2023-05-08 11:09:19 My SQL Data Back Again 123 Main Street Happy City NY 10000 (212)555-1000 allofmysqldatagotwipedout@whodidit.com IP Address Can Be Traced (212) 000-000
41 50 2023-05-08 11:14:35 Test Test 222 22 22 22 22 22@gmail.com 22 22
42 70 2023-05-09 01:19:08 My SQL Data Back Again 123 IP Address Lane Happy City NY 10000 (212)555-1000 allofmysqldatagotwipedout@whodidit.com IP Address Can Be Traced (212) 000-000
43 52 2023-05-09 01:19:58 Jessica Kent 30 Sleepy Hollow St. Biloxi MS 39532 (655) 320-6507 chaffar@aol.com Blaze Stephens (994) 812-0225
44 65 2023-05-09 01:20:23 Catherine Clements 125 Courtland Street Saint Albans NY 11412 (479) 926-4226 koudas@gmail.com Nasir Lee (902) 602-0315
45 41 2023-05-09 01:20:41 Steven Williams 9154 Central St. Kings Mountain NC 28086 (336) 734-9451 cgarcia@aol.com Shirley Zamora (430) 924-1209
46 83 2024-02-18 22:28:38 My Test 1 Test Street Test City CA 00000 000-000-0000 testemail@test.com My Test Emergency Contact 000-000-0000
47 1 2024-02-18 22:29:43 David Lopez 798 Blackburn Drive Aiken SC 29803 (387) 674-5837 osaru@msn.com Regina Murphy (365) 898-7006
48 130 2025-04-28 04:40:04 QsLtfSqmijLXgi rpFFMZmXHTkSzud HVEemyIvlzFdab DBGfyZmSGuK reqjEAnSejfevbp omRDmhkIhaaYC 8847305614 sberryhc1999@gmail.com fKRUKxmsFp 7872712960