crm_staging Database

TABLES 109

COLUMNS 1324

Constraints 146

Anomalies 26

Routines 0

Database Properties

Database Type: MySQL - 5.7.44-log

Tables

Table / View	Children	Parents	Columns	Rows	Type
appointments	0	2	11	0	Table
error_inquiry_messages	0	0	9	18	Table
notification_histories	0	0	12	6000	Table
error_reply_messages	0	0	7	0	Table
customers	23	1	48	144980	Table
visit_reservation_limit_people_settings	0	1	7	0	Table
analysis_summary_records	1	1	8	63	Table
company_feature_permission	0	2	4	6	Table
search_favorites	0	1	7	0	Table
failed_jobs	0	0	7	194	Table
message_template_folders	1	1	7	0	Table
export_analysis_csv_files	0	2	14	12	Table
estimation_jsb_details	0	2	69	0	Table
message_destinations	0	1	9	1208	Table
customer_statuses	1	1	10	44	Table
auto_suggestion_settings	0	1	13	3	Table
customer_interaction_histories	0	5	26	4085	Table
visit_reservations	1	2	20	0	Table
migrations	2	0	3	164	Table
jsb_campuses	0	1	10	0	Table
contact_rentals	0	1	11	5	Table
company_task_templates	0	1	7	35	Table
aggregation_candidates	0	2	3	552	Table
customer_addition_item_values	0	2	12	4800	Table
roles	2	1	7	5	Table
line_users	0	4	10	23	Table
analysis_summary_fields	0	2	9	218	Table
read_messages	0	2	3	317	Table
visit_reservation_settings	1	1	24	0	Table
message_read_times	0	3	7	27	Table
company_analysis_configs	1	1	9	27	Table
store_customer_event_dates	0	1	6	39	Table
analysis_log_per_customers	0	1	14	158224	Table
analysis_log_events	0	0	12	126	Table
visit_reservation_inquiry_rentals	0	2	5	0	Table
company_estimation_templates	1	1	7	0	Table
inquiry_definition_sorting_rules	0	1	6	8	Table
auto_suggestions	0	1	14	8	Table
aggregation_releases	0	2	5	6	Table
temporary_obic_customer_basic	2	4	171	5284	Table
web_meeting_durations	0	1	6	184	Table
messages	5	3	16	1423	Table
job_batches	9	0	10	0	Table
activity_exports	0	0	8	0	Table
companies	16	0	10	4	Table
temporary_obic_customer_supplement	0	1	3	0	Table
company_addition_item_options	1	1	8	364	Table
estimation_action_logs	0	2	8	0	Table
temporary_obic_customer_choice_school	0	1	9	0	Table
activity_logs	0	1	11	531	Table
relationship_candidates	0	2	3	35	Table
role_permissions	0	2	6	90	Table
telescope_entries_tags	0	1	2	44533	Table
virtual_bank_account_counters	0	1	5	0	Table
bulk_messages	1	2	12	34	Table
arrow_ip_addresses	0	1	5	0	Table
store_customers	15	9	18	158442	Table
api_versions	0	0	4	0	Table
error_other_messages	0	0	8	9	Table
access_count_urls	2	1	11	13	Table
search_histories	0	1	6	74	Table
bulk_operation_customer_lists	0	2	5	349	Table
inquiry_rentals	1	3	20	216	Table
store_suggestion_settings	0	1	10	2	Table
analysis_recounts	0	1	5	0	Table
nested_groups	3	2	7	20	Table
reserve_messages	0	1	7	0	Table
telescope_entries	1	0	8	113667	Table
feature_permissions	1	0	5	0	Table
telescope_monitoring	0	0	1	0	Table
suggestion_rental_details	0	1	5	67	Table
estimations	4	5	37	0	Table
company_addition_items	2	1	14	130	Table
suggestions	1	6	22	237	Table
inquiry_definition_items	0	1	9	48	Table
inquiries	2	2	28	228	Table
files	0	1	11	81	Table
virtual_bank_accounts	1	1	15	0	Table
company_settings	0	1	8	4	Table
store_settings	0	1	16	87	Table
favorite_rentals	0	1	12	9	Table
inquiry_forwarding_emails	0	1	5	1	Table
company_questionnaire_configs	0	1	7	4	Table
access_control_targets	5	0	6	17	Table
bulk_operation_histories	1	1	6	38	Table
line_channels	0	1	8	2	Table
task_settings	0	1	8	6	Table
staff_notification_settings	0	1	8	160	Table
advertising_media	2	1	7	23	Table
tasks	0	2	15	887	Table
access_count_logs	0	4	9	0	Table
stores	18	2	15	86	Table
message_templates	0	2	10	39	Table
aggregations	0	2	4	58	Table
staff_operable_nested_groups	0	2	4	183	Table
analysis_log_per_rentals	0	2	13	301	Table
staff_device_tokens	0	1	6	14	Table
web_meetings	1	3	22	70	Table
customer_access_logs	0	1	9	0	Table
reply_messages	0	0	5	0	Table
staff_settings	0	1	10	191	Table
analysis_summaries	1	2	6	12	Table
bulk_operation_history_customer	0	2	2	93	Table
relationships	0	2	5	28	Table
staffs	30	3	14	184	Table
inquiry_definitions	2	2	7	4	Table
inquiry_messages	0	0	5	0	Table
estimation_jsb_costs	0	1	43	0	Table
estimation_approvals	0	2	8	0	Table