DB table accounts_cases on fresh install 7.14

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

Hi,

i am not sure if this is issue or i read wrong the docs, but on instal or install with demo data i see the table accounts_cases

My question is: is the table accounts_cases the issue which have any relevance and should be deleted and mark as bug on github for SuiteCRM 7.14 ???

https://schema--suitecrm-docs.netlify.app/schema/tables/accounts_cases

But fist there is issue with diagram and also in module/Accounts/varders.php there is only relationship between primary Accounts and children Cases as ONE TO MANY relationship.

In cases DB talble i see account_id cases - suitecrm Database

I am confused from this table in database or has some secret reason :smile: ???

#2

The schema had not been updated for years, unfortunately.

Why do you think this table shouldn’t exist? Isn’t it a typical relationship table between two related core modules?

#3

Hi, when you have relationship one-to-many that means every CASE can have only one ACCOUNT and that if you look to CASE table field, you will find there accound_ID field from which you can get the account id and if you want get how many CASES use/are under ACCOUNT id it is created index idx_account_id which collect this information.

By study of relationship by migration from old SuiteCRM to fresh new one 7.14 i see that this table has any reason to be created and it’s bug.

This table should have only relevance if will between cases and accounts, where account will primary side the relationship many to many. But on fresh install there is no relationship.

#4

Ok. I suppose that the migration avoids deleting tables.

But if you are almost sure it’s not needed, then try returning it to something else, and see if anything breaks. If after a while you conclude it’s really trash, the delete it.