Class Records Table

Class Records

ZE Class ID	Instructor	Class Name	Date	Start Time	Status	parent_id	course_id	Braincert ID	end_time	classtimezone	ispaid	is_recurring	is_repeat	weekdays	end_classes_count	end_date	attendee_limit	recordclass	recording_id	recording_url	is_board	is_lang	region	duration	sync	vc_user_id	class_level	reserved	restricted	user_role	description
99837	214	1on1-25-Jim	2025-09-03	20:50	Past	99,837	0		21:20	65	0	0					1	0			0	0	10	1,800	1		daily_25	1	0	ALL	This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 25min lesson.
99853	223	1on1-25-Meg	2025-09-04	12:20	Past	99,853	0		12:50	65	0	0					1	0			0	0	10	1,800	1		daily_25	1	0	ALL	This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 25min lesson.
99994	214	1on1-25-Jim	2025-09-02	21:20	Past	99,994	0		21:50	65	0	0					1	0			0	0	10	1,800	1		daily_25	1	0	ALL	This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 25min lesson.
99995	214	1on1-25-Jim	2025-09-09	21:20	Past	99,995	0		21:50	65	0	0					1	0			0	0	10	1,800	1		daily_25	1	0	ALL	This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 25min lesson.
100151	214	1on1-25-Jim	2025-09-10	20:50	Past	100,151	0		21:20	65	0	0					1	0			0	0	10	1,800	1		daily_25	1	0	ALL	This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 25min lesson.
100152	214	1on1-25-Jim	2025-09-17	20:50	Past	100,152	0		21:20	65	0	0					1	0			0	0	10	1,800	1		daily_25	1	0	ALL	This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 25min lesson.
100153	214	1on1-45-Jim	2025-09-16	20:50	Past	100,153	0		21:50	65	0	0					1	0			0	0	10	3,600	1		daily_all	1	0	ALL	This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 45min lesson.
100154	178	1on1-45-Alex	2025-09-02	18:50	Past	100,154	0		19:50	65	0	0					1	0			0	0	10	3,600	1		daily_all	1	0	ALL	This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 45min lesson.
100158	212	1on1-25-Hana	2025-09-13	19:50	Past	100,158	0		20:20	65	0	0					1	0			0	0	10	1,800	1		daily_25	1	0	ALL	This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 25min lesson.
100161	212	1on1-45-Hana	2025-09-19	19:50	Past	100,161	0		20:50	65	0	0					1	0			0	0	10	3,600	1		daily_all	1	0	ALL	This class is a one to one class where the teacher will be able to focus on the student's English and help them improve as an individual. 45min lesson.
ZE Class ID	Instructor	Class Name	Date	Start Time	Status	parent_id	course_id	Braincert ID	end_time	classtimezone	ispaid	is_recurring	is_repeat	weekdays	end_classes_count	end_date	attendee_limit	recordclass	recording_id	recording_url	is_board	is_lang	region	duration	sync	vc_user_id	class_level	reserved	restricted	user_role	description

Attendance - Editable

ZE Class ID	Student ID	Teacher ID	Registered	Attended	Attendance ID	Level	level_date
87091	1518	1510	-1	0	177580
87096	1518	213	-1	0	177581
86916	1518	1510	-1	0	177582
86991	1518	213	-1	0	177583
86933	1518	1510	-1	0	177584
87011	1518	213	-1	0	177585
87036	1518	269	-1	0	177586
87162	1518	213	1	0	177588
87148	1518	213	-2	0	177589
87118	1518	213	1	0	177590
ZE Class ID	Student ID	Teacher ID	Registered	Attended	Attendance ID	Level	level_date

Allocated Hours

User ID	Allocated Hours	umeta_id	meta_key
77	8	8124	alloc_hrs
178	4	8130	alloc_hrs
90	11	8134	alloc_hrs
37	1	8138	alloc_hrs
179	1	8142	alloc_hrs
136	1	8144	alloc_hrs
133	9	8148	alloc_hrs
27	0	8152	alloc_hrs
194	4	8156	alloc_hrs
18	0	8160	alloc_hrs
User ID	Allocated Hours	umeta_id	meta_key

Unused Reservations

ZE Class ID	Class Name	Date	Teacher ID	User ID	registered	attended
100434	ASPJ3-4 Juanita	2025-09-02	1513	1272	-2	0
100433	ASPJ6 Juanita	2025-09-02	1513	1272	-2	0
100435	ASPJ4-5 Juanita	2025-09-02	1513	1452	-2	0
100435	ASPJ4-5 Juanita	2025-09-02	1513	1449	-2	0
100435	ASPJ4-5 Juanita	2025-09-02	1513	1272	-2	0
100436	ASPJ6 Juanita	2025-09-02	1513	1429	-2	0
100436	ASPJ6 Juanita	2025-09-02	1513	1847	-2	0
100437	ASPJ3-4 Juanita	2025-09-04	1513	1272	-2	0
100645	1on1-45 Dave	2025-09-22	201	192	-2	0
100950	1on1-25 Jim	2025-09-22	214	192	-2	0
ZE Class ID	Class Name	Date	Teacher ID	User ID	registered	attended

Memberpress Transactions

ID :

User ID :

Transaction Number :

Date Created :

ID	User ID	Transaction Number	Date Created
5	178	mp-txn-58e2f4ef1a6ab	2017-04-04 01:20
6	194	mp-txn-58e2f5ad2ff1c	2017-04-04 01:23
9	201	mp-txn-58e2f6f6b89e5	2017-04-04 01:29
19	212	mp-txn-58e2f9ec6f6e9	2017-04-04 01:42
20	213	mp-txn-58e2fa34274d3	2017-04-04 01:43
21	214	mp-txn-58e2fa7a219ea	2017-04-04 01:44
23	217	mp-txn-58e2faf8f148c	2017-04-04 01:46
24	218	mp-txn-58e2fb235c588	2017-04-04 01:47
29	223	mp-txn-58e2fc13c9432	2017-04-04 01:51
32	226	mp-txn-58e2fd0df367e	2017-04-04 01:55
ID	User ID	Transaction Number	Date Created