The following table contains the description of all the tables used by vTiger CRM 5.1.0 in the mysql database.

We had to extract this information to find all the fields which store prices in order to extend decimals.

Table name Field Type Null Key Default Extra
com_vtiger_workflow_activatedonce workflow_id int(11) NO PRI NULL  
com_vtiger_workflow_activatedonce entity_id int(11) NO PRI NULL  
Table Field Type Null Key Default Extra
com_vtiger_workflows workflow_id int(11) NO PRI NULL auto_increment
com_vtiger_workflows module_name varchar(100) YES   NULL  
com_vtiger_workflows summary varchar(400) NO   NULL  
com_vtiger_workflows test text YES   NULL  
com_vtiger_workflows execution_condition int(11) NO   NULL  
Table Field Type Null Key Default Extra
com_vtiger_workflows_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
com_vtiger_workflowtask_queue task_id int(11) YES MUL NULL  
com_vtiger_workflowtask_queue entity_id varchar(100) YES   NULL  
com_vtiger_workflowtask_queue do_after int(11) YES   NULL  
Table Field Type Null Key Default Extra
com_vtiger_workflowtasks task_id int(11) NO PRI NULL auto_increment
com_vtiger_workflowtasks workflow_id int(11) YES   NULL  
com_vtiger_workflowtasks summary varchar(400) NO   NULL  
com_vtiger_workflowtasks task text YES   NULL  
Table Field Type Null Key Default Extra
com_vtiger_workflowtasks_entitymethod workflowtasks_entitymethod_id int(11) NO PRI NULL  
com_vtiger_workflowtasks_entitymethod module_name varchar(100) YES   NULL  
com_vtiger_workflowtasks_entitymethod method_name varchar(100) YES   NULL  
com_vtiger_workflowtasks_entitymethod function_path varchar(400) YES   NULL  
com_vtiger_workflowtasks_entitymethod function_name varchar(100) YES   NULL  
Table Field Type Null Key Default Extra
com_vtiger_workflowtasks_entitymethod_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
com_vtiger_workflowtasks_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
com_vtiger_workflowtemplates template_id int(11) NO PRI NULL auto_increment
com_vtiger_workflowtemplates module_name varchar(100) YES   NULL  
com_vtiger_workflowtemplates title varchar(400) YES   NULL  
com_vtiger_workflowtemplates template text YES   NULL  
Table Field Type Null Key Default Extra
vtiger_account accountid int(19) NO PRI 0  
vtiger_account account_no varchar(100) NO   NULL  
vtiger_account accountname varchar(100) NO   NULL  
vtiger_account parentid int(19) YES   0  
vtiger_account account_type varchar(200) YES MUL NULL  
vtiger_account industry varchar(200) YES   NULL  
vtiger_account annualrevenue int(19) YES   0  
vtiger_account rating varchar(200) YES   NULL  
vtiger_account ownership varchar(50) YES   NULL  
vtiger_account siccode varchar(50) YES   NULL  
vtiger_account tickersymbol varchar(30) YES   NULL  
vtiger_account phone varchar(30) YES   NULL  
vtiger_account otherphone varchar(30) YES   NULL  
vtiger_account email1 varchar(100) YES   NULL  
vtiger_account email2 varchar(100) YES   NULL  
vtiger_account website varchar(100) YES   NULL  
vtiger_account fax varchar(30) YES   NULL  
vtiger_account employees int(10) YES   0  
vtiger_account emailoptout varchar(3) YES   0  
vtiger_account notify_owner varchar(3) YES   0  
Table Field Type Null Key Default Extra
vtiger_accountbillads accountaddressid int(19) NO PRI 0  
vtiger_accountbillads bill_city varchar(30) YES   NULL  
vtiger_accountbillads bill_code varchar(30) YES   NULL  
vtiger_accountbillads bill_country varchar(30) YES   NULL  
vtiger_accountbillads bill_state varchar(30) YES   NULL  
vtiger_accountbillads bill_street varchar(250) YES   NULL  
vtiger_accountbillads bill_pobox varchar(30) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_accountdepstatus deploymentstatusid int(19) NO PRI NULL auto_increment
vtiger_accountdepstatus deploymentstatus varchar(200) NO UNI NULL  
vtiger_accountdepstatus sortorderid int(19) NO   0  
vtiger_accountdepstatus presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_accountownership acctownershipid int(19) NO PRI NULL auto_increment
vtiger_accountownership ownership varchar(200) NO UNI NULL  
vtiger_accountownership sortorderid int(19) NO   0  
vtiger_accountownership presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_accountrating accountratingid int(19) NO PRI NULL auto_increment
vtiger_accountrating rating varchar(200) NO UNI NULL  
vtiger_accountrating sortorderid int(19) NO   0  
vtiger_accountrating presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_accountregion accountregionid int(19) NO PRI NULL auto_increment
vtiger_accountregion region varchar(200) NO UNI NULL  
vtiger_accountregion sortorderid int(19) NO   0  
vtiger_accountregion presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_accountscf accountid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_accountshipads accountaddressid int(19) NO PRI 0  
vtiger_accountshipads ship_city varchar(30) YES   NULL  
vtiger_accountshipads ship_code varchar(30) YES   NULL  
vtiger_accountshipads ship_country varchar(30) YES   NULL  
vtiger_accountshipads ship_state varchar(30) YES   NULL  
vtiger_accountshipads ship_pobox varchar(30) YES   NULL  
vtiger_accountshipads ship_street varchar(250) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_accounttype accounttypeid int(19) NO PRI NULL auto_increment
vtiger_accounttype accounttype varchar(200) NO UNI NULL  
vtiger_accounttype presence int(1) NO   1  
vtiger_accounttype picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_accounttype_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_actionmapping actionid int(19) NO PRI NULL  
vtiger_actionmapping actionname varchar(200) NO PRI NULL  
vtiger_actionmapping securitycheck int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_activity activityid int(19) NO PRI 0  
vtiger_activity subject varchar(100) NO   NULL  
vtiger_activity semodule varchar(20) YES   NULL  
vtiger_activity activitytype varchar(200) NO MUL NULL  
vtiger_activity date_start date NO MUL NULL  
vtiger_activity due_date date YES   NULL  
vtiger_activity time_start varchar(50) YES   NULL  
vtiger_activity time_end varchar(50) YES   NULL  
vtiger_activity sendnotification varchar(3) NO   0  
vtiger_activity duration_hours varchar(200) YES   NULL  
vtiger_activity duration_minutes varchar(200) YES   NULL  
vtiger_activity status varchar(200) YES MUL NULL  
vtiger_activity eventstatus varchar(200) YES MUL NULL  
vtiger_activity priority varchar(200) YES   NULL  
vtiger_activity location varchar(150) YES   NULL  
vtiger_activity notime varchar(3) NO   0  
vtiger_activity visibility varchar(50) NO   all  
vtiger_activity recurringtype varchar(200) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_activity_reminder activity_id int(11) NO PRI NULL  
vtiger_activity_reminder reminder_time int(11) NO   NULL  
vtiger_activity_reminder reminder_sent int(2) NO   NULL  
vtiger_activity_reminder recurringid int(19) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_activity_reminder_popup reminderid int(19) NO PRI NULL auto_increment
vtiger_activity_reminder_popup semodule varchar(100) NO   NULL  
vtiger_activity_reminder_popup recordid int(19) NO   NULL  
vtiger_activity_reminder_popup date_start date NO   NULL  
vtiger_activity_reminder_popup time_start varchar(100) NO   NULL  
vtiger_activity_reminder_popup status int(2) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_activity_view activity_viewid int(19) NO PRI NULL auto_increment
vtiger_activity_view activity_view varchar(200) NO   NULL  
vtiger_activity_view sortorderid int(19) NO   0  
vtiger_activity_view presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_activity_view_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_activitycf activityid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_activityproductrel activityid int(19) NO PRI 0  
vtiger_activityproductrel productid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_activitytype activitytypeid int(19) NO PRI NULL auto_increment
vtiger_activitytype activitytype varchar(200) NO UNI NULL  
vtiger_activitytype presence int(1) NO   1  
vtiger_activitytype picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_activitytype_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_activsubtype activesubtypeid int(19) NO PRI NULL auto_increment
vtiger_activsubtype activsubtype varchar(100) YES   NULL  
vtiger_activsubtype sortorderid int(19) NO   0  
vtiger_activsubtype presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_announcement creatorid int(19) NO PRI NULL  
vtiger_announcement announcement text YES   NULL  
vtiger_announcement title varchar(255) YES   NULL  
vtiger_announcement time timestamp NO   CURRENT_TIMESTAMP  
Table Field Type Null Key Default Extra
vtiger_asterisk server varchar(30) YES   NULL  
vtiger_asterisk port varchar(30) YES   NULL  
vtiger_asterisk username varchar(50) YES   NULL  
vtiger_asterisk password varchar(50) YES   NULL  
vtiger_asterisk version varchar(50) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_asteriskextensions userid int(11) YES   NULL  
vtiger_asteriskextensions asterisk_extension varchar(50) YES   NULL  
vtiger_asteriskextensions use_asterisk varchar(3) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_asteriskincomingcalls from_number varchar(50) YES   NULL  
vtiger_asteriskincomingcalls from_name varchar(50) YES   NULL  
vtiger_asteriskincomingcalls to_number varchar(50) YES   NULL  
vtiger_asteriskincomingcalls callertype varchar(30) YES   NULL  
vtiger_asteriskincomingcalls flag int(19) YES   NULL  
vtiger_asteriskincomingcalls timer int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_asteriskoutgoingcalls userid int(11) YES   NULL  
vtiger_asteriskoutgoingcalls from_number varchar(50) YES   NULL  
vtiger_asteriskoutgoingcalls to_number varchar(30) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_attachments attachmentsid int(19) NO PRI NULL  
vtiger_attachments name varchar(255) NO   NULL  
vtiger_attachments description text YES   NULL  
vtiger_attachments type varchar(100) YES   NULL  
vtiger_attachments path text YES   NULL  
vtiger_attachments subject varchar(255) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_attachmentsfolder folderid int(19) NO PRI NULL auto_increment
vtiger_attachmentsfolder foldername varchar(200) NO   NULL  
vtiger_attachmentsfolder description varchar(250) YES   NULL  
vtiger_attachmentsfolder createdby int(19) NO   NULL  
vtiger_attachmentsfolder sequence int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_attachmentsfolder_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_audit_trial auditid int(19) NO PRI NULL  
vtiger_audit_trial userid int(19) YES   NULL  
vtiger_audit_trial module varchar(255) YES   NULL  
vtiger_audit_trial action varchar(255) YES   NULL  
vtiger_audit_trial recordid varchar(20) YES   NULL  
vtiger_audit_trial actiondate datetime YES   NULL  
Table Field Type Null Key Default Extra
vtiger_blocks blockid int(19) NO PRI NULL  
vtiger_blocks tabid int(19) NO MUL NULL  
vtiger_blocks blocklabel varchar(100) NO   NULL  
vtiger_blocks sequence int(10) YES   NULL  
vtiger_blocks show_title int(2) YES   NULL  
vtiger_blocks visible int(2) NO   0  
vtiger_blocks create_view int(2) NO   0  
vtiger_blocks edit_view int(2) NO   0  
vtiger_blocks detail_view int(2) NO   0  
vtiger_blocks display_status int(1) NO   1  
vtiger_blocks iscustom int(1) NO   0  
Table Field Type Null Key Default Extra
vtiger_blocks_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_businesstype businesstypeid int(19) NO PRI NULL auto_increment
vtiger_businesstype businesstype varchar(200) NO UNI NULL  
vtiger_businesstype sortorderid int(19) NO   0  
vtiger_businesstype presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_campaign campaign_no varchar(100) NO   NULL  
vtiger_campaign campaignname varchar(255) YES MUL NULL  
vtiger_campaign campaigntype varchar(200) YES   NULL  
vtiger_campaign campaignstatus varchar(200) YES MUL NULL  
vtiger_campaign expectedrevenue decimal(25,3) YES   NULL  
vtiger_campaign budgetcost decimal(25,3) YES   NULL  
vtiger_campaign actualcost decimal(25,3) YES   NULL  
vtiger_campaign expectedresponse varchar(200) YES   NULL  
vtiger_campaign numsent decimal(11,0) YES   NULL  
vtiger_campaign product_id int(19) YES   NULL  
vtiger_campaign sponsor varchar(255) YES   NULL  
vtiger_campaign targetaudience varchar(255) YES   NULL  
vtiger_campaign targetsize int(19) YES   NULL  
vtiger_campaign expectedresponsecount int(19) YES   NULL  
vtiger_campaign expectedsalescount int(19) YES   NULL  
vtiger_campaign expectedroi decimal(25,3) YES   NULL  
vtiger_campaign actualresponsecount int(19) YES   NULL  
vtiger_campaign actualsalescount int(19) YES   NULL  
vtiger_campaign actualroi decimal(25,3) YES   NULL  
vtiger_campaign campaignid int(19) NO PRI NULL  
vtiger_campaign closingdate date YES   NULL  
Table Field Type Null Key Default Extra
vtiger_campaigncontrel campaignid int(19) NO PRI 0  
vtiger_campaigncontrel contactid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_campaignleadrel campaignid int(19) NO PRI 0  
vtiger_campaignleadrel leadid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_campaignscf campaignid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_campaignstatus campaignstatusid int(19) NO PRI NULL auto_increment
vtiger_campaignstatus campaignstatus varchar(200) NO MUL NULL  
vtiger_campaignstatus presence int(1) NO   1  
vtiger_campaignstatus picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_campaignstatus_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_campaigntype campaigntypeid int(19) NO PRI NULL auto_increment
vtiger_campaigntype campaigntype varchar(200) NO UNI NULL  
vtiger_campaigntype presence int(1) NO   1  
vtiger_campaigntype picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_campaigntype_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_carrier carrierid int(19) NO PRI NULL auto_increment
vtiger_carrier carrier varchar(200) NO UNI NULL  
vtiger_carrier presence int(1) NO   1  
vtiger_carrier picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_carrier_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_cf_538 cf_538id int(19) NO PRI NULL auto_increment
vtiger_cf_538 cf_538 varchar(200) NO   NULL  
vtiger_cf_538 presence int(1) NO   1  
vtiger_cf_538 picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_cf_538_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_cf_540 cf_540id int(19) NO PRI NULL auto_increment
vtiger_cf_540 cf_540 varchar(200) NO   NULL  
vtiger_cf_540 presence int(1) NO   1  
vtiger_cf_540 picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_cf_540_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_chat_msg id int(20) NO PRI NULL auto_increment
vtiger_chat_msg chat_from int(20) NO MUL 0  
vtiger_chat_msg chat_to int(20) NO MUL 0  
vtiger_chat_msg born datetime YES MUL NULL  
vtiger_chat_msg msg varchar(255) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_chat_pchat id int(20) NO PRI NULL auto_increment
vtiger_chat_pchat msg int(20) YES UNI 0  
Table Field Type Null Key Default Extra
vtiger_chat_pvchat id int(20) NO PRI NULL auto_increment
vtiger_chat_pvchat msg int(20) YES UNI 0  
Table Field Type Null Key Default Extra
vtiger_chat_users id int(20) NO PRI NULL auto_increment
vtiger_chat_users nick varchar(50) NO MUL NULL  
vtiger_chat_users session varchar(50) NO MUL NULL  
vtiger_chat_users ip varchar(20) NO   000.000.000.000  
vtiger_chat_users ping datetime YES MUL NULL  
Table Field Type Null Key Default Extra
vtiger_cntactivityrel contactid int(19) NO PRI 0  
vtiger_cntactivityrel activityid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_competitor competitorid int(19) NO PRI NULL  
vtiger_competitor competitorname varchar(100) NO   NULL  
vtiger_competitor website varchar(100) YES   NULL  
vtiger_competitor strength varchar(250) YES   NULL  
vtiger_competitor weakness varchar(250) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_contactaddress contactaddressid int(19) NO PRI 0  
vtiger_contactaddress mailingcity varchar(40) YES   NULL  
vtiger_contactaddress mailingstreet varchar(250) YES   NULL  
vtiger_contactaddress mailingcountry varchar(40) YES   NULL  
vtiger_contactaddress othercountry varchar(30) YES   NULL  
vtiger_contactaddress mailingstate varchar(30) YES   NULL  
vtiger_contactaddress mailingpobox varchar(30) YES   NULL  
vtiger_contactaddress othercity varchar(40) YES   NULL  
vtiger_contactaddress otherstate varchar(50) YES   NULL  
vtiger_contactaddress mailingzip varchar(30) YES   NULL  
vtiger_contactaddress otherzip varchar(30) YES   NULL  
vtiger_contactaddress otherstreet varchar(250) YES   NULL  
vtiger_contactaddress otherpobox varchar(30) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_contactdetails contactid int(19) NO PRI 0  
vtiger_contactdetails contact_no varchar(100) NO   NULL  
vtiger_contactdetails accountid int(19) YES MUL NULL  
vtiger_contactdetails salutation varchar(200) YES   NULL  
vtiger_contactdetails firstname varchar(40) YES   NULL  
vtiger_contactdetails lastname varchar(80) NO   NULL  
vtiger_contactdetails email varchar(100) YES   NULL  
vtiger_contactdetails phone varchar(50) YES   NULL  
vtiger_contactdetails mobile varchar(50) YES   NULL  
vtiger_contactdetails title varchar(50) YES   NULL  
vtiger_contactdetails department varchar(30) YES   NULL  
vtiger_contactdetails fax varchar(50) YES   NULL  
vtiger_contactdetails reportsto varchar(30) YES   NULL  
vtiger_contactdetails training varchar(50) YES   NULL  
vtiger_contactdetails usertype varchar(50) YES   NULL  
vtiger_contactdetails contacttype varchar(50) YES   NULL  
vtiger_contactdetails otheremail varchar(100) YES   NULL  
vtiger_contactdetails yahooid varchar(100) YES   NULL  
vtiger_contactdetails donotcall varchar(3) YES   NULL  
vtiger_contactdetails emailoptout varchar(3) YES   0  
vtiger_contactdetails imagename varchar(150) YES   NULL  
vtiger_contactdetails reference varchar(3) YES   NULL  
vtiger_contactdetails notify_owner varchar(3) YES   0  
Table Field Type Null Key Default Extra
vtiger_contactscf contactid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_contactsubdetails contactsubscriptionid int(19) NO PRI 0  
vtiger_contactsubdetails homephone varchar(50) YES   NULL  
vtiger_contactsubdetails otherphone varchar(50) YES   NULL  
vtiger_contactsubdetails assistant varchar(30) YES   NULL  
vtiger_contactsubdetails assistantphone varchar(50) YES   NULL  
vtiger_contactsubdetails birthday date YES   NULL  
vtiger_contactsubdetails laststayintouchrequest int(30) YES   0  
vtiger_contactsubdetails laststayintouchsavedate int(19) YES   0  
vtiger_contactsubdetails leadsource varchar(200) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_contacttype contacttypeid int(19) NO PRI NULL auto_increment
vtiger_contacttype contacttype varchar(200) NO UNI NULL  
vtiger_contacttype sortorderid int(19) NO   0  
vtiger_contacttype presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_contpotentialrel contactid int(19) NO PRI 0  
vtiger_contpotentialrel potentialid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_contract_priority contract_priorityid int(11) NO PRI NULL auto_increment
vtiger_contract_priority contract_priority varchar(200) NO   NULL  
vtiger_contract_priority presence int(1) NO   1  
vtiger_contract_priority picklist_valueid int(11) NO   0  
Table Field Type Null Key Default Extra
vtiger_contract_priority_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_contract_status contract_statusid int(11) NO PRI NULL auto_increment
vtiger_contract_status contract_status varchar(200) NO   NULL  
vtiger_contract_status presence int(1) NO   1  
vtiger_contract_status picklist_valueid int(11) NO   0  
Table Field Type Null Key Default Extra
vtiger_contract_status_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_contract_type contract_typeid int(11) NO PRI NULL auto_increment
vtiger_contract_type contract_type varchar(200) NO   NULL  
vtiger_contract_type presence int(1) NO   1  
vtiger_contract_type picklist_valueid int(11) NO   0  
Table Field Type Null Key Default Extra
vtiger_contract_type_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_convertleadmapping cfmid int(19) NO PRI NULL auto_increment
vtiger_convertleadmapping leadfid int(19) NO   NULL  
vtiger_convertleadmapping accountfid int(19) YES   NULL  
vtiger_convertleadmapping contactfid int(19) YES   NULL  
vtiger_convertleadmapping potentialfid int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_crmentity crmid int(19) NO PRI NULL  
vtiger_crmentity smcreatorid int(19) NO MUL 0  
vtiger_crmentity smownerid int(19) NO MUL 0  
vtiger_crmentity modifiedby int(19) NO MUL 0  
vtiger_crmentity setype varchar(30) NO   NULL  
vtiger_crmentity description text YES   NULL  
vtiger_crmentity createdtime datetime NO   NULL  
vtiger_crmentity modifiedtime datetime NO   NULL  
vtiger_crmentity viewedtime datetime YES   NULL  
vtiger_crmentity status varchar(50) YES   NULL  
vtiger_crmentity version int(19) NO   0  
vtiger_crmentity presence int(1) YES   1  
vtiger_crmentity deleted int(1) NO MUL 0  
Table Field Type Null Key Default Extra
vtiger_crmentity_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_crmentitynotesrel crmid int(19) NO PRI 0  
vtiger_crmentitynotesrel notesid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_crmentityrel crmid int(11) NO   NULL  
vtiger_crmentityrel module varchar(100) NO   NULL  
vtiger_crmentityrel relcrmid int(11) NO   NULL  
vtiger_crmentityrel relmodule varchar(100) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_currencies currencyid int(19) NO PRI NULL auto_increment
vtiger_currencies currency_name varchar(200) YES   NULL  
vtiger_currencies currency_code varchar(50) YES   NULL  
vtiger_currencies currency_symbol varchar(11) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_currencies_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_currency currencyid int(19) NO PRI NULL auto_increment
vtiger_currency currency varchar(200) NO UNI NULL  
vtiger_currency sortorderid int(19) NO   0  
vtiger_currency presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_currency_info id int(11) NO PRI NULL auto_increment
vtiger_currency_info currency_name varchar(100) YES   NULL  
vtiger_currency_info currency_code varchar(100) YES   NULL  
vtiger_currency_info currency_symbol varchar(30) YES   NULL  
vtiger_currency_info conversion_rate decimal(10,3) YES   NULL  
vtiger_currency_info currency_status varchar(25) YES   NULL  
vtiger_currency_info defaultid varchar(10) NO   0  
vtiger_currency_info deleted int(1) NO   0  
Table Field Type Null Key Default Extra
vtiger_currency_info_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_customaction cvid int(19) NO MUL NULL  
vtiger_customaction subject varchar(250) NO   NULL  
vtiger_customaction module varchar(50) NO   NULL  
vtiger_customaction content text YES   NULL  
Table Field Type Null Key Default Extra
vtiger_customerdetails customerid int(19) NO PRI NULL  
vtiger_customerdetails portal varchar(3) YES   NULL  
vtiger_customerdetails support_start_date date YES   NULL  
vtiger_customerdetails support_end_date date YES   NULL  
Table Field Type Null Key Default Extra
vtiger_customerportal_fields tabid int(19) NO   NULL  
vtiger_customerportal_fields fieldid int(19) YES   NULL  
vtiger_customerportal_fields visible int(1) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_customerportal_prefs tabid int(11) NO MUL NULL  
vtiger_customerportal_prefs prefkey varchar(100) YES   NULL  
vtiger_customerportal_prefs prefvalue int(20) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_customerportal_tabs tabid int(19) NO PRI NULL  
vtiger_customerportal_tabs visible int(1) YES   1  
vtiger_customerportal_tabs sequence int(1) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_customview cvid int(19) NO PRI NULL  
vtiger_customview viewname varchar(100) NO   NULL  
vtiger_customview setdefault int(1) YES   0  
vtiger_customview setmetrics int(1) YES   0  
vtiger_customview entitytype varchar(25) NO MUL NULL  
vtiger_customview status int(1) YES   1  
vtiger_customview userid int(19) YES   1  
Table Field Type Null Key Default Extra
vtiger_customview_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_cvadvfilter cvid int(19) NO PRI NULL  
vtiger_cvadvfilter columnindex int(11) NO PRI NULL  
vtiger_cvadvfilter columnname varchar(250) YES      
vtiger_cvadvfilter comparator varchar(10) YES      
vtiger_cvadvfilter value varchar(200) YES      
Table Field Type Null Key Default Extra
vtiger_cvcolumnlist cvid int(19) NO PRI NULL  
vtiger_cvcolumnlist columnindex int(11) NO PRI NULL  
vtiger_cvcolumnlist columnname varchar(250) YES      
Table Field Type Null Key Default Extra
vtiger_cvstdfilter cvid int(19) NO PRI NULL  
vtiger_cvstdfilter columnname varchar(250) YES      
vtiger_cvstdfilter stdfilter varchar(250) YES      
vtiger_cvstdfilter startdate date YES   NULL  
vtiger_cvstdfilter enddate date YES   NULL  
Table Field Type Null Key Default Extra
vtiger_datashare_grp2grp shareid int(19) NO PRI NULL  
vtiger_datashare_grp2grp share_groupid int(19) YES MUL NULL  
vtiger_datashare_grp2grp to_groupid int(19) YES MUL NULL  
vtiger_datashare_grp2grp permission int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_datashare_grp2role shareid int(19) NO PRI NULL  
vtiger_datashare_grp2role share_groupid int(19) YES MUL NULL  
vtiger_datashare_grp2role to_roleid varchar(255) YES MUL NULL  
vtiger_datashare_grp2role permission int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_datashare_grp2rs shareid int(19) NO PRI NULL  
vtiger_datashare_grp2rs share_groupid int(19) YES MUL NULL  
vtiger_datashare_grp2rs to_roleandsubid varchar(255) YES MUL NULL  
vtiger_datashare_grp2rs permission int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_datashare_module_rel shareid int(19) NO PRI NULL  
vtiger_datashare_module_rel tabid int(19) NO MUL NULL  
vtiger_datashare_module_rel relationtype varchar(200) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_datashare_relatedmodule_permission shareid int(19) NO PRI NULL  
vtiger_datashare_relatedmodule_permission datashare_relatedmodule_id int(19) NO PRI NULL  
vtiger_datashare_relatedmodule_permission permission int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_datashare_relatedmodules datashare_relatedmodule_id int(19) NO PRI NULL  
vtiger_datashare_relatedmodules tabid int(19) YES MUL NULL  
vtiger_datashare_relatedmodules relatedto_tabid int(19) YES MUL NULL  
Table Field Type Null Key Default Extra
vtiger_datashare_relatedmodules_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_datashare_role2group shareid int(19) NO PRI NULL  
vtiger_datashare_role2group share_roleid varchar(255) YES MUL NULL  
vtiger_datashare_role2group to_groupid int(19) YES MUL NULL  
vtiger_datashare_role2group permission int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_datashare_role2role shareid int(19) NO PRI NULL  
vtiger_datashare_role2role share_roleid varchar(255) YES MUL NULL  
vtiger_datashare_role2role to_roleid varchar(255) YES MUL NULL  
vtiger_datashare_role2role permission int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_datashare_role2rs shareid int(19) NO PRI NULL  
vtiger_datashare_role2rs share_roleid varchar(255) YES MUL NULL  
vtiger_datashare_role2rs to_roleandsubid varchar(255) YES MUL NULL  
vtiger_datashare_role2rs permission int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_datashare_rs2grp shareid int(19) NO PRI NULL  
vtiger_datashare_rs2grp share_roleandsubid varchar(255) YES MUL NULL  
vtiger_datashare_rs2grp to_groupid int(19) YES MUL NULL  
vtiger_datashare_rs2grp permission int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_datashare_rs2role shareid int(19) NO PRI NULL  
vtiger_datashare_rs2role share_roleandsubid varchar(255) YES MUL NULL  
vtiger_datashare_rs2role to_roleid varchar(255) YES MUL NULL  
vtiger_datashare_rs2role permission int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_datashare_rs2rs shareid int(19) NO PRI NULL  
vtiger_datashare_rs2rs share_roleandsubid varchar(255) YES MUL NULL  
vtiger_datashare_rs2rs to_roleandsubid varchar(255) YES MUL NULL  
vtiger_datashare_rs2rs permission int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_date_format date_formatid int(19) NO PRI NULL auto_increment
vtiger_date_format date_format varchar(200) NO   NULL  
vtiger_date_format sortorderid int(19) NO   0  
vtiger_date_format presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_date_format_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_dealintimation dealintimationid int(19) NO PRI 0  
vtiger_dealintimation dealname varchar(100) NO UNI NULL  
vtiger_dealintimation intimationamount int(19) NO   0  
vtiger_dealintimation dealprobability decimal(3,2) NO   0  
vtiger_dealintimation dealintimationactive int(1) YES   NULL  
vtiger_dealintimation fromname varchar(120) NO   NULL  
vtiger_dealintimation fromemailid varchar(100) NO   NULL  
vtiger_dealintimation notifyemails varchar(50) NO   NULL  
vtiger_dealintimation notifybccemails varchar(50) NO   NULL  
vtiger_dealintimation notifyccmails varchar(50) NO   NULL  
vtiger_dealintimation notifypotentialowner int(1) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_def_org_field tabid int(10) YES MUL NULL  
vtiger_def_org_field fieldid int(19) NO PRI NULL  
vtiger_def_org_field visible int(19) YES MUL NULL  
vtiger_def_org_field readonly int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_def_org_share ruleid int(11) NO PRI NULL auto_increment
vtiger_def_org_share tabid int(11) NO   NULL  
vtiger_def_org_share permission int(19) YES MUL NULL  
vtiger_def_org_share editstatus int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_def_org_share_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_defaultcv tabid int(19) NO PRI NULL  
vtiger_defaultcv defaultviewname varchar(50) NO   NULL  
vtiger_defaultcv query text YES   NULL  
Table Field Type Null Key Default Extra
vtiger_downloadpurpose downloadpurposeid int(19) NO PRI NULL auto_increment
vtiger_downloadpurpose purpose varchar(200) NO UNI NULL  
vtiger_downloadpurpose sortorderid int(19) NO   0  
vtiger_downloadpurpose presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_duration_minutes minutesid int(19) NO PRI NULL auto_increment
vtiger_duration_minutes duration_minutes varchar(200) NO   NULL  
vtiger_duration_minutes sortorderid int(19) NO   0  
vtiger_duration_minutes presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_duration_minutes_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_durationhrs hrsid int(19) NO PRI NULL auto_increment
vtiger_durationhrs hrs varchar(50) YES   NULL  
vtiger_durationhrs sortorderid int(19) NO   0  
vtiger_durationhrs presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_durationmins minsid int(19) NO PRI NULL auto_increment
vtiger_durationmins mins varchar(50) YES   NULL  
vtiger_durationmins sortorderid int(19) NO   0  
vtiger_durationmins presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_email_access crmid int(11) YES   NULL  
vtiger_email_access mailid int(11) YES   NULL  
vtiger_email_access accessdate date YES   NULL  
vtiger_email_access accesstime datetime YES   NULL  
Table Field Type Null Key Default Extra
vtiger_email_track crmid int(11) YES MUL NULL  
vtiger_email_track mailid int(11) YES   NULL  
vtiger_email_track access_count int(11) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_emaildetails emailid int(19) NO PRI NULL  
vtiger_emaildetails from_email varchar(50) NO      
vtiger_emaildetails to_email text YES   NULL  
vtiger_emaildetails cc_email text YES   NULL  
vtiger_emaildetails bcc_email text YES   NULL  
vtiger_emaildetails assigned_user_email varchar(50) NO      
vtiger_emaildetails idlists text YES   NULL  
vtiger_emaildetails email_flag varchar(50) NO      
Table Field Type Null Key Default Extra
vtiger_emailtemplates foldername varchar(100) YES MUL NULL  
vtiger_emailtemplates templatename varchar(100) YES   NULL  
vtiger_emailtemplates subject varchar(100) YES   NULL  
vtiger_emailtemplates description text YES   NULL  
vtiger_emailtemplates body text YES   NULL  
vtiger_emailtemplates deleted int(1) NO   0  
vtiger_emailtemplates templateid int(19) NO PRI NULL auto_increment
Table Field Type Null Key Default Extra
vtiger_emailtemplates_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_entityname tabid int(19) NO PRI 0  
vtiger_entityname modulename varchar(50) NO   NULL  
vtiger_entityname tablename varchar(100) NO   NULL  
vtiger_entityname fieldname varchar(150) NO   NULL  
vtiger_entityname entityidfield varchar(150) NO   NULL  
vtiger_entityname entityidcolumn varchar(150) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_evaluationstatus evalstatusid int(19) NO PRI NULL auto_increment
vtiger_evaluationstatus status varchar(200) NO UNI NULL  
vtiger_evaluationstatus sortorderid int(19) NO   0  
vtiger_evaluationstatus presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_eventhandler_module eventhandler_module_id int(11) NO PRI NULL auto_increment
vtiger_eventhandler_module module_name varchar(100) YES   NULL  
vtiger_eventhandler_module handler_class varchar(100) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_eventhandler_module_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_eventhandlers eventhandler_id int(11) NO PRI NULL auto_increment
vtiger_eventhandlers event_name varchar(100) NO PRI NULL  
vtiger_eventhandlers handler_path varchar(400) NO   NULL  
vtiger_eventhandlers handler_class varchar(100) NO PRI NULL  
vtiger_eventhandlers cond text YES   NULL  
vtiger_eventhandlers is_active int(1) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_eventhandlers_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_eventstatus eventstatusid int(19) NO PRI NULL auto_increment
vtiger_eventstatus eventstatus varchar(200) NO   NULL  
vtiger_eventstatus presence int(1) NO   1  
vtiger_eventstatus picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_eventstatus_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_expectedresponse expectedresponseid int(19) NO PRI NULL auto_increment
vtiger_expectedresponse expectedresponse varchar(200) NO UNI NULL  
vtiger_expectedresponse presence int(1) NO   1  
vtiger_expectedresponse picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_expectedresponse_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_faq id int(11) NO PRI NULL auto_increment
vtiger_faq faq_no varchar(100) NO   NULL  
vtiger_faq product_id varchar(100) YES   NULL  
vtiger_faq question text YES   NULL  
vtiger_faq answer text YES   NULL  
vtiger_faq category varchar(200) NO   NULL  
vtiger_faq status varchar(200) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_faqcategories faqcategories_id int(19) NO PRI NULL auto_increment
vtiger_faqcategories faqcategories varchar(200) YES   NULL  
vtiger_faqcategories presence int(1) NO   1  
vtiger_faqcategories picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_faqcategories_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_faqcomments commentid int(19) NO PRI NULL auto_increment
vtiger_faqcomments faqid int(19) YES MUL NULL  
vtiger_faqcomments comments text YES   NULL  
vtiger_faqcomments createdtime datetime NO   NULL  
Table Field Type Null Key Default Extra
vtiger_faqstatus faqstatus_id int(19) NO PRI NULL auto_increment
vtiger_faqstatus faqstatus varchar(200) YES   NULL  
vtiger_faqstatus presence int(1) NO   1  
vtiger_faqstatus picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_faqstatus_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_field tabid int(19) NO MUL NULL  
vtiger_field fieldid int(19) NO PRI NULL auto_increment
vtiger_field columnname varchar(30) NO   NULL  
vtiger_field tablename varchar(50) NO   NULL  
vtiger_field generatedtype int(19) NO   0  
vtiger_field uitype varchar(30) NO   NULL  
vtiger_field fieldname varchar(50) NO MUL NULL  
vtiger_field fieldlabel varchar(50) NO   NULL  
vtiger_field readonly int(1) NO   NULL  
vtiger_field presence int(19) NO   1  
vtiger_field selected int(1) NO   NULL  
vtiger_field maximumlength int(19) YES   NULL  
vtiger_field sequence int(19) YES   NULL  
vtiger_field block int(19) YES MUL NULL  
vtiger_field displaytype int(19) YES MUL NULL  
vtiger_field typeofdata varchar(100) YES   NULL  
vtiger_field quickcreate int(10) NO   1  
vtiger_field quickcreatesequence int(19) YES   NULL  
vtiger_field info_type varchar(20) YES   NULL  
vtiger_field masseditable int(10) NO   1  
vtiger_field helpinfo text YES   NULL  
Table Field Type Null Key Default Extra
vtiger_field_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_fieldformulas expressionid int(11) NO PRI 0  
vtiger_fieldformulas modulename varchar(100) YES   NULL  
vtiger_fieldformulas expression_engine text YES   NULL  
Table Field Type Null Key Default Extra
vtiger_fieldmodulerel fieldid int(11) NO   NULL  
vtiger_fieldmodulerel module varchar(100) NO   NULL  
vtiger_fieldmodulerel relmodule varchar(100) NO   NULL  
vtiger_fieldmodulerel status varchar(10) YES   NULL  
vtiger_fieldmodulerel sequence int(11) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_files id varchar(36) NO PRI NULL  
vtiger_files name varchar(36) YES   NULL  
vtiger_files content longblob YES   NULL  
vtiger_files deleted int(1) NO   0  
vtiger_files date_entered timestamp NO   CURRENT_TIMESTAMP  
vtiger_files assigned_user_id varchar(36) YES MUL NULL  
Table Field Type Null Key Default Extra
vtiger_freetagged_objects tag_id int(20) NO PRI 0  
vtiger_freetagged_objects tagger_id int(20) NO PRI 0  
vtiger_freetagged_objects object_id int(20) NO PRI 0  
vtiger_freetagged_objects tagged_on timestamp NO   CURRENT_TIMESTAMP  
vtiger_freetagged_objects module varchar(50) NO      
Table Field Type Null Key Default Extra
vtiger_freetags id int(19) NO PRI NULL  
vtiger_freetags tag varchar(50) NO      
vtiger_freetags raw_tag varchar(50) NO      
Table Field Type Null Key Default Extra
vtiger_freetags_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_glacct glacctid int(19) NO PRI NULL auto_increment
vtiger_glacct glacct varchar(200) NO UNI NULL  
vtiger_glacct presence int(1) NO   1  
vtiger_glacct picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_glacct_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_group2grouprel groupid int(19) NO PRI NULL  
vtiger_group2grouprel containsgroupid int(19) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_group2role groupid int(19) NO PRI NULL  
vtiger_group2role roleid varchar(255) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_group2rs groupid int(19) NO PRI NULL  
vtiger_group2rs roleandsubid varchar(255) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_groups groupid int(19) NO PRI NULL  
vtiger_groups groupname varchar(100) YES UNI NULL  
vtiger_groups description text YES   NULL  
Table Field Type Null Key Default Extra
vtiger_headers fileid int(3) NO PRI NULL auto_increment
vtiger_headers headernames varchar(30) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_home_layout userid int(19) NO PRI NULL  
vtiger_home_layout layout int(19) NO   4  
Table Field Type Null Key Default Extra
vtiger_homedashbd stuffid int(19) NO PRI 0  
vtiger_homedashbd dashbdname varchar(100) YES   NULL  
vtiger_homedashbd dashbdtype varchar(100) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_homedefault stuffid int(19) NO PRI 0  
vtiger_homedefault hometype varchar(30) NO   NULL  
vtiger_homedefault maxentries int(19) YES   NULL  
vtiger_homedefault setype varchar(30) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_homemodule stuffid int(19) NO PRI NULL  
vtiger_homemodule modulename varchar(100) YES   NULL  
vtiger_homemodule maxentries int(19) NO   NULL  
vtiger_homemodule customviewid int(19) NO   NULL  
vtiger_homemodule setype varchar(30) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_homemoduleflds stuffid int(19) YES MUL NULL  
vtiger_homemoduleflds fieldname varchar(100) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_homerss stuffid int(19) NO PRI 0  
vtiger_homerss url varchar(100) YES   NULL  
vtiger_homerss maxentries int(19) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_homestuff stuffid int(19) NO PRI 0  
vtiger_homestuff stuffsequence int(19) NO   0  
vtiger_homestuff stufftype varchar(100) YES   NULL  
vtiger_homestuff userid int(19) NO MUL NULL  
vtiger_homestuff visible int(10) NO   0  
vtiger_homestuff stufftitle varchar(100) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_homestuff_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_import_maps id int(19) NO PRI NULL auto_increment
vtiger_import_maps name varchar(36) NO   NULL  
vtiger_import_maps module varchar(36) NO   NULL  
vtiger_import_maps content longblob YES   NULL  
vtiger_import_maps has_header int(1) NO   1  
vtiger_import_maps deleted int(1) NO   0  
vtiger_import_maps date_entered timestamp NO   CURRENT_TIMESTAMP  
vtiger_import_maps date_modified timestamp NO   0000-00-00 00:00:00  
vtiger_import_maps assigned_user_id varchar(36) YES MUL NULL  
vtiger_import_maps is_published varchar(3) NO   no  
Table Field Type Null Key Default Extra
vtiger_industry industryid int(19) NO PRI NULL auto_increment
vtiger_industry industry varchar(200) NO UNI NULL  
vtiger_industry presence int(1) NO   1  
vtiger_industry picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_industry_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_inventory_tandc id int(19) NO PRI NULL  
vtiger_inventory_tandc type varchar(30) NO   NULL  
vtiger_inventory_tandc tandc text YES   NULL  
Table Field Type Null Key Default Extra
vtiger_inventory_tandc_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_inventorynotification notificationid int(19) NO PRI NULL auto_increment
vtiger_inventorynotification notificationname varchar(200) YES   NULL  
vtiger_inventorynotification notificationsubject varchar(200) YES   NULL  
vtiger_inventorynotification notificationbody text YES   NULL  
vtiger_inventorynotification label varchar(50) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_inventorynotification_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_inventoryproductrel id int(19) YES MUL NULL  
vtiger_inventoryproductrel productid int(19) YES MUL NULL  
vtiger_inventoryproductrel sequence_no int(4) YES   NULL  
vtiger_inventoryproductrel quantity decimal(25,3) YES   NULL  
vtiger_inventoryproductrel listprice decimal(25,3) YES   NULL  
vtiger_inventoryproductrel discount_percent decimal(7,3) YES   NULL  
vtiger_inventoryproductrel discount_amount decimal(7,3) YES   NULL  
vtiger_inventoryproductrel comment varchar(250) YES   NULL  
vtiger_inventoryproductrel description text YES   NULL  
vtiger_inventoryproductrel incrementondel int(11) NO   0  
vtiger_inventoryproductrel lineitem_id int(11) NO PRI NULL auto_increment
vtiger_inventoryproductrel tax1 decimal(7,3) YES   NULL  
vtiger_inventoryproductrel tax2 decimal(7,3) YES   NULL  
vtiger_inventoryproductrel tax3 decimal(7,3) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_inventoryshippingrel id int(19) YES MUL NULL  
vtiger_inventoryshippingrel shtax1 decimal(7,3) YES   NULL  
vtiger_inventoryshippingrel shtax2 decimal(7,3) YES   NULL  
vtiger_inventoryshippingrel shtax3 decimal(7,3) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_inventorysubproductrel id int(19) NO   NULL  
vtiger_inventorysubproductrel sequence_no int(10) NO   NULL  
vtiger_inventorysubproductrel productid int(19) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_inventorytaxinfo taxid int(3) NO PRI NULL  
vtiger_inventorytaxinfo taxname varchar(50) YES MUL NULL  
vtiger_inventorytaxinfo taxlabel varchar(50) YES   NULL  
vtiger_inventorytaxinfo percentage decimal(7,3) YES   NULL  
vtiger_inventorytaxinfo deleted int(1) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_inventorytaxinfo_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_invitees activityid int(19) NO PRI NULL  
vtiger_invitees inviteeid int(19) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_invoice invoiceid int(19) NO PRI 0  
vtiger_invoice subject varchar(100) YES   NULL  
vtiger_invoice salesorderid int(19) YES MUL NULL  
vtiger_invoice customerno varchar(100) YES   NULL  
vtiger_invoice contactid int(19) YES   NULL  
vtiger_invoice notes varchar(100) YES   NULL  
vtiger_invoice invoicedate date YES   NULL  
vtiger_invoice duedate date YES   NULL  
vtiger_invoice invoiceterms varchar(100) YES   NULL  
vtiger_invoice type varchar(100) YES   NULL  
vtiger_invoice adjustment decimal(25,3) YES   NULL  
vtiger_invoice salescommission decimal(25,3) YES   NULL  
vtiger_invoice exciseduty decimal(25,3) YES   NULL  
vtiger_invoice subtotal decimal(25,3) YES   NULL  
vtiger_invoice total decimal(25,3) YES   NULL  
vtiger_invoice taxtype varchar(25) YES   NULL  
vtiger_invoice discount_percent decimal(25,3) YES   NULL  
vtiger_invoice discount_amount decimal(25,3) YES   NULL  
vtiger_invoice s_h_amount decimal(25,3) YES   NULL  
vtiger_invoice shipping varchar(100) YES   NULL  
vtiger_invoice accountid int(19) YES   NULL  
vtiger_invoice terms_conditions text YES   NULL  
vtiger_invoice purchaseorder varchar(200) YES   NULL  
vtiger_invoice invoicestatus varchar(200) YES   NULL  
vtiger_invoice invoice_no varchar(100) YES   NULL  
vtiger_invoice currency_id int(19) NO   1  
vtiger_invoice conversion_rate decimal(10,3) NO   1  
Table Field Type Null Key Default Extra
vtiger_invoice_recurring_info salesorderid int(11) YES   NULL  
vtiger_invoice_recurring_info recurring_frequency varchar(200) YES   NULL  
vtiger_invoice_recurring_info start_period date YES   NULL  
vtiger_invoice_recurring_info end_period date YES   NULL  
vtiger_invoice_recurring_info last_recurring_date date YES   NULL  
vtiger_invoice_recurring_info payment_duration varchar(200) YES   NULL  
vtiger_invoice_recurring_info invoice_status varchar(200) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_invoicebillads invoicebilladdressid int(19) NO PRI 0  
vtiger_invoicebillads bill_city varchar(30) YES   NULL  
vtiger_invoicebillads bill_code varchar(30) YES   NULL  
vtiger_invoicebillads bill_country varchar(30) YES   NULL  
vtiger_invoicebillads bill_state varchar(30) YES   NULL  
vtiger_invoicebillads bill_street varchar(250) YES   NULL  
vtiger_invoicebillads bill_pobox varchar(30) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_invoicecf invoiceid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_invoiceshipads invoiceshipaddressid int(19) NO PRI 0  
vtiger_invoiceshipads ship_city varchar(30) YES   NULL  
vtiger_invoiceshipads ship_code varchar(30) YES   NULL  
vtiger_invoiceshipads ship_country varchar(30) YES   NULL  
vtiger_invoiceshipads ship_state varchar(30) YES   NULL  
vtiger_invoiceshipads ship_street varchar(250) YES   NULL  
vtiger_invoiceshipads ship_pobox varchar(30) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_invoicestatus inovicestatusid int(19) NO PRI NULL auto_increment
vtiger_invoicestatus invoicestatus varchar(200) NO UNI NULL  
vtiger_invoicestatus presence int(1) NO   1  
vtiger_invoicestatus picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_invoicestatus_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_invoicestatushistory historyid int(19) NO PRI NULL auto_increment
vtiger_invoicestatushistory invoiceid int(19) NO MUL NULL  
vtiger_invoicestatushistory accountname varchar(100) YES   NULL  
vtiger_invoicestatushistory total decimal(10,0) YES   NULL  
vtiger_invoicestatushistory invoicestatus varchar(200) YES   NULL  
vtiger_invoicestatushistory lastmodified datetime YES   NULL  
Table Field Type Null Key Default Extra
vtiger_language id int(11) NO PRI NULL auto_increment
vtiger_language name varchar(50) YES   NULL  
vtiger_language prefix varchar(10) YES   NULL  
vtiger_language label varchar(30) YES   NULL  
vtiger_language lastupdated datetime YES   NULL  
vtiger_language sequence int(11) YES   NULL  
vtiger_language isdefault int(1) YES   NULL  
vtiger_language active int(1) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_language_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_lar larid int(19) NO PRI 0  
vtiger_lar name varchar(50) NO UNI NULL  
vtiger_lar createdby int(19) NO MUL 0  
vtiger_lar createdon date NO   NULL  
Table Field Type Null Key Default Extra
vtiger_lead_view lead_viewid int(19) NO PRI NULL auto_increment
vtiger_lead_view lead_view varchar(200) NO   NULL  
vtiger_lead_view sortorderid int(19) NO   0  
vtiger_lead_view presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_lead_view_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_leadacctrel leadid int(19) NO PRI 0  
vtiger_leadacctrel accountid int(19) NO MUL 0  
Table Field Type Null Key Default Extra
vtiger_leadaddress leadaddressid int(19) NO PRI 0  
vtiger_leadaddress city varchar(30) YES   NULL  
vtiger_leadaddress code varchar(30) YES   NULL  
vtiger_leadaddress state varchar(30) YES   NULL  
vtiger_leadaddress pobox varchar(30) YES   NULL  
vtiger_leadaddress country varchar(30) YES   NULL  
vtiger_leadaddress phone varchar(50) YES   NULL  
vtiger_leadaddress mobile varchar(50) YES   NULL  
vtiger_leadaddress fax varchar(50) YES   NULL  
vtiger_leadaddress lane varchar(250) YES   NULL  
vtiger_leadaddress leadaddresstype varchar(30) YES   Billing  
Table Field Type Null Key Default Extra
vtiger_leadcontrel leadid int(19) NO PRI 0  
vtiger_leadcontrel contactid int(19) NO MUL 0  
Table Field Type Null Key Default Extra
vtiger_leaddetails leadid int(19) NO PRI NULL  
vtiger_leaddetails lead_no varchar(100) NO   NULL  
vtiger_leaddetails email varchar(100) YES   NULL  
vtiger_leaddetails interest varchar(50) YES   NULL  
vtiger_leaddetails firstname varchar(40) YES   NULL  
vtiger_leaddetails salutation varchar(200) YES   NULL  
vtiger_leaddetails lastname varchar(80) NO   NULL  
vtiger_leaddetails company varchar(100) NO   NULL  
vtiger_leaddetails annualrevenue int(19) YES   0  
vtiger_leaddetails industry varchar(200) YES   NULL  
vtiger_leaddetails campaign varchar(30) YES   NULL  
vtiger_leaddetails rating varchar(200) YES   NULL  
vtiger_leaddetails leadstatus varchar(50) YES   NULL  
vtiger_leaddetails leadsource varchar(200) YES   NULL  
vtiger_leaddetails converted int(1) YES MUL 0  
vtiger_leaddetails designation varchar(50) YES   SalesMan  
vtiger_leaddetails licencekeystatus varchar(50) YES   NULL  
vtiger_leaddetails space varchar(250) YES   NULL  
vtiger_leaddetails comments text YES   NULL  
vtiger_leaddetails priority varchar(50) YES   NULL  
vtiger_leaddetails demorequest varchar(50) YES   NULL  
vtiger_leaddetails partnercontact varchar(50) YES   NULL  
vtiger_leaddetails productversion varchar(20) YES   NULL  
vtiger_leaddetails product varchar(50) YES   NULL  
vtiger_leaddetails maildate date YES   NULL  
vtiger_leaddetails nextstepdate date YES   NULL  
vtiger_leaddetails fundingsituation varchar(50) YES   NULL  
vtiger_leaddetails purpose varchar(50) YES   NULL  
vtiger_leaddetails evaluationstatus varchar(50) YES   NULL  
vtiger_leaddetails transferdate date YES   NULL  
vtiger_leaddetails revenuetype varchar(50) YES   NULL  
vtiger_leaddetails noofemployees int(50) YES   NULL  
vtiger_leaddetails yahooid varchar(100) YES   NULL  
vtiger_leaddetails assignleadchk int(1) YES   0  
Table Field Type Null Key Default Extra
vtiger_leadpotrel leadid int(19) NO UNI 0  
vtiger_leadpotrel potentialid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_leadscf leadid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_leadsource leadsourceid int(19) NO PRI NULL auto_increment
vtiger_leadsource leadsource varchar(200) NO   NULL  
vtiger_leadsource presence int(1) NO   1  
vtiger_leadsource picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_leadsource_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_leadstage leadstageid int(19) NO PRI NULL auto_increment
vtiger_leadstage stage varchar(200) NO UNI NULL  
vtiger_leadstage sortorderid int(19) NO   0  
vtiger_leadstage presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_leadstatus leadstatusid int(19) NO PRI NULL auto_increment
vtiger_leadstatus leadstatus varchar(200) NO   NULL  
vtiger_leadstatus presence int(1) NO   1  
vtiger_leadstatus picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_leadstatus_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_leadsubdetails leadsubscriptionid int(19) NO PRI 0  
vtiger_leadsubdetails website varchar(255) YES   NULL  
vtiger_leadsubdetails callornot int(1) YES   0  
vtiger_leadsubdetails readornot int(1) YES   0  
vtiger_leadsubdetails empct int(10) YES   0  
Table Field Type Null Key Default Extra
vtiger_licencekeystatus licencekeystatusid int(19) NO PRI NULL auto_increment
vtiger_licencekeystatus licencekeystatus varchar(200) NO   NULL  
vtiger_licencekeystatus sortorderid int(19) NO   0  
vtiger_licencekeystatus presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_links linkid int(11) NO PRI NULL  
vtiger_links tabid int(11) YES MUL NULL  
vtiger_links linktype varchar(20) YES   NULL  
vtiger_links linklabel varchar(30) YES   NULL  
vtiger_links linkurl varchar(255) YES   NULL  
vtiger_links linkicon varchar(100) YES   NULL  
vtiger_links sequence int(11) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_links_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_loginhistory login_id int(11) NO PRI NULL auto_increment
vtiger_loginhistory user_name varchar(25) NO   NULL  
vtiger_loginhistory user_ip varchar(25) NO   NULL  
vtiger_loginhistory logout_time timestamp NO   CURRENT_TIMESTAMP  
vtiger_loginhistory login_time timestamp NO   0000-00-00 00:00:00  
vtiger_loginhistory status varchar(25) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_mail_accounts account_id int(11) NO PRI NULL  
vtiger_mail_accounts user_id int(11) NO   NULL  
vtiger_mail_accounts display_name varchar(50) YES   NULL  
vtiger_mail_accounts mail_id varchar(50) YES   NULL  
vtiger_mail_accounts account_name varchar(50) YES   NULL  
vtiger_mail_accounts mail_protocol varchar(20) YES   NULL  
vtiger_mail_accounts mail_username varchar(50) NO   NULL  
vtiger_mail_accounts mail_password varchar(250) NO   NULL  
vtiger_mail_accounts mail_servername varchar(50) YES   NULL  
vtiger_mail_accounts box_refresh int(10) YES   NULL  
vtiger_mail_accounts mails_per_page int(10) YES   NULL  
vtiger_mail_accounts ssltype varchar(50) YES   NULL  
vtiger_mail_accounts sslmeth varchar(50) YES   NULL  
vtiger_mail_accounts int_mailer int(1) YES   0  
vtiger_mail_accounts status varchar(10) YES   NULL  
vtiger_mail_accounts set_default int(2) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_mailscanner scannerid int(11) NO PRI NULL auto_increment
vtiger_mailscanner scannername varchar(30) YES   NULL  
vtiger_mailscanner server varchar(100) YES   NULL  
vtiger_mailscanner protocol varchar(10) YES   NULL  
vtiger_mailscanner username varchar(255) YES   NULL  
vtiger_mailscanner password varchar(255) YES   NULL  
vtiger_mailscanner ssltype varchar(10) YES   NULL  
vtiger_mailscanner sslmethod varchar(30) YES   NULL  
vtiger_mailscanner connecturl varchar(255) YES   NULL  
vtiger_mailscanner searchfor varchar(10) YES   NULL  
vtiger_mailscanner markas varchar(10) YES   NULL  
vtiger_mailscanner isvalid int(1) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_mailscanner_actions actionid int(11) NO PRI NULL auto_increment
vtiger_mailscanner_actions scannerid int(11) YES   NULL  
vtiger_mailscanner_actions actiontype varchar(10) YES   NULL  
vtiger_mailscanner_actions module varchar(30) YES   NULL  
vtiger_mailscanner_actions lookup varchar(30) YES   NULL  
vtiger_mailscanner_actions sequence int(11) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_mailscanner_folders folderid int(11) NO PRI NULL auto_increment
vtiger_mailscanner_folders scannerid int(11) YES   NULL  
vtiger_mailscanner_folders foldername varchar(255) YES   NULL  
vtiger_mailscanner_folders lastscan varchar(30) YES   NULL  
vtiger_mailscanner_folders rescan int(1) YES   NULL  
vtiger_mailscanner_folders enabled int(1) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_mailscanner_ids scannerid int(11) YES   NULL  
vtiger_mailscanner_ids messageid text YES   NULL  
vtiger_mailscanner_ids crmid int(11) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_mailscanner_ruleactions ruleid int(11) YES   NULL  
vtiger_mailscanner_ruleactions actionid int(11) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_mailscanner_rules ruleid int(11) NO PRI NULL auto_increment
vtiger_mailscanner_rules scannerid int(11) YES   NULL  
vtiger_mailscanner_rules fromaddress varchar(255) YES   NULL  
vtiger_mailscanner_rules toaddress varchar(255) YES   NULL  
vtiger_mailscanner_rules subjectop varchar(20) YES   NULL  
vtiger_mailscanner_rules subject varchar(255) YES   NULL  
vtiger_mailscanner_rules bodyop varchar(20) YES   NULL  
vtiger_mailscanner_rules body varchar(255) YES   NULL  
vtiger_mailscanner_rules matchusing varchar(5) YES   NULL  
vtiger_mailscanner_rules sequence int(11) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_manufacturer manufacturerid int(19) NO PRI NULL auto_increment
vtiger_manufacturer manufacturer varchar(200) NO UNI NULL  
vtiger_manufacturer presence int(1) NO   1  
vtiger_manufacturer picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_manufacturer_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_modentity_num num_id int(19) NO PRI NULL  
vtiger_modentity_num semodule varchar(50) NO MUL NULL  
vtiger_modentity_num prefix varchar(50) NO      
vtiger_modentity_num start_id varchar(50) NO   NULL  
vtiger_modentity_num cur_id varchar(50) NO   NULL  
vtiger_modentity_num active varchar(2) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_modentity_num_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_moduleowners tabid int(19) NO PRI 0  
vtiger_moduleowners user_id varchar(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_notebook_contents userid int(19) NO   NULL  
vtiger_notebook_contents notebookid int(19) NO   NULL  
vtiger_notebook_contents contents text YES   NULL  
Table Field Type Null Key Default Extra
vtiger_notes notesid int(19) NO PRI 0  
vtiger_notes note_no varchar(100) NO   NULL  
vtiger_notes title varchar(50) NO MUL NULL  
vtiger_notes filename varchar(200) YES   NULL  
vtiger_notes notecontent text YES   NULL  
vtiger_notes folderid int(19) NO   1  
vtiger_notes filetype varchar(50) YES   NULL  
vtiger_notes filelocationtype varchar(5) YES   NULL  
vtiger_notes filedownloadcount int(19) YES   NULL  
vtiger_notes filestatus int(19) YES   NULL  
vtiger_notes filesize int(19) NO   0  
vtiger_notes fileversion varchar(50) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_notescf notesid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_notificationscheduler schedulednotificationid int(19) NO PRI NULL auto_increment
vtiger_notificationscheduler schedulednotificationname varchar(200) YES UNI NULL  
vtiger_notificationscheduler active int(1) YES   NULL  
vtiger_notificationscheduler notificationsubject varchar(200) YES   NULL  
vtiger_notificationscheduler notificationbody text YES   NULL  
vtiger_notificationscheduler label varchar(50) YES   NULL  
vtiger_notificationscheduler type varchar(10) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_notificationscheduler_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_opportunity_type opptypeid int(19) NO PRI NULL auto_increment
vtiger_opportunity_type opportunity_type varchar(200) NO UNI NULL  
vtiger_opportunity_type presence int(1) NO   1  
vtiger_opportunity_type picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_opportunity_type_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_opportunitystage potstageid int(19) NO PRI NULL auto_increment
vtiger_opportunitystage stage varchar(200) NO UNI NULL  
vtiger_opportunitystage sortorderid int(19) NO   0  
vtiger_opportunitystage presence int(1) NO   1  
vtiger_opportunitystage probability decimal(3,2) YES   0  
Table Field Type Null Key Default Extra
vtiger_org_share_action2tab share_action_id int(19) NO PRI NULL  
vtiger_org_share_action2tab tabid int(19) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_org_share_action_mapping share_action_id int(19) NO PRI NULL  
vtiger_org_share_action_mapping share_action_name varchar(200) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_organizationdetails organizationname varchar(60) NO PRI NULL  
vtiger_organizationdetails address varchar(150) YES   NULL  
vtiger_organizationdetails city varchar(100) YES   NULL  
vtiger_organizationdetails state varchar(100) YES   NULL  
vtiger_organizationdetails country varchar(100) YES   NULL  
vtiger_organizationdetails code varchar(30) YES   NULL  
vtiger_organizationdetails phone varchar(30) YES   NULL  
vtiger_organizationdetails fax varchar(30) YES   NULL  
vtiger_organizationdetails website varchar(100) YES   NULL  
vtiger_organizationdetails logoname varchar(50) YES   NULL  
vtiger_organizationdetails logo text YES   NULL  
Table Field Type Null Key Default Extra
vtiger_ownernotify crmid int(19) YES MUL NULL  
vtiger_ownernotify smownerid int(19) YES   NULL  
vtiger_ownernotify flag int(3) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_parenttab parenttabid int(19) NO PRI NULL  
vtiger_parenttab parenttab_label varchar(100) NO   NULL  
vtiger_parenttab sequence int(10) NO   NULL  
vtiger_parenttab visible int(2) NO   0  
Table Field Type Null Key Default Extra
vtiger_parenttabrel parenttabid int(19) NO MUL NULL  
vtiger_parenttabrel tabid int(19) NO MUL NULL  
vtiger_parenttabrel sequence int(3) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_payment_duration payment_duration_id int(11) YES   NULL  
vtiger_payment_duration payment_duration varchar(200) YES   NULL  
vtiger_payment_duration sortorderid int(11) YES   NULL  
vtiger_payment_duration presence int(11) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_payment_duration_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_pbxmanager pbxmanagerid int(11) YES   NULL  
vtiger_pbxmanager callfrom varchar(255) YES   NULL  
vtiger_pbxmanager callto varchar(255) YES   NULL  
vtiger_pbxmanager timeofcall varchar(255) YES   NULL  
vtiger_pbxmanager status varchar(255) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_picklist picklistid int(11) NO PRI NULL auto_increment
vtiger_picklist name varchar(200) NO UNI NULL  
Table Field Type Null Key Default Extra
vtiger_picklist_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_picklistvalues_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_pobillads pobilladdressid int(19) NO PRI 0  
vtiger_pobillads bill_city varchar(30) YES   NULL  
vtiger_pobillads bill_code varchar(30) YES   NULL  
vtiger_pobillads bill_country varchar(30) YES   NULL  
vtiger_pobillads bill_state varchar(30) YES   NULL  
vtiger_pobillads bill_street varchar(250) YES   NULL  
vtiger_pobillads bill_pobox varchar(30) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_portal portalid int(19) NO PRI NULL  
vtiger_portal portalname varchar(200) NO MUL NULL  
vtiger_portal portalurl varchar(255) NO   NULL  
vtiger_portal sequence int(3) NO   NULL  
vtiger_portal setdefault int(3) NO   0  
Table Field Type Null Key Default Extra
vtiger_portal_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_portalinfo id int(11) NO PRI NULL  
vtiger_portalinfo user_name varchar(50) YES   NULL  
vtiger_portalinfo user_password varchar(30) YES   NULL  
vtiger_portalinfo type varchar(5) YES   NULL  
vtiger_portalinfo last_login_time datetime YES   NULL  
vtiger_portalinfo login_time datetime YES   NULL  
vtiger_portalinfo logout_time datetime YES   NULL  
vtiger_portalinfo isactive int(1) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_poshipads poshipaddressid int(19) NO PRI 0  
vtiger_poshipads ship_city varchar(30) YES   NULL  
vtiger_poshipads ship_code varchar(30) YES   NULL  
vtiger_poshipads ship_country varchar(30) YES   NULL  
vtiger_poshipads ship_state varchar(30) YES   NULL  
vtiger_poshipads ship_street varchar(250) YES   NULL  
vtiger_poshipads ship_pobox varchar(30) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_postatus postatusid int(19) NO PRI NULL auto_increment
vtiger_postatus postatus varchar(200) NO UNI NULL  
vtiger_postatus presence int(1) NO   1  
vtiger_postatus picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_postatus_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_postatushistory historyid int(19) NO PRI NULL auto_increment
vtiger_postatushistory purchaseorderid int(19) NO MUL NULL  
vtiger_postatushistory vendorname varchar(100) YES   NULL  
vtiger_postatushistory total decimal(10,0) YES   NULL  
vtiger_postatushistory postatus varchar(200) YES   NULL  
vtiger_postatushistory lastmodified datetime YES   NULL  
Table Field Type Null Key Default Extra
vtiger_potcompetitorrel potentialid int(19) NO PRI NULL  
vtiger_potcompetitorrel competitorid int(19) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_potential potentialid int(19) NO PRI 0  
vtiger_potential potential_no varchar(100) NO   NULL  
vtiger_potential related_to int(19) YES   NULL  
vtiger_potential potentialname varchar(120) NO   NULL  
vtiger_potential amount decimal(14,2) YES   0  
vtiger_potential currency varchar(20) YES   NULL  
vtiger_potential closingdate date YES   NULL  
vtiger_potential typeofrevenue varchar(50) YES   NULL  
vtiger_potential nextstep varchar(100) YES   NULL  
vtiger_potential private int(1) YES   0  
vtiger_potential probability decimal(7,3) YES   0  
vtiger_potential campaignid int(19) YES   NULL  
vtiger_potential sales_stage varchar(200) YES MUL NULL  
vtiger_potential potentialtype varchar(200) YES   NULL  
vtiger_potential leadsource varchar(200) YES   NULL  
vtiger_potential productid int(50) YES   NULL  
vtiger_potential productversion varchar(50) YES   NULL  
vtiger_potential quotationref varchar(50) YES   NULL  
vtiger_potential partnercontact varchar(50) YES   NULL  
vtiger_potential remarks varchar(50) YES   NULL  
vtiger_potential runtimefee int(19) YES   0  
vtiger_potential followupdate date YES   NULL  
vtiger_potential evaluationstatus varchar(50) YES   NULL  
vtiger_potential description text YES   NULL  
vtiger_potential forecastcategory int(19) YES   0  
vtiger_potential outcomeanalysis int(19) YES   0  
Table Field Type Null Key Default Extra
vtiger_potentialscf potentialid int(19) NO PRI 0  
vtiger_potentialscf cf_538 varchar(255) YES      
vtiger_potentialscf cf_539 varchar(40) YES      
vtiger_potentialscf cf_540 varchar(255) YES      
Table Field Type Null Key Default Extra
vtiger_potstagehistory historyid int(19) NO PRI NULL auto_increment
vtiger_potstagehistory potentialid int(19) NO MUL NULL  
vtiger_potstagehistory amount decimal(10,0) YES   NULL  
vtiger_potstagehistory stage varchar(100) YES   NULL  
vtiger_potstagehistory probability decimal(7,3) YES   NULL  
vtiger_potstagehistory expectedrevenue decimal(10,0) YES   NULL  
vtiger_potstagehistory closedate date YES   NULL  
vtiger_potstagehistory lastmodified datetime YES   NULL  
Table Field Type Null Key Default Extra
vtiger_pricebook pricebookid int(19) NO PRI 0  
vtiger_pricebook pricebook_no varchar(100) NO   NULL  
vtiger_pricebook bookname varchar(100) YES   NULL  
vtiger_pricebook active int(1) YES   NULL  
vtiger_pricebook currency_id int(19) NO   1  
Table Field Type Null Key Default Extra
vtiger_pricebookcf pricebookid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_pricebookproductrel pricebookid int(19) NO PRI NULL  
vtiger_pricebookproductrel productid int(19) NO PRI NULL  
vtiger_pricebookproductrel listprice decimal(25,2) YES   NULL  
vtiger_pricebookproductrel usedcurrency int(11) NO   1  
Table Field Type Null Key Default Extra
vtiger_priority priorityid int(19) NO PRI NULL auto_increment
vtiger_priority priority varchar(200) NO UNI NULL  
vtiger_priority sortorderid int(19) NO   0  
vtiger_priority presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_productcategory productcategoryid int(19) NO PRI NULL auto_increment
vtiger_productcategory productcategory varchar(200) NO UNI NULL  
vtiger_productcategory presence int(1) NO   1  
vtiger_productcategory picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_productcategory_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_productcf productid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_productcollaterals productid int(11) NO PRI NULL  
vtiger_productcollaterals date_entered timestamp NO   CURRENT_TIMESTAMP  
vtiger_productcollaterals data longblob YES   NULL  
vtiger_productcollaterals description text YES   NULL  
vtiger_productcollaterals filename varchar(50) YES   NULL  
vtiger_productcollaterals filesize varchar(50) NO   NULL  
vtiger_productcollaterals filetype varchar(20) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_productcurrencyrel productid int(11) NO   NULL  
vtiger_productcurrencyrel currencyid int(11) NO   NULL  
vtiger_productcurrencyrel converted_price decimal(25,2) YES   NULL  
vtiger_productcurrencyrel actual_price decimal(25,2) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_products productid int(11) NO PRI NULL  
vtiger_products product_no varchar(100) NO   NULL  
vtiger_products productname varchar(50) NO   NULL  
vtiger_products productcode varchar(40) YES   NULL  
vtiger_products productcategory varchar(200) YES   NULL  
vtiger_products manufacturer varchar(200) YES   NULL  
vtiger_products qty_per_unit decimal(11,2) YES   0  
vtiger_products unit_price decimal(25,2) YES   NULL  
vtiger_products weight decimal(11,3) YES   NULL  
vtiger_products pack_size int(11) YES   NULL  
vtiger_products sales_start_date date YES   NULL  
vtiger_products sales_end_date date YES   NULL  
vtiger_products start_date date YES   NULL  
vtiger_products expiry_date date YES   NULL  
vtiger_products cost_factor int(11) YES   NULL  
vtiger_products commissionrate decimal(7,3) YES   NULL  
vtiger_products commissionmethod varchar(50) YES   NULL  
vtiger_products discontinued int(1) NO   0  
vtiger_products usageunit varchar(200) YES   NULL  
vtiger_products handler int(11) YES   NULL  
vtiger_products reorderlevel int(11) YES   NULL  
vtiger_products website varchar(100) YES   NULL  
vtiger_products taxclass varchar(200) YES   NULL  
vtiger_products mfr_part_no varchar(200) YES   NULL  
vtiger_products vendor_part_no varchar(200) YES   NULL  
vtiger_products serialno varchar(200) YES   NULL  
vtiger_products qtyinstock decimal(25,3) YES   NULL  
vtiger_products productsheet varchar(200) YES   NULL  
vtiger_products qtyindemand int(11) YES   NULL  
vtiger_products glacct varchar(200) YES   NULL  
vtiger_products vendor_id int(11) YES   NULL  
vtiger_products imagename text YES   NULL  
vtiger_products currency_id int(19) NO   1  
Table Field Type Null Key Default Extra
vtiger_producttaxrel productid int(11) NO MUL NULL  
vtiger_producttaxrel taxid int(3) NO MUL NULL  
vtiger_producttaxrel taxpercentage decimal(7,3) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_profile profileid int(10) NO PRI NULL auto_increment
vtiger_profile profilename varchar(50) NO   NULL  
vtiger_profile description text YES   NULL  
Table Field Type Null Key Default Extra
vtiger_profile2field profileid int(11) NO PRI NULL  
vtiger_profile2field tabid int(10) YES MUL NULL  
vtiger_profile2field fieldid int(19) NO PRI NULL  
vtiger_profile2field visible int(19) YES MUL NULL  
vtiger_profile2field readonly int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_profile2globalpermissions profileid int(19) NO PRI NULL  
vtiger_profile2globalpermissions globalactionid int(19) NO PRI NULL  
vtiger_profile2globalpermissions globalactionpermission int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_profile2standardpermissions profileid int(11) NO PRI NULL  
vtiger_profile2standardpermissions tabid int(10) NO PRI NULL  
vtiger_profile2standardpermissions operation int(10) NO PRI NULL  
vtiger_profile2standardpermissions permissions int(1) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_profile2tab profileid int(11) YES MUL NULL  
vtiger_profile2tab tabid int(10) YES   NULL  
vtiger_profile2tab permissions int(10) NO   0  
Table Field Type Null Key Default Extra
vtiger_profile2utility profileid int(11) NO PRI NULL  
vtiger_profile2utility tabid int(11) NO PRI NULL  
vtiger_profile2utility activityid int(11) NO PRI NULL  
vtiger_profile2utility permission int(1) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_profile_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_purchaseorder purchaseorderid int(19) NO PRI 0  
vtiger_purchaseorder subject varchar(100) YES   NULL  
vtiger_purchaseorder quoteid int(19) YES MUL NULL  
vtiger_purchaseorder vendorid int(19) YES MUL NULL  
vtiger_purchaseorder requisition_no varchar(100) YES   NULL  
vtiger_purchaseorder purchaseorder_no varchar(100) YES   NULL  
vtiger_purchaseorder tracking_no varchar(100) YES   NULL  
vtiger_purchaseorder contactid int(19) YES MUL NULL  
vtiger_purchaseorder duedate date YES   NULL  
vtiger_purchaseorder carrier varchar(200) YES   NULL  
vtiger_purchaseorder type varchar(100) YES   NULL  
vtiger_purchaseorder adjustment decimal(25,3) YES   NULL  
vtiger_purchaseorder salescommission decimal(25,3) YES   NULL  
vtiger_purchaseorder exciseduty decimal(25,3) YES   NULL  
vtiger_purchaseorder total decimal(25,3) YES   NULL  
vtiger_purchaseorder subtotal decimal(25,3) YES   NULL  
vtiger_purchaseorder taxtype varchar(25) YES   NULL  
vtiger_purchaseorder discount_percent decimal(25,3) YES   NULL  
vtiger_purchaseorder discount_amount decimal(25,3) YES   NULL  
vtiger_purchaseorder s_h_amount decimal(25,3) YES   NULL  
vtiger_purchaseorder terms_conditions text YES   NULL  
vtiger_purchaseorder postatus varchar(200) YES   NULL  
vtiger_purchaseorder currency_id int(19) NO   1  
vtiger_purchaseorder conversion_rate decimal(10,3) NO   1  
Table Field Type Null Key Default Extra
vtiger_purchaseordercf purchaseorderid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_quickview fieldid int(19) NO MUL NULL  
vtiger_quickview related_fieldid int(19) NO   NULL  
vtiger_quickview sequence int(19) NO   NULL  
vtiger_quickview currentview int(19) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_quotes quoteid int(19) NO PRI 0  
vtiger_quotes subject varchar(100) YES   NULL  
vtiger_quotes potentialid int(19) YES MUL NULL  
vtiger_quotes quotestage varchar(200) YES MUL NULL  
vtiger_quotes validtill date YES   NULL  
vtiger_quotes contactid int(19) YES MUL NULL  
vtiger_quotes quote_no varchar(100) YES   NULL  
vtiger_quotes subtotal decimal(25,3) YES   NULL  
vtiger_quotes carrier varchar(200) YES   NULL  
vtiger_quotes shipping varchar(100) YES   NULL  
vtiger_quotes inventorymanager int(19) YES   NULL  
vtiger_quotes type varchar(100) YES   NULL  
vtiger_quotes adjustment decimal(25,3) YES   NULL  
vtiger_quotes total decimal(25,3) YES   NULL  
vtiger_quotes taxtype varchar(25) YES   NULL  
vtiger_quotes discount_percent decimal(25,3) YES   NULL  
vtiger_quotes discount_amount decimal(25,3) YES   NULL  
vtiger_quotes s_h_amount decimal(25,3) YES   NULL  
vtiger_quotes accountid int(19) YES   NULL  
vtiger_quotes terms_conditions text YES   NULL  
vtiger_quotes currency_id int(19) NO   1  
vtiger_quotes conversion_rate decimal(10,3) NO   1  
Table Field Type Null Key Default Extra
vtiger_quotesbillads quotebilladdressid int(19) NO PRI 0  
vtiger_quotesbillads bill_city varchar(30) YES   NULL  
vtiger_quotesbillads bill_code varchar(30) YES   NULL  
vtiger_quotesbillads bill_country varchar(30) YES   NULL  
vtiger_quotesbillads bill_state varchar(30) YES   NULL  
vtiger_quotesbillads bill_street varchar(250) YES   NULL  
vtiger_quotesbillads bill_pobox varchar(30) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_quotescf quoteid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_quotesshipads quoteshipaddressid int(19) NO PRI 0  
vtiger_quotesshipads ship_city varchar(30) YES   NULL  
vtiger_quotesshipads ship_code varchar(30) YES   NULL  
vtiger_quotesshipads ship_country varchar(30) YES   NULL  
vtiger_quotesshipads ship_state varchar(30) YES   NULL  
vtiger_quotesshipads ship_street varchar(250) YES   NULL  
vtiger_quotesshipads ship_pobox varchar(30) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_quotestage quotestageid int(19) NO PRI NULL auto_increment
vtiger_quotestage quotestage varchar(200) NO UNI NULL  
vtiger_quotestage presence int(1) NO   1  
vtiger_quotestage picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_quotestage_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_quotestagehistory historyid int(19) NO PRI NULL auto_increment
vtiger_quotestagehistory quoteid int(19) NO MUL NULL  
vtiger_quotestagehistory accountname varchar(100) YES   NULL  
vtiger_quotestagehistory total decimal(10,0) YES   NULL  
vtiger_quotestagehistory quotestage varchar(200) YES   NULL  
vtiger_quotestagehistory lastmodified datetime YES   NULL  
Table Field Type Null Key Default Extra
vtiger_rating rating_id int(19) NO PRI NULL auto_increment
vtiger_rating rating varchar(200) YES   NULL  
vtiger_rating presence int(1) NO   1  
vtiger_rating picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_rating_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_recurring_frequency recurring_frequency_id int(11) YES   NULL  
vtiger_recurring_frequency recurring_frequency varchar(200) YES   NULL  
vtiger_recurring_frequency sortorderid int(11) YES   NULL  
vtiger_recurring_frequency presence int(11) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_recurring_frequency_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_recurringevents recurringid int(19) NO PRI NULL auto_increment
vtiger_recurringevents activityid int(19) NO MUL NULL  
vtiger_recurringevents recurringdate date YES   NULL  
vtiger_recurringevents recurringtype varchar(30) YES   NULL  
vtiger_recurringevents recurringfreq int(19) YES   NULL  
vtiger_recurringevents recurringinfo varchar(50) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_recurringtype recurringeventid int(19) NO PRI NULL auto_increment
vtiger_recurringtype recurringtype varchar(200) NO UNI NULL  
vtiger_recurringtype sortorderid int(19) NO   0  
vtiger_recurringtype presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_recurringtype_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_relatedlists relation_id int(19) NO PRI NULL  
vtiger_relatedlists tabid int(10) YES   NULL  
vtiger_relatedlists related_tabid int(10) YES   NULL  
vtiger_relatedlists name varchar(100) YES   NULL  
vtiger_relatedlists sequence int(10) YES   NULL  
vtiger_relatedlists label varchar(100) YES   NULL  
vtiger_relatedlists presence int(10) NO   0  
vtiger_relatedlists actions varchar(50) NO      
Table Field Type Null Key Default Extra
vtiger_relatedlists_rb entityid int(19) YES   NULL  
vtiger_relatedlists_rb action varchar(50) YES   NULL  
vtiger_relatedlists_rb rel_table varchar(200) YES   NULL  
vtiger_relatedlists_rb rel_column varchar(200) YES   NULL  
vtiger_relatedlists_rb ref_column varchar(200) YES   NULL  
vtiger_relatedlists_rb related_crm_ids text YES   NULL  
Table Field Type Null Key Default Extra
vtiger_relatedlists_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_relcriteria queryid int(19) NO PRI NULL  
vtiger_relcriteria columnindex int(11) NO PRI NULL  
vtiger_relcriteria columnname varchar(250) YES      
vtiger_relcriteria comparator varchar(10) YES      
vtiger_relcriteria value varchar(200) YES      
Table Field Type Null Key Default Extra
vtiger_reminder_interval reminder_intervalid int(19) NO PRI NULL auto_increment
vtiger_reminder_interval reminder_interval varchar(200) NO   NULL  
vtiger_reminder_interval sortorderid int(19) NO   NULL  
vtiger_reminder_interval presence int(1) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_reminder_interval_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_report reportid int(19) NO PRI NULL  
vtiger_report folderid int(19) NO MUL NULL  
vtiger_report reportname varchar(100) YES      
vtiger_report description varchar(250) YES      
vtiger_report reporttype varchar(50) YES      
vtiger_report queryid int(19) NO MUL 0  
vtiger_report state varchar(50) YES   SAVED  
vtiger_report customizable int(1) YES   1  
vtiger_report category int(11) YES   1  
vtiger_report owner int(11) YES   1  
vtiger_report sharingtype varchar(200) YES   Private  
Table Field Type Null Key Default Extra
vtiger_reportdatefilter datefilterid int(19) NO PRI NULL  
vtiger_reportdatefilter datecolumnname varchar(250) YES      
vtiger_reportdatefilter datefilter varchar(250) YES      
vtiger_reportdatefilter startdate date YES   NULL  
vtiger_reportdatefilter enddate date YES   NULL  
Table Field Type Null Key Default Extra
vtiger_reportfilters filterid int(19) NO   NULL  
vtiger_reportfilters name varchar(200) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_reportfolder folderid int(19) NO PRI NULL auto_increment
vtiger_reportfolder foldername varchar(100) NO      
vtiger_reportfolder description varchar(250) YES      
vtiger_reportfolder state varchar(50) YES   SAVED  
Table Field Type Null Key Default Extra
vtiger_reportmodules reportmodulesid int(19) NO PRI NULL  
vtiger_reportmodules primarymodule varchar(50) NO      
vtiger_reportmodules secondarymodules varchar(250) YES      
Table Field Type Null Key Default Extra
vtiger_reportsharing reportid int(19) NO   NULL  
vtiger_reportsharing shareid int(19) NO   NULL  
vtiger_reportsharing setype varchar(200) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_reportsortcol sortcolid int(19) NO PRI NULL  
vtiger_reportsortcol reportid int(19) NO PRI NULL  
vtiger_reportsortcol columnname varchar(250) YES      
vtiger_reportsortcol sortorder varchar(250) YES   Asc  
Table Field Type Null Key Default Extra
vtiger_reportsummary reportsummaryid int(19) NO PRI NULL  
vtiger_reportsummary summarytype int(19) NO PRI NULL  
vtiger_reportsummary columnname varchar(250) NO PRI    
Table Field Type Null Key Default Extra
vtiger_revenuetype revenuetypeid int(19) NO PRI NULL auto_increment
vtiger_revenuetype revenuetype varchar(200) NO UNI NULL  
vtiger_revenuetype sortorderid int(19) NO   0  
vtiger_revenuetype presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_role roleid varchar(255) NO PRI NULL  
vtiger_role rolename varchar(200) YES   NULL  
vtiger_role parentrole varchar(255) YES   NULL  
vtiger_role depth int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_role2picklist roleid varchar(255) NO PRI NULL  
vtiger_role2picklist picklistvalueid int(11) NO PRI NULL  
vtiger_role2picklist picklistid int(11) NO PRI NULL  
vtiger_role2picklist sortid int(11) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_role2profile roleid varchar(255) NO PRI NULL  
vtiger_role2profile profileid int(11) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_role_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_rss rssid int(19) NO PRI NULL  
vtiger_rss rssurl varchar(200) NO      
vtiger_rss rsstitle varchar(200) YES   NULL  
vtiger_rss rsstype int(10) YES   0  
vtiger_rss starred int(1) YES   0  
Table Field Type Null Key Default Extra
vtiger_rss_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_sales_stage sales_stage_id int(19) NO PRI NULL auto_increment
vtiger_sales_stage sales_stage varchar(200) YES   NULL  
vtiger_sales_stage presence int(1) NO   1  
vtiger_sales_stage picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_sales_stage_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_salesmanactivityrel smid int(19) NO PRI 0  
vtiger_salesmanactivityrel activityid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_salesmanattachmentsrel smid int(19) NO PRI 0  
vtiger_salesmanattachmentsrel attachmentsid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_salesmanticketrel smid int(19) NO PRI 0  
vtiger_salesmanticketrel id int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_salesorder salesorderid int(19) NO PRI 0  
vtiger_salesorder subject varchar(100) YES   NULL  
vtiger_salesorder potentialid int(19) YES   NULL  
vtiger_salesorder customerno varchar(100) YES   NULL  
vtiger_salesorder salesorder_no varchar(100) YES   NULL  
vtiger_salesorder quoteid int(19) YES   NULL  
vtiger_salesorder vendorterms varchar(100) YES   NULL  
vtiger_salesorder contactid int(19) YES MUL NULL  
vtiger_salesorder vendorid int(19) YES MUL NULL  
vtiger_salesorder duedate date YES   NULL  
vtiger_salesorder carrier varchar(200) YES   NULL  
vtiger_salesorder pending varchar(200) YES   NULL  
vtiger_salesorder type varchar(100) YES   NULL  
vtiger_salesorder adjustment decimal(25,3) YES   NULL  
vtiger_salesorder salescommission decimal(25,3) YES   NULL  
vtiger_salesorder exciseduty decimal(25,3) YES   NULL  
vtiger_salesorder total decimal(25,3) YES   NULL  
vtiger_salesorder subtotal decimal(25,3) YES   NULL  
vtiger_salesorder taxtype varchar(25) YES   NULL  
vtiger_salesorder discount_percent decimal(25,3) YES   NULL  
vtiger_salesorder discount_amount decimal(25,3) YES   NULL  
vtiger_salesorder s_h_amount decimal(25,3) YES   NULL  
vtiger_salesorder accountid int(19) YES   NULL  
vtiger_salesorder terms_conditions text YES   NULL  
vtiger_salesorder purchaseorder varchar(200) YES   NULL  
vtiger_salesorder sostatus varchar(200) YES   NULL  
vtiger_salesorder currency_id int(19) NO   1  
vtiger_salesorder conversion_rate decimal(10,3) NO   1  
vtiger_salesorder enable_recurring int(11) YES   0  
Table Field Type Null Key Default Extra
vtiger_salesordercf salesorderid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_salutationtype salutationid int(19) NO PRI NULL auto_increment
vtiger_salutationtype salutationtype varchar(200) NO   NULL  
vtiger_salutationtype presence int(1) NO   1  
vtiger_salutationtype picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_salutationtype_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_seactivityrel crmid int(19) NO PRI NULL  
vtiger_seactivityrel activityid int(19) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_seactivityrel_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_seattachmentsrel crmid int(19) NO PRI 0  
vtiger_seattachmentsrel attachmentsid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_selectcolumn queryid int(19) NO PRI NULL  
vtiger_selectcolumn columnindex int(11) NO PRI 0  
vtiger_selectcolumn columnname varchar(250) YES      
Table Field Type Null Key Default Extra
vtiger_selectquery queryid int(19) NO PRI NULL  
vtiger_selectquery startindex int(19) YES   0  
vtiger_selectquery numofobjects int(19) YES   0  
Table Field Type Null Key Default Extra
vtiger_selectquery_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_senotesrel crmid int(19) NO PRI 0  
vtiger_senotesrel notesid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_seproductsrel crmid int(19) NO PRI 0  
vtiger_seproductsrel productid int(19) NO PRI 0  
vtiger_seproductsrel setype varchar(30) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_service serviceid int(11) NO PRI NULL  
vtiger_service service_no varchar(100) NO   NULL  
vtiger_service servicename varchar(50) NO   NULL  
vtiger_service servicecategory varchar(200) YES   NULL  
vtiger_service qty_per_unit decimal(11,2) YES   0  
vtiger_service unit_price decimal(25,2) YES   NULL  
vtiger_service sales_start_date date YES   NULL  
vtiger_service sales_end_date date YES   NULL  
vtiger_service start_date date YES   NULL  
vtiger_service expiry_date date YES   NULL  
vtiger_service discontinued int(1) NO   0  
vtiger_service service_usageunit varchar(200) YES   NULL  
vtiger_service handler int(11) YES   NULL  
vtiger_service website varchar(100) YES   NULL  
vtiger_service taxclass varchar(200) YES   NULL  
vtiger_service currency_id int(19) NO   1  
vtiger_service commissionrate decimal(7,3) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_service_usageunit service_usageunitid int(11) NO PRI NULL auto_increment
vtiger_service_usageunit service_usageunit varchar(200) NO   NULL  
vtiger_service_usageunit presence int(1) NO   1  
vtiger_service_usageunit picklist_valueid int(11) NO   0  
Table Field Type Null Key Default Extra
vtiger_service_usageunit_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_servicecategory servicecategoryid int(11) NO PRI NULL auto_increment
vtiger_servicecategory servicecategory varchar(200) NO   NULL  
vtiger_servicecategory presence int(1) NO   1  
vtiger_servicecategory picklist_valueid int(11) NO   0  
Table Field Type Null Key Default Extra
vtiger_servicecategory_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_servicecf serviceid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_servicecontracts servicecontractsid int(11) YES   NULL  
vtiger_servicecontracts start_date varchar(100) YES   NULL  
vtiger_servicecontracts end_date varchar(100) YES   NULL  
vtiger_servicecontracts sc_related_to int(11) YES   NULL  
vtiger_servicecontracts tracking_unit varchar(100) YES   NULL  
vtiger_servicecontracts total_units varchar(100) YES   NULL  
vtiger_servicecontracts used_units varchar(100) YES   NULL  
vtiger_servicecontracts subject varchar(100) YES   NULL  
vtiger_servicecontracts due_date date YES   NULL  
vtiger_servicecontracts planned_duration varchar(256) YES   NULL  
vtiger_servicecontracts actual_duration varchar(256) YES   NULL  
vtiger_servicecontracts contract_status varchar(200) YES   NULL  
vtiger_servicecontracts priority varchar(200) YES   NULL  
vtiger_servicecontracts contract_type varchar(200) YES   NULL  
vtiger_servicecontracts progress decimal(5,2) YES   NULL  
vtiger_servicecontracts contract_no varchar(100) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_servicecontractscf servicecontractsid int(11) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_seticketsrel crmid int(19) NO PRI 0  
vtiger_seticketsrel ticketid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_settings_blocks blockid int(19) NO PRI NULL  
vtiger_settings_blocks label varchar(250) YES   NULL  
vtiger_settings_blocks sequence int(19) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_settings_blocks_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_settings_field fieldid int(19) NO PRI NULL  
vtiger_settings_field blockid int(19) YES MUL NULL  
vtiger_settings_field name varchar(250) YES   NULL  
vtiger_settings_field iconpath varchar(300) YES   NULL  
vtiger_settings_field description text YES   NULL  
vtiger_settings_field linkto text YES   NULL  
vtiger_settings_field sequence int(19) YES   NULL  
vtiger_settings_field active int(19) YES   0  
Table Field Type Null Key Default Extra
vtiger_settings_field_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_sharedcalendar userid int(19) NO PRI NULL  
vtiger_sharedcalendar sharedid int(19) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_shippingtaxinfo taxid int(3) NO PRI NULL  
vtiger_shippingtaxinfo taxname varchar(50) YES MUL NULL  
vtiger_shippingtaxinfo taxlabel varchar(50) YES   NULL  
vtiger_shippingtaxinfo percentage decimal(7,3) YES   NULL  
vtiger_shippingtaxinfo deleted int(1) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_shippingtaxinfo_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_soapservice id int(19) YES   NULL  
vtiger_soapservice type varchar(25) YES   NULL  
vtiger_soapservice sessionid varchar(100) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_sobillads sobilladdressid int(19) NO PRI 0  
vtiger_sobillads bill_city varchar(30) YES   NULL  
vtiger_sobillads bill_code varchar(30) YES   NULL  
vtiger_sobillads bill_country varchar(30) YES   NULL  
vtiger_sobillads bill_state varchar(30) YES   NULL  
vtiger_sobillads bill_street varchar(250) YES   NULL  
vtiger_sobillads bill_pobox varchar(30) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_soshipads soshipaddressid int(19) NO PRI 0  
vtiger_soshipads ship_city varchar(30) YES   NULL  
vtiger_soshipads ship_code varchar(30) YES   NULL  
vtiger_soshipads ship_country varchar(30) YES   NULL  
vtiger_soshipads ship_state varchar(30) YES   NULL  
vtiger_soshipads ship_street varchar(250) YES   NULL  
vtiger_soshipads ship_pobox varchar(30) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_sostatus sostatusid int(19) NO PRI NULL auto_increment
vtiger_sostatus sostatus varchar(200) NO UNI NULL  
vtiger_sostatus presence int(1) NO   1  
vtiger_sostatus picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_sostatus_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_sostatushistory historyid int(19) NO PRI NULL auto_increment
vtiger_sostatushistory salesorderid int(19) NO MUL NULL  
vtiger_sostatushistory accountname varchar(100) YES   NULL  
vtiger_sostatushistory total decimal(10,0) YES   NULL  
vtiger_sostatushistory sostatus varchar(200) YES   NULL  
vtiger_sostatushistory lastmodified datetime YES   NULL  
Table Field Type Null Key Default Extra
vtiger_status statusid int(19) NO PRI NULL auto_increment
vtiger_status status varchar(200) NO   NULL  
vtiger_status presence int(1) NO   1  
vtiger_status picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_status_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_systems id int(19) NO PRI NULL  
vtiger_systems server varchar(100) YES   NULL  
vtiger_systems server_port int(19) YES   NULL  
vtiger_systems server_username varchar(100) YES   NULL  
vtiger_systems server_password varchar(100) YES   NULL  
vtiger_systems server_type varchar(20) YES   NULL  
vtiger_systems smtp_auth varchar(5) YES   NULL  
vtiger_systems server_path varchar(256) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_systems_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_tab tabid int(19) NO PRI 0  
vtiger_tab name varchar(25) NO UNI NULL  
vtiger_tab presence int(19) NO   1  
vtiger_tab tabsequence int(10) YES   NULL  
vtiger_tab tablabel varchar(25) NO   NULL  
vtiger_tab modifiedby int(19) YES MUL NULL  
vtiger_tab modifiedtime int(19) YES   NULL  
vtiger_tab customized int(19) YES   NULL  
vtiger_tab ownedby int(19) YES   NULL  
vtiger_tab isentitytype int(11) NO   1  
vtiger_tab version varchar(10) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_taskpriority taskpriorityid int(19) NO PRI NULL auto_increment
vtiger_taskpriority taskpriority varchar(200) YES   NULL  
vtiger_taskpriority presence int(1) NO   1  
vtiger_taskpriority picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_taskpriority_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_taskstatus taskstatusid int(19) NO PRI NULL auto_increment
vtiger_taskstatus taskstatus varchar(200) YES   NULL  
vtiger_taskstatus presence int(1) NO   1  
vtiger_taskstatus picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_taskstatus_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_taxclass taxclassid int(19) NO PRI NULL auto_increment
vtiger_taxclass taxclass varchar(200) NO UNI NULL  
vtiger_taxclass sortorderid int(19) NO   0  
vtiger_taxclass presence int(1) NO   1  
Table Field Type Null Key Default Extra
vtiger_taxclass_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_ticketcategories ticketcategories_id int(19) NO PRI NULL auto_increment
vtiger_ticketcategories ticketcategories varchar(200) YES   NULL  
vtiger_ticketcategories presence int(1) NO   0  
vtiger_ticketcategories picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_ticketcategories_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_ticketcf ticketid int(19) NO PRI 0  
Table Field Type Null Key Default Extra
vtiger_ticketcomments commentid int(19) NO PRI NULL auto_increment
vtiger_ticketcomments ticketid int(19) YES MUL NULL  
vtiger_ticketcomments comments text YES   NULL  
vtiger_ticketcomments ownerid int(19) NO   0  
vtiger_ticketcomments ownertype varchar(10) YES   NULL  
vtiger_ticketcomments createdtime datetime NO   NULL  
Table Field Type Null Key Default Extra
vtiger_ticketpriorities ticketpriorities_id int(19) NO PRI NULL auto_increment
vtiger_ticketpriorities ticketpriorities varchar(200) YES   NULL  
vtiger_ticketpriorities presence int(1) NO   0  
vtiger_ticketpriorities picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_ticketpriorities_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_ticketseverities ticketseverities_id int(19) NO PRI NULL auto_increment
vtiger_ticketseverities ticketseverities varchar(200) YES   NULL  
vtiger_ticketseverities presence int(1) NO   0  
vtiger_ticketseverities picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_ticketseverities_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_ticketstatus ticketstatus_id int(19) NO PRI NULL auto_increment
vtiger_ticketstatus ticketstatus varchar(200) YES   NULL  
vtiger_ticketstatus presence int(1) NO   0  
vtiger_ticketstatus picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_ticketstatus_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_ticketstracktime ticket_id int(11) NO PRI 0  
vtiger_ticketstracktime supporter_id int(11) NO   0  
vtiger_ticketstracktime minutes int(11) YES   0  
vtiger_ticketstracktime date_logged int(11) NO   0  
Table Field Type Null Key Default Extra
vtiger_tmp_read_group_rel_sharing_per userid int(11) NO PRI NULL  
vtiger_tmp_read_group_rel_sharing_per tabid int(11) NO PRI NULL  
vtiger_tmp_read_group_rel_sharing_per relatedtabid int(11) NO PRI NULL  
vtiger_tmp_read_group_rel_sharing_per sharedgroupid int(11) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_tmp_read_group_sharing_per userid int(11) NO PRI NULL  
vtiger_tmp_read_group_sharing_per tabid int(11) NO PRI NULL  
vtiger_tmp_read_group_sharing_per sharedgroupid int(11) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_tmp_read_user_rel_sharing_per userid int(11) NO PRI NULL  
vtiger_tmp_read_user_rel_sharing_per tabid int(11) NO PRI NULL  
vtiger_tmp_read_user_rel_sharing_per relatedtabid int(11) NO PRI NULL  
vtiger_tmp_read_user_rel_sharing_per shareduserid int(11) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_tmp_read_user_sharing_per userid int(11) NO PRI NULL  
vtiger_tmp_read_user_sharing_per tabid int(11) NO PRI NULL  
vtiger_tmp_read_user_sharing_per shareduserid int(11) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_tmp_write_group_rel_sharing_per userid int(11) NO PRI NULL  
vtiger_tmp_write_group_rel_sharing_per tabid int(11) NO PRI NULL  
vtiger_tmp_write_group_rel_sharing_per relatedtabid int(11) NO PRI NULL  
vtiger_tmp_write_group_rel_sharing_per sharedgroupid int(11) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_tmp_write_group_sharing_per userid int(11) NO PRI NULL  
vtiger_tmp_write_group_sharing_per tabid int(11) NO PRI NULL  
vtiger_tmp_write_group_sharing_per sharedgroupid int(11) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_tmp_write_user_rel_sharing_per userid int(11) NO PRI NULL  
vtiger_tmp_write_user_rel_sharing_per tabid int(11) NO PRI NULL  
vtiger_tmp_write_user_rel_sharing_per relatedtabid int(11) NO PRI NULL  
vtiger_tmp_write_user_rel_sharing_per shareduserid int(11) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_tmp_write_user_sharing_per userid int(11) NO PRI NULL  
vtiger_tmp_write_user_sharing_per tabid int(11) NO PRI NULL  
vtiger_tmp_write_user_sharing_per shareduserid int(11) NO PRI NULL  
Table Field Type Null Key Default Extra
vtiger_tracker id int(11) NO PRI NULL auto_increment
vtiger_tracker user_id varchar(36) YES   NULL  
vtiger_tracker module_name varchar(25) YES   NULL  
vtiger_tracker item_id varchar(36) YES   NULL  
vtiger_tracker item_summary varchar(255) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_tracking_unit tracking_unitid int(11) NO PRI NULL auto_increment
vtiger_tracking_unit tracking_unit varchar(200) NO   NULL  
vtiger_tracking_unit presence int(1) NO   1  
vtiger_tracking_unit picklist_valueid int(11) NO   0  
Table Field Type Null Key Default Extra
vtiger_tracking_unit_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_troubletickets ticketid int(19) NO PRI NULL  
vtiger_troubletickets ticket_no varchar(100) NO   NULL  
vtiger_troubletickets groupname varchar(100) YES   NULL  
vtiger_troubletickets parent_id varchar(100) YES   NULL  
vtiger_troubletickets product_id varchar(100) YES   NULL  
vtiger_troubletickets priority varchar(200) YES   NULL  
vtiger_troubletickets severity varchar(200) YES   NULL  
vtiger_troubletickets status varchar(200) YES MUL NULL  
vtiger_troubletickets category varchar(200) YES   NULL  
vtiger_troubletickets title varchar(255) NO   NULL  
vtiger_troubletickets solution text YES   NULL  
vtiger_troubletickets update_log text YES   NULL  
vtiger_troubletickets version_id int(11) YES   NULL  
vtiger_troubletickets hours varchar(200) YES   NULL  
vtiger_troubletickets days varchar(200) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_usageunit usageunitid int(19) NO PRI NULL auto_increment
vtiger_usageunit usageunit varchar(200) NO UNI NULL  
vtiger_usageunit presence int(1) NO   1  
vtiger_usageunit picklist_valueid int(19) NO   0  
Table Field Type Null Key Default Extra
vtiger_usageunit_seq id int(11) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_user2mergefields userid int(11) YES MUL NULL  
vtiger_user2mergefields tabid int(19) YES   NULL  
vtiger_user2mergefields fieldid int(19) YES   NULL  
vtiger_user2mergefields visible int(2) YES   NULL  
Table Field Type Null Key Default Extra
vtiger_user2role userid int(11) NO PRI NULL  
vtiger_user2role roleid varchar(255) NO MUL NULL  
Table Field Type Null Key Default Extra
vtiger_user_module_preferences userid int(19) NO PRI NULL  
vtiger_user_module_preferences tabid int(19) NO PRI NULL  
vtiger_user_module_preferences default_cvid int(19) NO   NULL  
Table Field Type Null Key Default Extra
vtiger_users id int(11) NO PRI NULL auto_increment
vtiger_users user_name varchar(255) YES MUL NULL  
vtiger_users user_password varchar(30) YES MUL NULL  
vtiger_users user_hash varchar(32) YES   NULL  
vtiger_users cal_color varchar(25) YES   #E6FAD8  
vtiger_users first_name varchar(30) YES   NULL  
vtiger_users last_name varchar(30) YES   NULL  
vtiger_users reports_to_id varchar(36) YES   NULL  
vtiger_users is_admin varchar(3) YES   0  
vtiger_users currency_id int(19) NO   1  
vtiger_users description text YES   NULL  
vtiger_users date_entered timestamp NO   CURRENT_TIMESTAMP  
vtiger_users date_modified timestamp NO   0000-00-00 00:00:00  
vtiger_users modified_user_id varchar(36) YES   NULL  
vtiger_users title varchar(50) YES   NULL  
vtiger_users department varchar(50) YES   NULL  
vtiger_users phone_home varchar(50) YES   NULL  
vtiger_users phone_mobile varchar(50) YES   NULL  
vtiger_users phone_work varchar(50) YES   NULL  
vtiger_users phone_other varchar(50) YES   NULL  
vtiger_users phone_fax varchar(50) YES   NULL  
vtiger_users email1 varchar(100) YES   NULL  
vtiger_users email2 varchar(100) YES   NULL  
vtiger_users yahoo_id varchar(100) YES   NULL  
vtiger_users status varchar(25) YES   NULL  
vtiger_users signature varchar(250) YES   NULL  
vtiger_users address_street varchar(150) YES   NULL  
vtiger_users address_city varchar(100) YES   NULL  
vtiger_users address_state varchar(100) YES   NULL  
vtiger_users address_country