[Vtigercrm-developers] Question on table: vtiger_crmentityrel

Adam Heinz amh at metricwise.net
Tue Aug 13 15:31:47 UTC 2013


Isn't vtiger_contactdetails.accountid a 1-to-many, whereas vtiger_crmentityrel
is a many-to-many?  It sounds like you're conflating fields.


On Tue, Aug 13, 2013 at 11:18 AM, Matt Zygowicz <goldsziggy at gmail.com>wrote:

> Greetings everybody,
>
> Just to start off, I am a first timer to the community and look forward to
> being apart of it.
>
> I had a question on when this particular table is used
> (vtiger_crmentityrel) it seems to relate crm entities but doesn't do it all
> the time.  I have multiple cases where a crmid for an Account is only
> matched up with one contact but under the table
> vtiger_contactdetails.accountid I have multiple listings for the specific
> account (as it should be)  I was wondering if this table serves a higher
> purpose than I am currently seeing and if so could this be elaborated on.
>  I looked over the datamodel for 5.2.1 and didn't see it listed their
> either (
> https://www.vtiger.com/products/crm/docs/510/vtigerCRM_DataModel_5.2.1.pdf
> )
>
> Thank you for all your help in advance,
> Matthew
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20130813/288a1188/attachment.html>


More information about the vtigercrm-developers mailing list