testing - Event Planners Alliance

First Name	Last Name	Transaction ID	Total	Completed Date
Julie	Nyaga		99.9800	2024-08-26 09:32:54
Julie	Nyaga	bt_6b81b917e62555532dbc2d2efeb2eff2	99.9800	2024-08-26 09:41:24
niharika	singh		99.9800
niharika	singh		0.0000	0000-00-00 00:00:00
EPA	EPA	bt_7eb47cde0ec4812717715d99ccec8d2b	999.0000	2024-08-26 09:42:48
Glodi Glam	Designs LLC		99.9800	0000-00-00 00:00:00
The Silent	Disco Company		99.9800	0000-00-00 00:00:00
Mr	Walter		99.9800	0000-00-00 00:00:00
			99.9800	0000-00-00 00:00:00
Mayowa	Olumuyiwa		99.9800	0000-00-00 00:00:00
			250.0000	2024-08-26 09:43:47
Lewis	Waiguru	bt_b2b2a97140499bb96fff9e9041b3f123	10.0000	2024-08-26 09:37:47
AEI	INSTITUTE	bt_7cb56550636f49ea7f85674c7d13ffc6	999.0000	2024-08-22 11:38:23
Lewis	Waiguru	bt_51142325ce2cea726828244444e590fd	999.0000	2024-08-26 09:36:11
Lewis	Waiguru	bt_7bbefa25509e4e92e284ef6327811c41	99.9800	2024-08-26 09:35:36
Lewis	Waiguru	trans_c269e9caa93f43bce4d2ba9c8a7ed02e	1.0000	2024-08-26 10:00:54
Lewis	Waiguru	ch_3PrxtJKZPrSowYAW0IFmwFH3	1.0000	2024-08-26 11:03:39
			99.9800
The Silent	Disco Company		99.9800
Ann	Ian		99.9800
cindy	chege	bt_1781a326e93a404799fd80a66a02e1d5	0.0000	2024-10-05 12:21:05

First Name

Last Name

Transaction ID

Total

Completed Date

Julie

Nyaga

99.9800

2024-08-26 09:32:54

Julie

Nyaga

bt_6b81b917e62555532dbc2d2efeb2eff2

99.9800

2024-08-26 09:41:24

niharika

singh

99.9800

niharika

singh

0.0000

0000-00-00 00:00:00

EPA

bt_7eb47cde0ec4812717715d99ccec8d2b

999.0000

2024-08-26 09:42:48

Glodi Glam

Designs LLC

99.9800

0000-00-00 00:00:00

The Silent

Disco Company

99.9800

0000-00-00 00:00:00

Walter

99.9800

0000-00-00 00:00:00

99.9800

0000-00-00 00:00:00

Mayowa

Olumuyiwa

99.9800

0000-00-00 00:00:00

250.0000

2024-08-26 09:43:47

Lewis

Waiguru

bt_b2b2a97140499bb96fff9e9041b3f123

10.0000

2024-08-26 09:37:47

AEI

INSTITUTE

bt_7cb56550636f49ea7f85674c7d13ffc6

999.0000

2024-08-22 11:38:23

Lewis

Waiguru

bt_51142325ce2cea726828244444e590fd

999.0000

2024-08-26 09:36:11

Lewis

Waiguru

bt_7bbefa25509e4e92e284ef6327811c41

99.9800

2024-08-26 09:35:36

Lewis

Waiguru

trans_c269e9caa93f43bce4d2ba9c8a7ed02e

1.0000

2024-08-26 10:00:54

Lewis

Waiguru

ch_3PrxtJKZPrSowYAW0IFmwFH3

1.0000

2024-08-26 11:03:39

99.9800

The Silent

Disco Company

99.9800

Ann

Ian

99.9800

cindy

chege

bt_1781a326e93a404799fd80a66a02e1d5

0.0000

2024-10-05 12:21:05

User ID	Email	First Name	Last Name
9	chegejulie@gmail.com	EPA	EPA
48	lellahfloral@gmail.com
819	machiuwaiguru77@gmail.com	Lewis	Waiguru
166	admin@aei.ac.ke	AEI	INSTITUTE
1114	epamembers@gmail.com	Chefs	On Legs
1098	ogadaben@gmail.com	Benard	Ogada
1111	ionegigz@gmail.com	Ibrahim	Kiama
1119	jngundi08@gmail.com	John	Mbithi
1127	edwinnganga61@gmail.com	edwin	nganga

User ID

Purchase Value

First Name

Last Name

chegejulie@gmail.com

0.000000000

EPA

lellahfloral@gmail.com

0.000000000

819

machiuwaiguru77@gmail.com

0.000000000

Lewis

Waiguru

166

admin@aei.ac.ke

0.000000000

AEI

INSTITUTE

1114

epamembers@gmail.com

0.000000000

Chefs

On Legs

1098

ogadaben@gmail.com

0.000000000

Benard

Ogada

1111

ionegigz@gmail.com

0.000000000

Ibrahim

Kiama

1119

jngundi08@gmail.com

0.000000000

John

Mbithi

1127

edwinnganga61@gmail.com

0.000000000

edwin

nganga

Table: wp_getpaid_customer_meta

meta_id - bigint(20)
customer_id - bigint(20)
meta_key - varchar(255)
meta_value - longtext

Table: wp_getpaid_customers

id - bigint(20)
user_id - bigint(20)
email - varchar(100)
email_cc - text
status - varchar(100)
purchase_value - decimal(18,9)
purchase_count - bigint(20)
first_name - varchar(100)
last_name - varchar(100)
address - varchar(100)
city - varchar(100)
country - varchar(2)
state - varchar(100)
zip - varchar(20)
phone - varchar(20)
company - varchar(100)
company_id - varchar(100)
date_created - datetime
date_modified - datetime
uuid - varchar(100)
vat_number - varchar(100)

Table: wp_getpaid_invoice_items

ID - bigint(20)
post_id - bigint(20)
item_id - bigint(20)
item_name - text
item_description - text
vat_rate - float
vat_class - varchar(100)
tax - decimal(16,4)
item_price - decimal(16,4)
custom_price - decimal(16,4)
quantity - decimal(16,4)
discount - decimal(16,4)
subtotal - decimal(16,4)
price - decimal(16,4)
meta - text
fees - text

Table: wp_getpaid_invoices

post_id - bigint(20)
number - varchar(100)
invoice_key - varchar(100)
type - varchar(100)
mode - varchar(100)
user_ip - varchar(100)
first_name - varchar(100)
last_name - varchar(100)
address - varchar(100)
city - varchar(100)
state - varchar(100)
country - varchar(100)
zip - varchar(100)
adddress_confirmed - int(10)
gateway - varchar(100)
transaction_id - varchar(100)
currency - varchar(10)
subtotal - decimal(16,4)
tax - decimal(16,4)
fees_total - decimal(16,4)
total - decimal(16,4)
discount - decimal(16,4)
discount_code - varchar(100)
disable_taxes - int(2)
due_date - datetime
completed_date - datetime
company - varchar(100)
vat_number - varchar(100)
vat_rate - varchar(100)
custom_meta - text
customer_id - bigint(20)

Table: wp_getpaid_reserved_stock

invoice_id - bigint(20)
item_id - bigint(20)
stock_quantity - double
timestamp - datetime
expires - datetime

wp_geodir_gd_event_detail

post_id (bigint(20))

post_title (text)

_search_title (text)

post_status (varchar(20))

post_tags (text)

post_category (text)

default_category (int(11))

featured (tinyint(1))

featured_image (varchar(254))

submit_ip (varchar(100))

overall_rating (float)

rating_count (int(11))

street (varchar(254))

street2 (varchar(254))

city (varchar(50))

region (varchar(50))

country (varchar(50))

zip (varchar(50))

latitude (varchar(22))

longitude (varchar(22))

mapview (varchar(15))

mapzoom (varchar(3))

recurring (tinyint(1))

event_dates (text)

phone (varchar(254))

email (varchar(254))

website (text)

twitter (text)

facebook (text)

video (text)

special_offers (text)

gd_place (text)

post_dummy (tinyint(1))

package_id (int(11))

expire_date (date)

rsvp_count (int(11))

neighbourhood (varchar(100))

claimed (int(11))

ratings (text)

wp_geodir_gd_place_detail

post_id (bigint(20))

post_title (text)

_search_title (text)

post_status (varchar(20))

post_tags (text)

post_category (text)

default_category (int(11))

featured (tinyint(1))

featured_image (varchar(254))

submit_ip (varchar(100))

overall_rating (float)

rating_count (int(11))

street (varchar(254))

street2 (varchar(254))

city (varchar(50))

region (varchar(50))

country (varchar(50))

zip (varchar(50))

latitude (varchar(22))

longitude (varchar(22))

mapview (varchar(15))

mapzoom (varchar(3))

business_hours (text)

logo (text)

facebook (text)

instagram (text)

website (text)

email (text)

twitter (text)

telephone_no (varchar(254))

terms_conditions (tinyint(1))

name_of_the_operator_ (varchar(254))

services_offered_list (text)

mission_and_vision_ (text)

professional_experience_ (text)

capacity_ (varchar(254))

major_projects_highlights_ (text)

government_certification_ (text)

honors_and_awards_if_any (text)

csr_activities_if_any (text)

post_dummy (tinyint(1))

phone (varchar(254))

claimed (int(11))

services_offered_ (text)

package_id (int(11))

expire_date (date)

neighbourhood (varchar(100))

accreditations__certifications__ (text)

ratings (text)

wp_geodir_gd_trainingcenter_detail

post_id (bigint(20))

post_title (text)

_search_title (text)

post_status (varchar(20))

post_tags (text)

post_category (text)

default_category (int(11))

featured (tinyint(1))

featured_image (varchar(254))

submit_ip (varchar(100))

overall_rating (float)

rating_count (int(11))

street (varchar(254))

street2 (varchar(254))

city (varchar(50))

region (varchar(50))

country (varchar(50))

zip (varchar(50))

latitude (varchar(22))

longitude (varchar(22))

mapview (varchar(15))

mapzoom (varchar(3))

claimed (int(11))

neighbourhood (varchar(100))

package_id (int(11))

expire_date (date)

ratings (text)

email (varchar(254))

phone_number (varchar(254))

current_institute_population_ (varchar(254))

type_of_learners (varchar(254))

wp_geodir_gd_venue_detail

post_id (bigint(20))

post_title (text)

_search_title (text)

post_status (varchar(20))

post_tags (text)

post_category (text)

default_category (int(11))

featured (tinyint(1))

featured_image (varchar(254))

submit_ip (varchar(100))

overall_rating (float)

rating_count (int(11))

street (varchar(254))

street2 (varchar(254))

city (varchar(50))

region (varchar(50))

country (varchar(50))

zip (varchar(50))

latitude (varchar(22))

longitude (varchar(22))

mapview (varchar(15))

mapzoom (varchar(3))

claimed (int(11))

neighbourhood (varchar(100))

package_id (int(11))

expire_date (date)

ratings (text)

price (decimal(16,2))

property_status (varchar(44))

property_type (varchar(315))

property_area (bigint(20))

property_features (text)

email (varchar(254))

phone_ (varchar(254))

post_dummy (tinyint(1))

phone (varchar(254))

website (text)

twitter (text)

facebook (text)

video (text)

special_offers (text)

business_hours (text)

wp_actionscheduler_actions

wp_actionscheduler_claims

wp_actionscheduler_groups

wp_actionscheduler_logs

wp_atbdp_review

wp_commentmeta

wp_comments

wp_countries

wp_e_events

wp_email_log

wp_email_user

wp_geodir_api_keys

wp_geodir_attachments

wp_geodir_business_hours

wp_geodir_claim

wp_geodir_comments_reviews

wp_geodir_cp_link_posts

wp_geodir_custom_advance_search_fields

wp_geodir_custom_fields

wp_geodir_custom_sort_fields

wp_geodir_event_schedule

wp_geodir_gd_event_detail

wp_geodir_gd_place_detail

wp_geodir_gd_trainingcenter_detail

wp_geodir_gd_venue_detail

wp_geodir_location_seo

wp_geodir_post_locations

wp_geodir_post_neighbourhood

wp_geodir_post_packages

wp_geodir_post_reports

wp_geodir_post_review

wp_geodir_price

wp_geodir_pricemeta

wp_geodir_rating_category

wp_geodir_rating_style

wp_geodir_tabs_layout

wp_geodir_term_meta

wp_geodir_tickets

wp_getpaid_customer_meta

wp_getpaid_customers

wp_getpaid_invoice_items

wp_getpaid_invoices

wp_getpaid_reserved_stock

wp_gglcptch_allowlist

wp_jetpack_sync_queue

wp_ld_course_time_spent

wp_ld_quiz_entries

wp_ld_time_entries

wp_learnpress_courses

wp_learnpress_files

wp_learnpress_order_itemmeta

wp_learnpress_order_items

wp_learnpress_question_answermeta

wp_learnpress_question_answers

wp_learnpress_question_answers_bk

wp_learnpress_quiz_questions

wp_learnpress_review_logs

wp_learnpress_section_items

wp_learnpress_sections

wp_learnpress_sessions

wp_learnpress_upgrade_db

wp_learnpress_user_item_results

wp_learnpress_user_itemmeta

wp_learnpress_user_itemmeta_bk

wp_learnpress_user_items

wp_learnpress_user_items_bk

wp_lifterlms_api_keys

wp_lifterlms_events

wp_lifterlms_events_open_sessions

wp_lifterlms_notifications

wp_lifterlms_product_to_voucher

wp_lifterlms_quiz_attempts

wp_lifterlms_sessions

wp_lifterlms_user_postmeta

wp_lifterlms_voucher_code_redemptions

wp_lifterlms_vouchers_codes

wp_lifterlms_webhooks

wp_links

wp_mystickymenu_contact_lists

wp_nf3_action_meta

wp_nf3_actions

wp_nf3_chunks

wp_nf3_field_meta

wp_nf3_fields

wp_nf3_form_meta

wp_nf3_forms

wp_nf3_object_meta

wp_nf3_objects

wp_nf3_relationships

wp_nf3_upgrades

wp_nl_subscriptions

wp_nm_personalized

wp_options

wp_options_bk

wp_podsrel

wp_postmeta

wp_postmeta_bk

wp_posts

wp_redirection_404

wp_redirection_groups

wp_redirection_items

wp_redirection_logs

wp_rmp_analytics

wp_smush_dir_images

wp_snippets

wp_stm_lms_curriculum_materials

wp_stm_lms_curriculum_sections

wp_stm_lms_order_items

wp_stm_lms_user_answers

wp_stm_lms_user_cart

wp_stm_lms_user_chat

wp_stm_lms_user_conversation

wp_stm_lms_user_courses

wp_stm_lms_user_lessons

wp_stm_lms_user_quizzes

wp_stm_lms_user_quizzes_times

wp_stm_lms_user_searches

wp_stm_lms_user_searches_stats

wp_term_relationships

wp_term_taxonomy

wp_termmeta

wp_terms

wp_thim_cache

wp_tm_taskmeta

wp_tm_tasks

wp_tutor_coupon_applications

wp_tutor_coupons

wp_tutor_customers

wp_tutor_earnings

wp_tutor_email_queue

wp_tutor_gradebooks

wp_tutor_gradebooks_results

wp_tutor_order_items

wp_tutor_ordermeta

wp_tutor_orders

wp_tutor_quiz_attempt_answers

wp_tutor_quiz_attempts

wp_tutor_quiz_question_answers

wp_tutor_quiz_questions

wp_tutor_withdraws

wp_usermeta

wp_users

wp_uwp_form_extras

wp_uwp_form_fields

wp_uwp_profile_tabs

wp_uwp_user_sorting

wp_uwp_usermeta

wp_votes_custom_field_contestant

wp_votes_custom_registeration_contestant

wp_votes_post_contestant_track

wp_votes_post_entry_contestant

wp_votes_tbl

wp_votes_user_entry_contestant

wp_wc_admin_note_actions

wp_wc_admin_notes

wp_wc_category_lookup

wp_wc_customer_lookup

wp_wc_download_log

wp_wc_order_addresses

wp_wc_order_coupon_lookup

wp_wc_order_operational_data

wp_wc_order_product_lookup

wp_wc_order_stats

wp_wc_order_tax_lookup

wp_wc_orders

wp_wc_orders_meta

wp_wc_product_attributes_lookup

wp_wc_product_download_directories

wp_wc_product_meta_lookup

wp_wc_rate_limits

wp_wc_reserved_stock

wp_wc_tax_rate_classes

wp_wc_webhooks

wp_weu_group27

wp_weu_sent_email

wp_weu_smtp_conf

wp_weu_subscribers

wp_weu_unsubscriber

wp_weu_user_notification

wp_woocommerce_api_keys

wp_woocommerce_attribute_taxonomies

wp_woocommerce_downloadable_product_permissions

wp_woocommerce_log

wp_woocommerce_order_itemmeta

wp_woocommerce_order_items

wp_woocommerce_payment_tokenmeta

wp_woocommerce_payment_tokens

wp_woocommerce_sessions

wp_woocommerce_shipping_zone_locations

wp_woocommerce_shipping_zone_methods

wp_woocommerce_shipping_zones

wp_woocommerce_tax_rate_locations

wp_woocommerce_tax_rates

wp_wow_fbtnp

wp_wpforms_tasks_meta

wp_wpfront_ure_login_redirect

wp_wpfront_ure_options

wp_wpfront_ure_post_type

wp_wpfront_ure_taxonomy

wp_wpinv_subscriptions

wp_wpinv_wallet_balance

wp_wpinv_wallet_transactions

wp_wpmailsmtp_debug_events

wp_wpmailsmtp_tasks_meta

wp_wpo_404_detector

wp_wppm_attachments

wp_wppm_checklist

wp_wppm_checklist_items

wp_wppm_project

wp_wppm_project_categories

wp_wppm_project_comment

wp_wppm_project_comment_meta

wp_wppm_project_meta

wp_wppm_project_statuses

wp_wppm_project_users

wp_wppm_task

wp_wppm_task_comment

wp_wppm_task_comment_meta

wp_wppm_task_meta

wp_wppm_task_priorities

wp_wppm_task_statuses

wp_wpuf_subscribers

wp_wpuf_transaction

wp_wrld_cached_entries

wp_ycd_subscribers

wp_yoast_indexable

wp_yoast_indexable_hierarchy

wp_yoast_migrations

wp_yoast_primary_term

wp_yoast_seo_links

wp_yoast_seo_meta

Become a member