user_id: 2
Weekdays : wp_amelia_providers_to_weekdays
id userId dayIndex startTime endTime
12 2 1 12:00:00 20:00:00
13 2 2 12:00:00 19:00:00
14 2 4 12:00:00 20:00:00
15 2 5 12:00:00 19:30:00
16 2 6 12:00:00 20:00:00
17 2 7 12:00:00 20:00:00
25 3 1 14:00:00 20:00:00
26 3 5 14:00:00 20:00:00
27 3 6 14:00:00 20:00:00
28 3 7 14:00:00 20:00:00
29 4 1 15:00:00 20:00:00
30 4 5 15:00:00 20:00:00
31 1 1 10:00:00 23:00:00
32 1 2 10:00:00 23:00:00
33 1 3 10:00:00 23:00:00
34 1 4 10:00:00 23:00:00
35 1 6 10:00:00 23:00:00
36 1 7 10:00:00 23:00:00
40 1 5 10:00:00 23:00:00
Periods : wp_amelia_providers_to_periods
id weekDayId locationId startTime endTime
12 12 1 12:00:00 20:00:00
13 13 1 12:00:00 17:00:00
14 14 1 12:00:00 20:00:00
15 15 1 12:00:00 19:30:00
16 16 1 12:00:00 20:00:00
17 17 1 12:00:00 20:00:00
25 13 1 18:00:00 19:00:00
26 25 1 14:00:00 20:00:00
27 26 1 14:00:00 20:00:00
28 27 1 14:00:00 20:00:00
29 28 1 14:00:00 20:00:00
30 29 1 15:00:00 20:00:00
31 30 1 15:00:00 20:00:00
32 31 2 10:00:00 23:00:00
33 32 2 10:00:00 23:00:00
34 33 2 10:00:00 23:00:00
35 34 2 10:00:00 23:00:00
36 35 2 10:00:00 23:00:00
37 36 2 10:00:00 23:00:00
41 40 2 10:00:00 23:00:00
Timeouts : wp_amelia_providers_to_timeouts
id weekDayId startTime endTime
1 12 13:00:00 15:00:00
Specialdays : wp_amelia_providers_to_specialdays
id userId startDate endDate
8 2 2022-08-02 2022-08-06
9 2 2022-07-27 2022-07-28
17 5 2022-09-03 2022-09-03
18 5 2022-09-17 2022-09-17
19 5 2022-09-24 2022-09-24
Specialdays Periods : wp_amelia_providers_to_specialdays_periods
id specialDayId locationId startTime endTime
9 8 1 16:30:00 19:00:00
10 9 4 06:30:00 12:30:00
18 17 3 12:00:00 17:00:00
19 18 3 12:00:00 17:00:00
20 19 3 12:00:00 17:00:00
Days Off : wp_amelia_providers_to_daysoff
id userId name startDate endDate repeat
4 2 ใƒ†ใ‚นใƒˆ 2022-07-26 2022-08-02 0
weekdayId userId date dayIndexKey weekdayJp startTime endTime periods
34 1 2024-05-30 4 10:00 23:00
10:0023:002
40 1 2024-05-31 5 10:00 23:00
10:0023:002
35 1 2024-06-01 6 10:00 23:00
10:0023:002
36 1 2024-06-02 7 10:00 23:00
10:0023:002
31 1 2024-06-03 1 10:00 23:00
10:0023:002
32 1 2024-06-04 2 10:00 23:00
10:0023:002
33 1 2024-06-05 3 10:00 23:00
10:0023:002
34 1 2024-06-06 4 10:00 23:00
10:0023:002
40 1 2024-06-07 5 10:00 23:00
10:0023:002
35 1 2024-06-08 6 10:00 23:00
10:0023:002
36 1 2024-06-09 7 10:00 23:00
10:0023:002
31 1 2024-06-10 1 10:00 23:00
10:0023:002
32 1 2024-06-11 2 10:00 23:00
10:0023:002
33 1 2024-06-12 3 10:00 23:00
10:0023:002
34 1 2024-06-13 4 10:00 23:00
10:0023:002
40 1 2024-06-14 5 10:00 23:00
10:0023:002
35 1 2024-06-15 6 10:00 23:00
10:0023:002
36 1 2024-06-16 7 10:00 23:00
10:0023:002
31 1 2024-06-17 1 10:00 23:00
10:0023:002
32 1 2024-06-18 2 10:00 23:00
10:0023:002
33 1 2024-06-19 3 10:00 23:00
10:0023:002
34 1 2024-06-20 4 10:00 23:00
10:0023:002
40 1 2024-06-21 5 10:00 23:00
10:0023:002
35 1 2024-06-22 6 10:00 23:00
10:0023:002
36 1 2024-06-23 7 10:00 23:00
10:0023:002
31 1 2024-06-24 1 10:00 23:00
10:0023:002
32 1 2024-06-25 2 10:00 23:00
10:0023:002
33 1 2024-06-26 3 10:00 23:00
10:0023:002
34 1 2024-06-27 4 10:00 23:00
10:0023:002
40 1 2024-06-28 5 10:00 23:00
10:0023:002
35 1 2024-06-29 6 10:00 23:00
10:0023:002
36 1 2024-06-30 7 10:00 23:00
10:0023:002
14 2 2024-05-30 4 12:00 20:00
12:0020:001
15 2 2024-05-31 5 12:00 19:30
12:0019:301
16 2 2024-06-01 6 12:00 20:00
12:0020:001
17 2 2024-06-02 7 12:00 20:00
12:0020:001
12 2 2024-06-03 1 12:00 20:00
12:0020:001
13 2 2024-06-04 2 12:00 19:00
12:0017:001
18:0019:001
14 2 2024-06-06 4 12:00 20:00
12:0020:001
15 2 2024-06-07 5 12:00 19:30
12:0019:301
16 2 2024-06-08 6 12:00 20:00
12:0020:001
17 2 2024-06-09 7 12:00 20:00
12:0020:001
12 2 2024-06-10 1 12:00 20:00
12:0020:001
13 2 2024-06-11 2 12:00 19:00
12:0017:001
18:0019:001
14 2 2024-06-13 4 12:00 20:00
12:0020:001
15 2 2024-06-14 5 12:00 19:30
12:0019:301
16 2 2024-06-15 6 12:00 20:00
12:0020:001
17 2 2024-06-16 7 12:00 20:00
12:0020:001
12 2 2024-06-17 1 12:00 20:00
12:0020:001
13 2 2024-06-18 2 12:00 19:00
12:0017:001
18:0019:001
14 2 2024-06-20 4 12:00 20:00
12:0020:001
15 2 2024-06-21 5 12:00 19:30
12:0019:301
16 2 2024-06-22 6 12:00 20:00
12:0020:001
17 2 2024-06-23 7 12:00 20:00
12:0020:001
12 2 2024-06-24 1 12:00 20:00
12:0020:001
13 2 2024-06-25 2 12:00 19:00
12:0017:001
18:0019:001
14 2 2024-06-27 4 12:00 20:00
12:0020:001
15 2 2024-06-28 5 12:00 19:30
12:0019:301
16 2 2024-06-29 6 12:00 20:00
12:0020:001
17 2 2024-06-30 7 12:00 20:00
12:0020:001
26 3 2024-05-31 5 14:00 20:00
14:0020:001
27 3 2024-06-01 6 14:00 20:00
14:0020:001
28 3 2024-06-02 7 14:00 20:00
14:0020:001
25 3 2024-06-03 1 14:00 20:00
14:0020:001
26 3 2024-06-07 5 14:00 20:00
14:0020:001
27 3 2024-06-08 6 14:00 20:00
14:0020:001
28 3 2024-06-09 7 14:00 20:00
14:0020:001
25 3 2024-06-10 1 14:00 20:00
14:0020:001
26 3 2024-06-14 5 14:00 20:00
14:0020:001
27 3 2024-06-15 6 14:00 20:00
14:0020:001
28 3 2024-06-16 7 14:00 20:00
14:0020:001
25 3 2024-06-17 1 14:00 20:00
14:0020:001
26 3 2024-06-21 5 14:00 20:00
14:0020:001
27 3 2024-06-22 6 14:00 20:00
14:0020:001
28 3 2024-06-23 7 14:00 20:00
14:0020:001
25 3 2024-06-24 1 14:00 20:00
14:0020:001
26 3 2024-06-28 5 14:00 20:00
14:0020:001
27 3 2024-06-29 6 14:00 20:00
14:0020:001
28 3 2024-06-30 7 14:00 20:00
14:0020:001
30 4 2024-05-31 5 15:00 20:00
15:0020:001
29 4 2024-06-03 1 15:00 20:00
15:0020:001
30 4 2024-06-07 5 15:00 20:00
15:0020:001
29 4 2024-06-10 1 15:00 20:00
15:0020:001
30 4 2024-06-14 5 15:00 20:00
15:0020:001
29 4 2024-06-17 1 15:00 20:00
15:0020:001
30 4 2024-06-21 5 15:00 20:00
15:0020:001
29 4 2024-06-24 1 15:00 20:00
15:0020:001
30 4 2024-06-28 5 15:00 20:00
15:0020:001