[Vtigercrm-developers] vtiger_cvcolumnlist.columnname vs vtiger_field

Prasad prasad at vtiger.com
Fri Mar 29 03:10:32 GMT 2013


Adam,

This is legacy design where the tablename, columnname is mixed with the
field data
to enable query to be built across different module. We will review this
when schema
restructuring is taken up.

Regards,
Prasad

*Connect with us on: *Twitter <http://twitter.com/vtigercrm> *I*
Facebook<http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>
 *I* Blog <http://blog.vtiger.com/>* I*
Wiki<http://wiki.vtiger.com/index.php/Main_Page>
 *I *Forums  <http://forums.vtiger.com/>*I* Website <http://vtiger.com/>


On Fri, Mar 29, 2013 at 3:14 AM, Adam Heinz <amh at metricwise.net> wrote:

> Can anyone explain to me why several columns from vtiger_field have been
> smashed together into vtiger_cvcolumnlist.columnname?  Seems like a great
> candidate for a fieldid foreign key.
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20130329/7483205f/attachment.html>


More information about the vtigercrm-developers mailing list