Database schema for -testfeb25-35303837372c

Tables with prefix ra

Table	Record count	Data size	Index size	Total size MB
j4_ra_api_sites	7	16,384	0	0.02
j4_ra_areas	59	49,152	16,384	0.06
j4_ra_bookings	1	16,384	32,768	0.05
j4_ra_builds	0	16,384	0	0.02
j4_ra_clusters	6	16,384	16,384	0.03
j4_ra_comments	0	16,384	65,536	0.08
j4_ra_control	3	16,384	0	0.02
j4_ra_delivery_events	29	81,920	65,536	0.14
j4_ra_emails	173	2,637,824	81,920	2.59
j4_ra_enhancements	21	16,384	65,536	0.08
j4_ra_events	42	98,304	32,768	0.13
j4_ra_event_states	4	16,384	0	0.02
j4_ra_event_types	4	16,384	0	0.02
j4_ra_extensions	13	16,384	0	0.02
j4_ra_extension_types	4	16,384	0	0.02
j4_ra_faults	220	98,304	65,536	0.16
j4_ra_fault_categories	44	16,384	81,920	0.09
j4_ra_fault_category	38	16,384	81,920	0.09
j4_ra_fault_statuses	9	16,384	81,920	0.09
j4_ra_fault_updates	6	16,384	81,920	0.09
j4_ra_groups	485	229,376	16,384	0.23
j4_ra_groups_old	462	196,608	16,384	0.20
j4_ra_import_reports	13	163,840	0	0.16
j4_ra_logfile	13,570	425,984	0	0.41
j4_ra_mail_access	3	16,384	0	0.02
j4_ra_mail_lists	6	16,384	32,768	0.05
j4_ra_mail_methods	6	16,384	0	0.02
j4_ra_mail_recipients	470	65,536	32,768	0.09
j4_ra_mail_shots	72	1,589,248	32,768	1.55
j4_ra_mail_subscriptions	156	16,384	49,152	0.06
j4_ra_mail_subscriptions_audit	1,731	212,992	49,152	0.25
j4_ra_nations	3	16,384	0	0.02
j4_ra_organisations	539	245,760	16,384	0.25
j4_ra_products	11	16,384	0	0.02
j4_ra_product_usage	1	16,384	16,384	0.03
j4_ra_profiles	170	262,144	32,768	0.28
j4_ra_profiles_audit	0	16,384	16,384	0.03
j4_ra_profiles_bak	376	65,536	16,384	0.08
j4_ra_roles	1	16,384	0	0.02
j4_ra_walks	50,747	37,306,368	9,535,488	44.67
j4_ra_walks_audit	0	16,384	16,384	0.03

Number of tables in -testfeb25-35303837372c: 42, Total size: 54.788096 MB

Testbed (old)

A test site that includes all components

Tables with prefix ra