[Vtigercrm-developers] different modules sharing a common table?

[Prasad]

Alan,

As long as the field is mapped with target-table or column through
meta-data and
follows the Entity module convention system would continue to work.

Shared table pose challenge when different module records enables edits of
fields.
It would also come in the way of performance (specifically query cache
invalidation).

If modules are from different publishers then sharing table is not a good
idea,
as the control or convention can be too tedious to maintain / manage.

Regards,
Prasad


--
FB <http://www.facebook.com/vtiger> I Twit <http://twitter.com/vtigercrm> I
LIn <https://www.linkedin.com/company/1270573?trk=tyah> I Blog
<https://blogs.vtiger.com> I Website <https://www.vtiger.com/>

On Wed, Sep 21, 2016 at 8:51 PM, Alan Lord <alanslists at gmail.com> wrote:

> Suppose I want to create a bunch of new modules with a set of data fields,
> but each module will also need some specific fields unique to it.
>
> I can think of two ways of doing this:
>
> Use different basetables for each module's specific data and have a common
> related table to store the common data.
>
> or
>
> Use a common basetable and have different related tables for the specifics.
>
> These will all be entity records so will have unique crmids so I am
> wondering if there are any pros or cons to either approach.
>
> I am minded to go for the second approach personally...
>
> Cheers
>
> Al
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20160921/93db31f5/attachment.html>