Scribd
Upload
394 views42 pages

Employee and Booking Data Overview

The document contains data from a hotel management system including user accounts, room details, bookings, and other related information. It includes tables with columns for username, room number, services, price, and other attributes. The data appears to be from the backend database of a hotel management or booking system.

Uploaded by

Alyssa Marie Santos
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
394 views42 pages

Employee and Booking Data Overview

The document contains data from a hotel management system including user accounts, room details, bookings, and other related information. It includes tables with columns for username, room number, services, price, and other attributes. The data appears to be from the backend database of a hotel management or booking system.

Uploaded by

Alyssa Marie Santos
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 42

username system_ad_username email

000001 202000 laila.grifth@hotmail.com


000002 202100 jasmin.burris@gmail.com
000003 202200 britney.m@gmail.com
000004 202300 esmaepowell@labadie.com
000005 202400 murtazabrooks@gmail.com
password type complete_name
JUt5I4 Manager Laila Griffith
2wm0Fy Manager Jasmin Burris
Ye0Fr9 Manager Britney Murillo
B71XUS Travel Officer Esmae Powell
0V475g Travel Officer Murtaza Brooks
complete_address
522 Jaida Ports, Apt. 416, 14868, East Chesley, Idaho, United States
09342 Balistreri Passage, Apt. 317, 75258-3888, North Nickolas, Rhode Island, United States
03956 Lavada Mews, Apt. 117, 78206, Lake Adelinestad, Utah, United States
28521 Monahan Manors, Apt. 767, 89536-2150, Rodrigochester, North Dakota, United States
71091 Arvel Point, Suite 254, 30539, Lake Jannie, South Dakota, United States
birthday date_hired shift
1991-12-24 2001-11-09 1
1980-11-25 2003-07-07 3
1991-12-12 2004-01-28 4
1984-02-25 2004-03-12 2
1981-01-08 2004-05-10 1
phone_number
19214910197
13433157836
12382936489
16197313154
18165279233
username full_name
000001 Alyssa Santos
000002 Kib Reyes
000003 Dwight Ramos
000004 Kianna Uy
000005 Kobe Rivero
address number
24670 Church St Oak Park, Michigan(MI), 48237 631425
6306 Muirlands Dr La Jolla, California(CA), 92037 632943
609 Ballaststone Cir Bloomingdale, Georgia(GA), 31302 639745
1096 Lincoln St Tignall, Georgia(GA), 30668 698566
2901 Edgewood St Portage, Indiana(IN), 46368 690546
username isSysAdmin
202000 0
202100 1
202200 0
202300 0
202400 0
issue_id issue_desc decision manager_user
111119 broken pc buy another pc 000003
111118 broken router buy another router 000002
111118 website is down fix website 000003
111117 broken mouse buy another mouse 000002
111116 broken keyboard buy another keyboard 000001
username start_shift end_shift
null null null
null null null
null null null
000004 6:00:00 12:00:00
000005 12:00:00 18:00:00
username start_shift end_shift
000001 5:00:00 10:00:00
null null null
000003 15:00:00 20:00:00
null null null
null null null
doc_no doc_name updated_by
881000 proof_of_billing 000010
881001 front_card 000006
881002 back_card 000007
881003 passport 000008
881004 proof1_of_billing 000009
photo_link
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
username email password
000010 ryan_reyes@gmail.com Ryan123
000006 gab_alomia@gmail.com Gab654
000007 marcus_reyes@yahoo.com Marc333
000008 lance_garcia@yahoo.com Lance555
000009 max_deleon@yahoo.com Maxim765
address foreigner provider_type
14887 Cr 160 Carrollton, Missouri(MO), 64633 0 Dining Accomodati
14141 32nd Hwy Lebanon, Missouri(MO), 65536 0 Accommodation Pro
30 Stallings Bridge Rd Tylertown, Mississippi(MS), 39667 0 Accommodation Pro
11055 Zirkle Ln Broadway, Virginia(VA), 22815 0 Accommodation Pro
41 Winterset Trl Tryon, North Carolina(NC), 28782 0 Accommodation Pro
group_no doc_no
3 881000
4 881001
3 881002
3 881003
3 881004
username place_of_issue number expiry_date
000001 United States 402967202 2025-11-21
000002 United States 530868265 2023-04-20
000003 United States 574323639 2024-02-03
000004 United States 306023259 2024-12-24
000005 United States 432231553 2025-01-15
group_no members start_date end_date
1 000010 2021-12-21 2021-12-29
2 000006 2021-11-13 2021-11-20
3 000007 2024-09-25 2024-10-15
4 000008 2022-11-23 2022-12-24
5 000009 2022-03-13 2022-04-19
group_no username
1 000010
2 000006
3 000007
4 000008
5 000009
payment_no payer_username total paid_50%_cc
8904356 000010 10,000.50 0
9505435 000006 20,000.00 1
8534530 000007 13,500.00 1
2345945 000008 12,500.50 0
5345065 000009 8,000.50 1
card_no expiration client_username
502350341233 2021-03-13 000010
593412458594 2022-05-21 000006
945324358493 2022-04-20 000007
593049543049 2022-12-01 000008
451394203942 2023-07-21 000009
reg_num status payments
444441 Approved 8904356
444442 Not Approved 9505435
444443 Approved 8534530
444444 Not Approved 2345945
444445 Approved 5345065
reg_number working is_DAP is_AP latitude longitude
444441 1 1 0 37.09024 -3.435976
444442 0 0 1 34.09024 121.774017
444443 1 1 0 78.09078 -80.191788
444444 1 1 0 55.378052 -3.435973
444445 1 1 0 40.712776 -74.005974
is_in_main_housno_of_rooms house_age
1 1 3
1 2 4
0 1 5
0 2 6
0 1 7
brgy_authentication
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
brgy_clearance
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
reg_number area_name
444441 photo of room
444442 comfort room
444443 current living
444444 interest guests
444445 main house
photo_link
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
https://drive.google.com/drive/folders/19JB2I3wCSJLmooPALuUPP8Kkdp3-Dqnm?usp=sharing
reg_num_id status
444441 For Approval
444442 For Approval
444443 For Approval
444444 NULL
444445 NULL
room_no services features isOpen
1 car rental services nice view 1
2 room service available near the river 1
3 valet parking near the dining area 1
4 catering services near the swimming pool 1
5 massages near the gym 1
service_no service_name
1 car rental services
2 room service available
3 valet parking
4 catering services
5 massages
feature_no service_name
1 nice view
2 near the river
3 near the dining area
4 near the swimming pool
5 near the gym
room_no no_beds features price_per_day booked_price
1 2 nice view 2,000.00 2,000.00
2 3 near the river 3,000.00 3,000.00
3 1 near the dining area 4,000.00 4,000.00
4 3 near the swimming pool 5,500.00 5,500.00
5 1 near the gym 6,000.00 6,000.00
isOpen
1
0
0
0
0
room_no isFullyRefunded
1 1
NULL NULL
NULL NULL
NULL NULL
NULL NULL
room_no bed toiletries beddings
1 500.00 50.00 100.00
2 600.00 50.00 100.00
3 700.00 50.00 200.00
4 700.00 50.00 100.00
5 800.00 50.00 150.00
room_no start end
1 9/10/2021 2:00:00 9/13/2021 12:00:00
2 9/9/2021 4:00:00 9/15/2021 9:00:00
3 9/12/2021 0:00:00 9/20/2021 2:00:00
4 9/13/2021 9:00:00 9/22/2021 8:00:00
5 9/10/2021 2:00:00 9/17/2021 12:00:00
add_bedd add_toiletries add_bedding confirmed
0 0 0 1
0 0 0 1
0 0 0 1
0 0 0 1
0 0 0 1
bookingID status date add_items
423112 COMPLETED 2021-09-15 0
431565 COMPLETED 2021-09-22 0
645876 COMPLETED 2021-09-17 0
876546 COMPLETED 2021-09-17 0
add_charges rating feedback_narrative
0 10 the rooms were clean, service was good
0 9 the rooms were clean, service was good
0 6 rooms were clean, service was good
0 8 rooms were clean, service was also good
id group_no
000006 3
NULL NULL
NULL NULL
NULL NULL
NULL NULL
id group_no
000011 4
null null
null null
null null
null null

You might also like