vtigercrm 数据结构
所有模块的基本表 vtiger_crmentity;
用户表 vtiger_users
数据字典表 vtiger_field
系统公告 vtiger_announcement
用户自定义视图 vtiger_customview
用户自定义视图块 vtiger_blocks
tabid 的取值 vtiger_tab
潜在客户地址 vtiger_leadaddress
潜在客户电话 vtiger_leaddetails
潜在客户自定义字段 vtiger_leadscf
取潜在客户信息常用sql:
select c.lead_no,c.email,c.firstname,c.lastname,b.city,b.country,b.phone,b.mobile,b.fax,b.lane
from vtiger_crmentity a,vtiger_leadaddress b,vtiger_leaddetails c,vtiger_leadscf d
where a.crmid = b.leadaddressid
and a.crmid = c.leadid
and a.crmid = d.leadid
and a.setype = 'Leads'
vtigercrm 程序结构: