The Db not have exactly 25 fields for table.
I have tables with 8 fields and tables with 70 or more.
Clientes have: Id, Name,Phone, fiscal number, etc…
Insurance Companys have: Id:, Number, Name, fiscal number , adrress, etc;
Area is like(health, insurance, car insurance, house) have: Company Id, Number, name of insurance area, etc.
For each area we have one form model and one specific table.
For example; Cars have the table model 1 is the CarTable
We have 15 different models. 15 different tables. one for houses, one for cars, one for work acidents, one for industry, etc.
Some areas like insurance health have other sub table, like for the name of each person in policy, you could have all family in one policy.
The policy table have the basic data of the policy: Id client, Id insurance, Id Area, Date of start, date of end, price comercial ammount, price total ammount, comission, etc, And the sub tables are the one i reffer upper.
Every table have when is created date, when is modified, who creates, who modified.
We also have table for receipts, with, client id, Client insurance company id, policy id, area id, price, commision, over comission, and lots more details.
We have other table with daily money in and out
We have other table for Acidents occured.
Other table for Payment we make to insurance company
Other table for payment company comission receipts
I not is is really bad design. I think is very extensive and could have lots of detailed data.
Policys. have : Client Id, Policy Number,