Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v digitidefeedbackdb aparam
* apid : int
* params : text
* apdate : datetime
v digitidefeedbackdb a_sbapi_logs
* aslid : int
* ipaddress : varchar(30)
* api : varchar(255)
* apiurl : varchar(255)
* requestparam : text
* requestdatetime : datetime
* responseparam : text
* responsedatetime : datetime
v digitidefeedbackdb com_vtiger_workflows
* workflow_id : int
* module_name : varchar(100)
* summary : varchar(400)
* test : text
* execution_condition : int
* defaultworkflow : int
* type : varchar(255)
* filtersavedinnew : int
* schtypeid : int
* schdayofmonth : varchar(100)
* schdayofweek : varchar(100)
* schannualdates : varchar(500)
* schtime : varchar(50)
* nexttrigger_time : datetime
* status : tinyint(1)
* workflowname : varchar(100)
v digitidefeedbackdb com_vtiger_workflows_seq
* id : int
v digitidefeedbackdb com_vtiger_workflowtasks
* task_id : int
* workflow_id : int
* summary : varchar(400)
* task : text
v digitidefeedbackdb com_vtiger_workflowtasks_entitymethod
* workflowtasks_entitymethod_id : int
* module_name : varchar(100)
* method_name : varchar(100)
* function_path : varchar(400)
* function_name : varchar(100)
v digitidefeedbackdb com_vtiger_workflowtasks_entitymethod_seq
* id : int
v digitidefeedbackdb com_vtiger_workflowtasks_seq
* id : int
v digitidefeedbackdb com_vtiger_workflowtask_queue
* task_id : int
* entity_id : varchar(100)
* do_after : int
* relatedinfo : varchar(255)
* task_contents : text
v digitidefeedbackdb com_vtiger_workflowtemplates
* template_id : int
* module_name : varchar(100)
* title : varchar(400)
* template : text
v digitidefeedbackdb com_vtiger_workflow_activatedonce
* workflow_id : int
* entity_id : int
v digitidefeedbackdb com_vtiger_workflow_tasktypes
* id : int
* tasktypename : varchar(255)
* label : varchar(255)
* classname : varchar(255)
* classpath : varchar(255)
* templatepath : varchar(255)
* modules : varchar(500)
* sourcemodule : varchar(255)
v digitidefeedbackdb com_vtiger_workflow_tasktypes_seq
* id : int
v digitidefeedbackdb new_customer_suraj_bharadwaj_table
* id : int
* Category : varchar(50)
* Subcategory : varchar(100)
* Subsubcategory : varchar(100)
* Productcategory : varchar(100)
v digitidefeedbackdb vtiger_account
* accountid : int
* account_no : varchar(100)
* accountname : varchar(100)
* parentid : int
* account_type : varchar(200)
* industry : varchar(200)
* annualrevenue : decimal(25,8)
* rating : varchar(200)
* ownership : varchar(50)
* siccode : varchar(50)
* tickersymbol : varchar(30)
* phone : varchar(30)
* otherphone : varchar(30)
* email1 : varchar(100)
* email2 : varchar(100)
* website : varchar(100)
* fax : varchar(30)
* employees : int
* emailoptout : varchar(3)
* notify_owner : varchar(3)
* isconvertedfromlead : varchar(3)
* tags : varchar(1)
v digitidefeedbackdb vtiger_accountbillads
* accountaddressid : int
* bill_city : varchar(30)
* bill_code : varchar(30)
* bill_country : varchar(30)
* bill_state : varchar(30)
* bill_street : varchar(250)
* bill_pobox : varchar(30)
v digitidefeedbackdb vtiger_accountrating
* accountratingid : int
* rating : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_accountscf
* accountid : int
v digitidefeedbackdb vtiger_accountshipads
* accountaddressid : int
* ship_city : varchar(30)
* ship_code : varchar(30)
* ship_country : varchar(30)
* ship_state : varchar(30)
* ship_pobox : varchar(30)
* ship_street : varchar(250)
v digitidefeedbackdb vtiger_accounttype
* accounttypeid : int
* accounttype : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_accounttype_seq
* id : int
v digitidefeedbackdb vtiger_actionmapping
* actionid : int
* actionname : varchar(200)
* securitycheck : int
v digitidefeedbackdb vtiger_activity
* activityid : int
* subject : varchar(255)
* semodule : varchar(20)
* activitytype : varchar(200)
* date_start : date
* due_date : date
* time_start : varchar(50)
* time_end : varchar(50)
* sendnotification : varchar(3)
* duration_hours : varchar(200)
* duration_minutes : varchar(200)
* status : varchar(200)
* eventstatus : varchar(200)
* priority : varchar(200)
* location : varchar(150)
* notime : varchar(3)
* visibility : varchar(50)
* recurringtype : varchar(200)
* tags : varchar(1)
v digitidefeedbackdb vtiger_activitycf
* activityid : int
v digitidefeedbackdb vtiger_activityproductrel
* activityid : int
* productid : int
v digitidefeedbackdb vtiger_activitytype
* activitytypeid : int
* activitytype : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_activitytype_seq
* id : int
v digitidefeedbackdb vtiger_activity_recurring_info
* activityid : int
* recurrenceid : int
v digitidefeedbackdb vtiger_activity_reminder
* activity_id : int
* reminder_time : int
* reminder_sent : int
* recurringid : int
v digitidefeedbackdb vtiger_activity_reminder_popup
* reminderid : int
* semodule : varchar(100)
* recordid : int
* date_start : date
* time_start : varchar(100)
* status : int
v digitidefeedbackdb vtiger_activity_view
* activity_viewid : int
* activity_view : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_activity_view_seq
* id : int
v digitidefeedbackdb vtiger_announcement
* creatorid : int
* announcement : text
* title : varchar(255)
* time : timestamp
v digitidefeedbackdb vtiger_apilogs
* apilogsid : int
* apitype : varchar(255)
v digitidefeedbackdb vtiger_apilogscf
* apilogsid : int
v digitidefeedbackdb vtiger_app2tab
* tabid : int
* appname : varchar(20)
* sequence : int
* visible : int
v digitidefeedbackdb vtiger_assets
* assetsid : int
* asset_no : varchar(30)
* account : int
* product : int
* serialnumber : varchar(200)
* datesold : date
* dateinservice : date
* assetstatus : varchar(200)
* tagnumber : varchar(300)
* invoiceid : int
* shippingmethod : varchar(200)
* shippingtrackingnumber : varchar(200)
* assetname : varchar(100)
* contact : int
* tags : varchar(1)
v digitidefeedbackdb vtiger_assetscf
* assetsid : int
v digitidefeedbackdb vtiger_assetstatus
* assetstatusid : int
* assetstatus : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_assetstatus_seq
* id : int
v digitidefeedbackdb vtiger_asterisk
* server : varchar(30)
* port : varchar(30)
* username : varchar(50)
* password : varchar(50)
* version : varchar(50)
v digitidefeedbackdb vtiger_asteriskextensions
* userid : int
* asterisk_extension : varchar(50)
* use_asterisk : varchar(3)
v digitidefeedbackdb vtiger_asteriskincomingcalls
* from_number : varchar(50)
* from_name : varchar(50)
* to_number : varchar(50)
* callertype : varchar(30)
* flag : int
* timer : int
* refuid : varchar(255)
v digitidefeedbackdb vtiger_asteriskincomingevents
* uid : varchar(255)
* channel : varchar(100)
* from_number : bigint
* from_name : varchar(100)
* to_number : bigint
* callertype : varchar(100)
* timer : int
* flag : varchar(3)
* pbxrecordid : int
* relcrmid : int
v digitidefeedbackdb vtiger_attachments
* attachmentsid : int
* name : varchar(255)
* description : text
* type : varchar(100)
* path : text
* storedname : varchar(255)
* subject : varchar(255)
v digitidefeedbackdb vtiger_attachmentsfolder
* folderid : int
* foldername : varchar(200)
* description : varchar(250)
* createdby : int
* sequence : int
v digitidefeedbackdb vtiger_attachmentsfolder_seq
* id : int
v digitidefeedbackdb vtiger_audit_trial
* auditid : int
* userid : int
* module : varchar(255)
* action : varchar(255)
* recordid : varchar(20)
* actiondate : datetime
v digitidefeedbackdb vtiger_blocks
* blockid : int
* tabid : int
* blocklabel : varchar(100)
* sequence : int
* show_title : int
* visible : int
* create_view : int
* edit_view : int
* detail_view : int
* display_status : int
* iscustom : int
v digitidefeedbackdb vtiger_blocks_seq
* id : int
v digitidefeedbackdb vtiger_branch
* branchid : int
* branchname : varchar(255)
v digitidefeedbackdb vtiger_branchcf
* branchid : int
* cf_880 : varchar(100)
* cf_882 : varchar(50)
* cf_884 : varchar(50)
* cf_886 : varchar(30)
* cf_888 : varchar(50)
* cf_890 : varchar(50)
* cf_892 : varchar(100)
* cf_894 : varchar(100)
* cf_896 : varchar(50)
* cf_898 : varchar(50)
* cf_900 : varchar(255)
* cf_902 : varchar(255)
* cf_904 : varchar(255)
v digitidefeedbackdb vtiger_calendarsharedtype
* calendarsharedtypeid : int
* calendarsharedtype : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_calendarsharedtype_seq
* id : int
v digitidefeedbackdb vtiger_calendar_default_activitytypes
* id : int
* module : varchar(50)
* fieldname : varchar(50)
* defaultcolor : varchar(50)
* isdefault : int
* conditions : varchar(255)
v digitidefeedbackdb vtiger_calendar_default_activitytypes_seq
* id : int
v digitidefeedbackdb vtiger_calendar_user_activitytypes
* id : int
* defaultid : int
* userid : int
* color : varchar(50)
* visible : int
v digitidefeedbackdb vtiger_calendar_user_activitytypes_seq
* id : int
v digitidefeedbackdb vtiger_calldetail
* calldetailid : int
* leadname : varchar(255)
v digitidefeedbackdb vtiger_calldetailcf
* calldetailid : int
v digitidefeedbackdb vtiger_callduration
* calldurationid : int
* callduration : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_callduration_seq
* id : int
v digitidefeedbackdb vtiger_campaign
* campaign_no : varchar(100)
* campaignname : varchar(255)
* campaigntype : varchar(200)
* campaignstatus : varchar(200)
* expectedrevenue : decimal(25,8)
* budgetcost : decimal(25,8)
* actualcost : decimal(25,8)
* expectedresponse : varchar(200)
* numsent : decimal(11,0)
* product_id : int
* sponsor : varchar(255)
* targetaudience : varchar(255)
* targetsize : int
* expectedresponsecount : int
* expectedsalescount : int
* expectedroi : decimal(25,8)
* actualresponsecount : int
* actualsalescount : int
* actualroi : decimal(25,8)
* campaignid : int
* closingdate : date
* tags : varchar(1)
v digitidefeedbackdb vtiger_campaignaccountrel
* campaignid : int
* accountid : int
* campaignrelstatusid : int
v digitidefeedbackdb vtiger_campaigncontrel
* campaignid : int
* contactid : int
* campaignrelstatusid : int
v digitidefeedbackdb vtiger_campaignleadrel
* campaignid : int
* leadid : int
* campaignrelstatusid : int
v digitidefeedbackdb vtiger_campaignrelstatus
* campaignrelstatusid : int
* campaignrelstatus : varchar(256)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_campaignrelstatus_seq
* id : int
v digitidefeedbackdb vtiger_campaignscf
* campaignid : int
v digitidefeedbackdb vtiger_campaignstatus
* campaignstatusid : int
* campaignstatus : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_campaignstatus_seq
* id : int
v digitidefeedbackdb vtiger_campaigntype
* campaigntypeid : int
* campaigntype : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_campaigntype_seq
* id : int
v digitidefeedbackdb vtiger_carrier
* carrierid : int
* carrier : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_carrier_seq
* id : int
v digitidefeedbackdb vtiger_cf_900
* cf_900id : int
* cf_900 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_900_seq
* id : int
v digitidefeedbackdb vtiger_cf_904
* cf_904id : int
* cf_904 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_904_seq
* id : int
v digitidefeedbackdb vtiger_cf_912
* cf_912id : int
* cf_912 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_912_seq
* id : int
v digitidefeedbackdb vtiger_cf_916
* cf_916id : int
* cf_916 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_916_seq
* id : int
v digitidefeedbackdb vtiger_cf_918
* cf_918id : int
* cf_918 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_918_seq
* id : int
v digitidefeedbackdb vtiger_cf_920
* cf_920id : int
* cf_920 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_920_seq
* id : int
v digitidefeedbackdb vtiger_cf_922
* cf_922id : int
* cf_922 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_922_seq
* id : int
v digitidefeedbackdb vtiger_cf_924
* cf_924id : int
* cf_924 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_924_seq
* id : int
v digitidefeedbackdb vtiger_cf_926
* cf_926id : int
* cf_926 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_926_seq
* id : int
v digitidefeedbackdb vtiger_cf_936
* cf_936id : int
* cf_936 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_936_seq
* id : int
v digitidefeedbackdb vtiger_cf_946
* cf_946id : int
* cf_946 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_946_seq
* id : int
v digitidefeedbackdb vtiger_cf_978
* cf_978id : int
* cf_978 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_978_seq
* id : int
v digitidefeedbackdb vtiger_cf_1018
* cf_1018id : int
* cf_1018 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1018_seq
* id : int
v digitidefeedbackdb vtiger_cf_1030
* cf_1030id : int
* cf_1030 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1030_seq
* id : int
v digitidefeedbackdb vtiger_cf_1034
* cf_1034id : int
* cf_1034 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1034_seq
* id : int
v digitidefeedbackdb vtiger_cf_1038
* cf_1038id : int
* cf_1038 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1038_seq
* id : int
v digitidefeedbackdb vtiger_cf_1054
* cf_1054id : int
* cf_1054 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1054_seq
* id : int
v digitidefeedbackdb vtiger_cf_1056
* cf_1056id : int
* cf_1056 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1056_seq
* id : int
v digitidefeedbackdb vtiger_cf_1058
* cf_1058id : int
* cf_1058 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1058_seq
* id : int
v digitidefeedbackdb vtiger_cf_1060
* cf_1060id : int
* cf_1060 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1060_seq
* id : int
v digitidefeedbackdb vtiger_cf_1062
* cf_1062id : int
* cf_1062 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1062_seq
* id : int
v digitidefeedbackdb vtiger_cf_1070
* cf_1070id : int
* cf_1070 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1070_seq
* id : int
v digitidefeedbackdb vtiger_cf_1072
* cf_1072id : int
* cf_1072 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1072_seq
* id : int
v digitidefeedbackdb vtiger_cf_1074
* cf_1074id : int
* cf_1074 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1074_seq
* id : int
v digitidefeedbackdb vtiger_cf_1096
* cf_1096id : int
* cf_1096 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1096_seq
* id : int
v digitidefeedbackdb vtiger_cf_1120
* cf_1120id : int
* cf_1120 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1120_seq
* id : int
v digitidefeedbackdb vtiger_cf_1146
* cf_1146id : int
* cf_1146 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1146_seq
* id : int
v digitidefeedbackdb vtiger_cf_1148
* cf_1148id : int
* cf_1148 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1148_seq
* id : int
v digitidefeedbackdb vtiger_cf_1150
* cf_1150id : int
* cf_1150 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1150_seq
* id : int
v digitidefeedbackdb vtiger_cf_1152
* cf_1152id : int
* cf_1152 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1152_seq
* id : int
v digitidefeedbackdb vtiger_cf_1164
* cf_1164id : int
* cf_1164 : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_cf_1164_seq
* id : int
v digitidefeedbackdb vtiger_cntactivityrel
* contactid : int
* activityid : int
v digitidefeedbackdb vtiger_contactaddress
* contactaddressid : int
* mailingcity : varchar(40)
* mailingstreet : varchar(250)
* mailingcountry : varchar(40)
* othercountry : varchar(30)
* mailingstate : varchar(30)
* mailingpobox : varchar(30)
* othercity : varchar(40)
* otherstate : varchar(50)
* mailingzip : varchar(30)
* otherzip : varchar(30)
* otherstreet : varchar(250)
* otherpobox : varchar(30)
v digitidefeedbackdb vtiger_contactdetails
* contactid : int
* contact_no : varchar(100)
* accountid : int
* salutation : varchar(200)
* firstname : varchar(40)
* lastname : varchar(80)
* email : varchar(100)
* phone : varchar(50)
* mobile : varchar(50)
* title : varchar(50)
* department : varchar(30)
* fax : varchar(50)
* reportsto : varchar(30)
* training : varchar(50)
* usertype : varchar(50)
* contacttype : varchar(50)
* otheremail : varchar(100)
* secondaryemail : varchar(100)
* donotcall : varchar(3)
* emailoptout : varchar(3)
* imagename : varchar(150)
* reference : varchar(3)
* notify_owner : varchar(3)
* isconvertedfromlead : varchar(3)
* tags : varchar(1)
v digitidefeedbackdb vtiger_contactscf
* contactid : int
* cf_1146 : varchar(255)
* cf_1148 : varchar(255)
* cf_1150 : varchar(255)
* cf_1152 : varchar(255)
* cf_1154 : date
* cf_1156 : time
* cf_1158 : varchar(255)
* cf_1160 : varchar(255)
* cf_1162 : varchar(100)
* cf_1164 : varchar(255)
* cf_1166 : varchar(100)
v digitidefeedbackdb vtiger_contactsubdetails
* contactsubscriptionid : int
* homephone : varchar(50)
* otherphone : varchar(50)
* assistant : varchar(30)
* assistantphone : varchar(50)
* birthday : date
* laststayintouchrequest : int
* laststayintouchsavedate : int
* leadsource : varchar(200)
v digitidefeedbackdb vtiger_contpotentialrel
* contactid : int
* potentialid : int
v digitidefeedbackdb vtiger_contract_priority
* contract_priorityid : int
* contract_priority : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_contract_priority_seq
* id : int
v digitidefeedbackdb vtiger_contract_status
* contract_statusid : int
* contract_status : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_contract_status_seq
* id : int
v digitidefeedbackdb vtiger_contract_type
* contract_typeid : int
* contract_type : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_contract_type_seq
* id : int
v digitidefeedbackdb vtiger_convertleadmapping
* cfmid : int
* leadfid : int
* accountfid : int
* contactfid : int
* potentialfid : int
* editable : int
v digitidefeedbackdb vtiger_convertpotentialmapping
* cfmid : int
* potentialfid : int
* projectfid : int
* editable : int
v digitidefeedbackdb vtiger_crmentity
* crmid : int
* smcreatorid : int
* smownerid : int
* modifiedby : int
* setype : varchar(100)
* description : mediumtext
* createdtime : datetime
* modifiedtime : datetime
* viewedtime : datetime
* status : varchar(50)
* version : int
* presence : int
* deleted : int
* smgroupid : int
* source : varchar(100)
* label : varchar(255)
v digitidefeedbackdb vtiger_crmentityrel
* crmid : int
* module : varchar(100)
* relcrmid : int
* relmodule : varchar(100)
v digitidefeedbackdb vtiger_crmentity_seq
* id : int
v digitidefeedbackdb vtiger_crmentity_user_field
* recordid : int
* userid : int
* starred : varchar(100)
v digitidefeedbackdb vtiger_crmsetup
* userid : int
* setup_status : int
v digitidefeedbackdb vtiger_cron_task
* id : int
* name : varchar(100)
* handler_file : varchar(100)
* frequency : int
* laststart : int unsigned
* lastend : int unsigned
* status : int
* module : varchar(100)
* sequence : int
* description : text
v digitidefeedbackdb vtiger_currencies
* currencyid : int
* currency_name : varchar(200)
* currency_code : varchar(50)
* currency_symbol : varchar(11)
v digitidefeedbackdb vtiger_currencies_seq
* id : int
v digitidefeedbackdb vtiger_currency
* currencyid : int
* currency : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_currency_decimal_separator
* currency_decimal_separatorid : int
* currency_decimal_separator : varchar(2)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_currency_decimal_separator_seq
* id : int
v digitidefeedbackdb vtiger_currency_grouping_pattern
* currency_grouping_patternid : int
* currency_grouping_pattern : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_currency_grouping_pattern_seq
* id : int
v digitidefeedbackdb vtiger_currency_grouping_separator
* currency_grouping_separatorid : int
* currency_grouping_separator : varchar(2)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_currency_grouping_separator_seq
* id : int
v digitidefeedbackdb vtiger_currency_info
* id : int
* currency_name : varchar(100)
* currency_code : varchar(100)
* currency_symbol : varchar(30)
* conversion_rate : decimal(12,5)
* currency_status : varchar(25)
* defaultid : varchar(10)
* deleted : int
v digitidefeedbackdb vtiger_currency_info_seq
* id : int
v digitidefeedbackdb vtiger_currency_symbol_placement
* currency_symbol_placementid : int
* currency_symbol_placement : varchar(30)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_currency_symbol_placement_seq
* id : int
v digitidefeedbackdb vtiger_customaction
* cvid : int
* subject : varchar(250)
* module : varchar(50)
* content : text
v digitidefeedbackdb vtiger_customerdetails
* customerid : int
* portal : varchar(3)
* support_start_date : date
* support_end_date : date
v digitidefeedbackdb vtiger_customerportal_fields
* tabid : int
* fieldinfo : text
* records_visible : int
v digitidefeedbackdb vtiger_customerportal_prefs
* tabid : int
* prefkey : varchar(100)
* prefvalue : int
v digitidefeedbackdb vtiger_customerportal_relatedmoduleinfo
* tabid : int
* relatedmodules : text
v digitidefeedbackdb vtiger_customerportal_settings
* id : int
* url : varchar(250)
* default_assignee : int
* support_notification : int
* announcement : text
* shortcuts : text
* widgets : text
* charts : text
v digitidefeedbackdb vtiger_customerportal_tabs
* tabid : int
* visible : int
* sequence : int
* createrecord : tinyint(1)
* editrecord : tinyint(1)
v digitidefeedbackdb vtiger_custommodule
* custommoduleid : int
* custom_field_name : varchar(255)
* custom_date_field : date
v digitidefeedbackdb vtiger_custommodulecf
* custommoduleid : int
v digitidefeedbackdb vtiger_customview
* cvid : int
* viewname : varchar(100)
* setdefault : int
* setmetrics : int
* entitytype : varchar(25)
* status : int
* userid : int
v digitidefeedbackdb vtiger_customview_seq
* id : int
v digitidefeedbackdb vtiger_cv2group
* cvid : int
* groupid : int
v digitidefeedbackdb vtiger_cv2role
* cvid : int
* roleid : varchar(255)
v digitidefeedbackdb vtiger_cv2rs
* cvid : int
* rsid : varchar(255)
v digitidefeedbackdb vtiger_cv2users
* cvid : int
* userid : int
v digitidefeedbackdb vtiger_cvadvfilter
* cvid : int
* columnindex : int
* columnname : varchar(250)
* comparator : varchar(20)
* value : varchar(512)
* groupid : int
* column_condition : varchar(255)
v digitidefeedbackdb vtiger_cvadvfilter_grouping
* groupid : int
* cvid : int
* group_condition : varchar(255)
* condition_expression : text
v digitidefeedbackdb vtiger_cvcolumnlist
* cvid : int
* columnindex : int
* columnname : varchar(250)
v digitidefeedbackdb vtiger_cvstdfilter
* cvid : int
* columnname : varchar(250)
* stdfilter : varchar(250)
* startdate : date
* enddate : date
v digitidefeedbackdb vtiger_dashboard_tabs
* id : int
* tabname : varchar(50)
* isdefault : int
* sequence : int
* appname : varchar(20)
* modulename : varchar(50)
* userid : int
v digitidefeedbackdb vtiger_datashare_grp2grp
* shareid : int
* share_groupid : int
* to_groupid : int
* permission : int
v digitidefeedbackdb vtiger_datashare_grp2role
* shareid : int
* share_groupid : int
* to_roleid : varchar(255)
* permission : int
v digitidefeedbackdb vtiger_datashare_grp2rs
* shareid : int
* share_groupid : int
* to_roleandsubid : varchar(255)
* permission : int
v digitidefeedbackdb vtiger_datashare_module_rel
* shareid : int
* tabid : int
* relationtype : varchar(200)
v digitidefeedbackdb vtiger_datashare_relatedmodules
* datashare_relatedmodule_id : int
* tabid : int
* relatedto_tabid : int
v digitidefeedbackdb vtiger_datashare_relatedmodules_seq
* id : int
v digitidefeedbackdb vtiger_datashare_relatedmodule_permission
* shareid : int
* datashare_relatedmodule_id : int
* permission : int
v digitidefeedbackdb vtiger_datashare_role2group
* shareid : int
* share_roleid : varchar(255)
* to_groupid : int
* permission : int
v digitidefeedbackdb vtiger_datashare_role2role
* shareid : int
* share_roleid : varchar(255)
* to_roleid : varchar(255)
* permission : int
v digitidefeedbackdb vtiger_datashare_role2rs
* shareid : int
* share_roleid : varchar(255)
* to_roleandsubid : varchar(255)
* permission : int
v digitidefeedbackdb vtiger_datashare_rs2grp
* shareid : int
* share_roleandsubid : varchar(255)
* to_groupid : int
* permission : int
v digitidefeedbackdb vtiger_datashare_rs2role
* shareid : int
* share_roleandsubid : varchar(255)
* to_roleid : varchar(255)
* permission : int
v digitidefeedbackdb vtiger_datashare_rs2rs
* shareid : int
* share_roleandsubid : varchar(255)
* to_roleandsubid : varchar(255)
* permission : int
v digitidefeedbackdb vtiger_date_format
* date_formatid : int
* date_format : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_date_format_seq
* id : int
v digitidefeedbackdb vtiger_dayoftheweek
* dayoftheweekid : int
* dayoftheweek : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_dayoftheweek_seq
* id : int
v digitidefeedbackdb vtiger_defaultactivitytype
* defaultactivitytypeid : int
* defaultactivitytype : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
v digitidefeedbackdb vtiger_defaultactivitytype_seq
* id : int
v digitidefeedbackdb vtiger_defaultcalendarview
* defaultcalendarviewid : int
* defaultcalendarview : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_defaultcalendarview_seq
* id : int
v digitidefeedbackdb vtiger_defaultcv
* tabid : int
* defaultviewname : varchar(50)
* query : text
v digitidefeedbackdb vtiger_defaulteventstatus
* defaulteventstatusid : int
* defaulteventstatus : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
v digitidefeedbackdb vtiger_defaulteventstatus_seq
* id : int
v digitidefeedbackdb vtiger_defaultlandingpage
* defaultlandingpageid : int
* defaultlandingpage : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_defaultlandingpage_seq
* id : int
v digitidefeedbackdb vtiger_default_record_view
* default_record_viewid : int
* default_record_view : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_default_record_view_seq
* id : int
v digitidefeedbackdb vtiger_def_org_field
* tabid : int
* fieldid : int
* visible : int
* readonly : int
v digitidefeedbackdb vtiger_def_org_share
* ruleid : int
* tabid : int
* permission : int
* editstatus : int
v digitidefeedbackdb vtiger_def_org_share_seq
* id : int
v digitidefeedbackdb vtiger_districtmaster
* districtmasterid : int
* districtname : varchar(100)
* districtcode : varchar(15)
* country : varchar(100)
* state : varchar(100)
* districtactive : varchar(100)
v digitidefeedbackdb vtiger_durationhrs
* hrsid : int
* hrs : varchar(50)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_durationmins
* minsid : int
* mins : varchar(50)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_duration_minutes
* minutesid : int
* duration_minutes : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_duration_minutes_seq
* id : int
v digitidefeedbackdb vtiger_emaildetails
* emailid : int
* from_email : varchar(50)
* to_email : text
* cc_email : text
* bcc_email : text
* assigned_user_email : varchar(50)
* idlists : text
* email_flag : varchar(50)
v digitidefeedbackdb vtiger_emailslookup
* crmid : int
* setype : varchar(100)
* value : varchar(100)
* fieldid : int
v digitidefeedbackdb vtiger_emails_recipientprefs
* id : int
* tabid : int
* prefs : varchar(255)
* userid : int
v digitidefeedbackdb vtiger_emailtemplates
* foldername : varchar(100)
* templatename : varchar(100)
* templatepath : varchar(100)
* subject : varchar(255)
* description : text
* body : text
* deleted : int
* templateid : int
* systemtemplate : int
* module : varchar(100)
v digitidefeedbackdb vtiger_emailtemplates_seq
* id : int
v digitidefeedbackdb vtiger_email_access
* crmid : int
* mailid : int
* accessdate : date
* accesstime : datetime
v digitidefeedbackdb vtiger_email_track
* crmid : int
* mailid : int
* access_count : int
* click_count : int
v digitidefeedbackdb vtiger_entityname
* tabid : int
* modulename : varchar(100)
* tablename : varchar(100)
* fieldname : varchar(150)
* entityidfield : varchar(150)
* entityidcolumn : varchar(150)
v digitidefeedbackdb vtiger_eventhandlers
* eventhandler_id : int
* event_name : varchar(100)
* handler_path : varchar(400)
* handler_class : varchar(100)
* cond : text
* is_active : int
* dependent_on : varchar(255)
v digitidefeedbackdb vtiger_eventhandlers_seq
* id : int
v digitidefeedbackdb vtiger_eventhandler_module
* eventhandler_module_id : int
* module_name : varchar(100)
* handler_class : varchar(100)
v digitidefeedbackdb vtiger_eventhandler_module_seq
* id : int
v digitidefeedbackdb vtiger_eventstatus
* eventstatusid : int
* eventstatus : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_eventstatus_seq
* id : int
v digitidefeedbackdb vtiger_expectedresponse
* expectedresponseid : int
* expectedresponse : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_expectedresponse_seq
* id : int
v digitidefeedbackdb vtiger_extnstore_users
* id : int
* username : varchar(50)
* password : varchar(75)
* instanceurl : varchar(255)
* createdon : datetime
* deleted : int
v digitidefeedbackdb vtiger_faq
* id : int
* faq_no : varchar(100)
* product_id : varchar(100)
* question : text
* answer : text
* category : varchar(200)
* status : varchar(200)
* tags : varchar(1)
v digitidefeedbackdb vtiger_faqcategories
* faqcategories_id : int
* faqcategories : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_faqcategories_seq
* id : int
v digitidefeedbackdb vtiger_faqcf
* faqid : int
v digitidefeedbackdb vtiger_faqcomments
* commentid : int
* faqid : int
* comments : text
* createdtime : datetime
v digitidefeedbackdb vtiger_faqstatus
* faqstatus_id : int
* faqstatus : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_faqstatus_seq
* id : int
v digitidefeedbackdb vtiger_feedback
* userid : int
* dontshow : varchar(19)
v digitidefeedbackdb vtiger_field
* tabid : int
* fieldid : int
* columnname : varchar(30)
* tablename : varchar(100)
* generatedtype : int
* uitype : varchar(30)
* fieldname : varchar(50)
* fieldlabel : varchar(50)
* readonly : int
* presence : int
* defaultvalue : text
* maximumlength : int
* sequence : int
* block : int
* displaytype : int
* typeofdata : varchar(100)
* quickcreate : int
* quickcreatesequence : int
* info_type : varchar(20)
* masseditable : int
* helpinfo : text
* summaryfield : int
* headerfield : int
* isunique : tinyint(1)
v digitidefeedbackdb vtiger_fieldmodulerel
* fieldid : int
* module : varchar(100)
* relmodule : varchar(100)
* status : varchar(10)
* sequence : int
v digitidefeedbackdb vtiger_field_seq
* id : int
v digitidefeedbackdb vtiger_freetagged_objects
* tag_id : int
* tagger_id : int
* object_id : int
* tagged_on : timestamp
* module : varchar(100)
v digitidefeedbackdb vtiger_freetags
* id : int
* tag : varchar(50)
* raw_tag : varchar(50)
* visibility : varchar(100)
* owner : int
v digitidefeedbackdb vtiger_freetags_seq
* id : int
v digitidefeedbackdb vtiger_glacct
* glacctid : int
* glacct : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_glacct_seq
* id : int
v digitidefeedbackdb vtiger_google_event_calendar_mapping
* event_id : varchar(255)
* calendar_id : varchar(255)
* user_id : int
v digitidefeedbackdb vtiger_google_oauth2
* service : varchar(20)
* access_token : varchar(500)
* refresh_token : varchar(500)
* userid : int
v digitidefeedbackdb vtiger_google_sync_fieldmapping
* vtiger_field : varchar(255)
* google_field : varchar(255)
* google_field_type : varchar(255)
* google_custom_label : varchar(255)
* user : int
v digitidefeedbackdb vtiger_google_sync_settings
* user : int
* module : varchar(50)
* clientgroup : varchar(255)
* direction : varchar(50)
* enabled : tinyint
v digitidefeedbackdb vtiger_group2grouprel
* groupid : int
* containsgroupid : int
v digitidefeedbackdb vtiger_group2role
* groupid : int
* roleid : varchar(255)
v digitidefeedbackdb vtiger_group2rs
* groupid : int
* roleandsubid : varchar(255)
v digitidefeedbackdb vtiger_groups
* groupid : int
* groupname : varchar(100)
* description : text
v digitidefeedbackdb vtiger_homedashbd
* stuffid : int
* dashbdname : varchar(100)
* dashbdtype : varchar(100)
v digitidefeedbackdb vtiger_homedefault
* stuffid : int
* hometype : varchar(30)
* maxentries : int
* setype : varchar(30)
v digitidefeedbackdb vtiger_homemodule
* stuffid : int
* modulename : varchar(100)
* maxentries : int
* customviewid : int
* setype : varchar(30)
v digitidefeedbackdb vtiger_homemoduleflds
* stuffid : int
* fieldname : varchar(100)
v digitidefeedbackdb vtiger_homereportchart
* stuffid : int
* reportid : int
* reportcharttype : varchar(100)
v digitidefeedbackdb vtiger_homerss
* stuffid : int
* url : varchar(100)
* maxentries : int
v digitidefeedbackdb vtiger_homestuff
* stuffid : int
* stuffsequence : int
* stufftype : varchar(100)
* userid : int
* visible : int
* stufftitle : varchar(100)
v digitidefeedbackdb vtiger_homestuff_seq
* id : int
v digitidefeedbackdb vtiger_home_layout
* userid : int
* layout : int
v digitidefeedbackdb vtiger_hour_format
* hour_formatid : int
* hour_format : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_hour_format_seq
* id : int
v digitidefeedbackdb vtiger_import_1
* id : int
* status : int
* recordid : int
* firstname : varchar(40)
* lastname : varchar(80)
* mobile : varchar(50)
* email : varchar(100)
* cf_1166 : varchar(100)
* birthday : varchar(250)
* cf_1146 : varchar(255)
* cf_1148 : varchar(255)
* cf_1150 : varchar(255)
* cf_1152 : varchar(255)
* cf_1158 : varchar(255)
* cf_1160 : varchar(255)
* cf_1154 : varchar(250)
* cf_1156 : time
* description : mediumtext
* mailingstreet : varchar(250)
* otherstreet : varchar(250)
* mailingpobox : varchar(30)
* otherpobox : varchar(30)
* mailingcity : varchar(40)
* othercity : varchar(40)
* mailingstate : varchar(30)
* otherstate : varchar(50)
* mailingzip : varchar(30)
* otherzip : varchar(30)
* mailingcountry : varchar(40)
* othercountry : varchar(30)
v digitidefeedbackdb vtiger_import_locks
* vtiger_import_lock_id : int
* userid : int
* tabid : int
* importid : int
* locked_since : datetime
v digitidefeedbackdb vtiger_import_locks_seq
* id : int
v digitidefeedbackdb vtiger_import_maps
* id : int
* name : varchar(36)
* module : varchar(36)
* content : longblob
* has_header : int
* deleted : int
* date_entered : timestamp
* date_modified : datetime
* assigned_user_id : varchar(36)
* is_published : varchar(3)
v digitidefeedbackdb vtiger_import_queue
* importid : int
* userid : int
* tabid : int
* field_mapping : text
* default_values : text
* merge_type : int
* merge_fields : text
* status : int
* lineitem_currency_id : int
* paging : int
v digitidefeedbackdb vtiger_import_queue_seq
* id : int
v digitidefeedbackdb vtiger_industry
* industryid : int
* industry : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_industry_seq
* id : int
v digitidefeedbackdb vtiger_inventorycharges
* chargeid : int
* name : varchar(100)
* format : varchar(10)
* type : varchar(10)
* value : decimal(12,5)
* regions : text
* istaxable : int
* taxes : varchar(1024)
* deleted : int
v digitidefeedbackdb vtiger_inventorychargesrel
* recordid : int
* charges : text
v digitidefeedbackdb vtiger_inventorynotification
* notificationid : int
* notificationname : varchar(200)
* notificationsubject : varchar(200)
* notificationbody : text
* label : varchar(50)
* status : varchar(30)
v digitidefeedbackdb vtiger_inventorynotification_seq
* id : int
v digitidefeedbackdb vtiger_inventoryproductrel
* id : int
* productid : int
* sequence_no : int
* quantity : decimal(25,3)
* listprice : decimal(27,8)
* discount_percent : decimal(7,3)
* discount_amount : decimal(27,8)
* comment : text
* description : text
* incrementondel : int
* lineitem_id : int
* tax1 : decimal(7,3)
* tax2 : decimal(7,3)
* tax3 : decimal(7,3)
* image : varchar(2)
* purchase_cost : decimal(27,8)
* margin : decimal(27,8)
v digitidefeedbackdb vtiger_inventoryproductrel_seq
* id : int
v digitidefeedbackdb vtiger_inventoryshippingrel
* id : int
* shtax1 : decimal(7,3)
* shtax2 : decimal(7,3)
* shtax3 : decimal(7,3)
v digitidefeedbackdb vtiger_inventorysubproductrel
* id : int
* sequence_no : int
* productid : int
* quantity : int
v digitidefeedbackdb vtiger_inventorytaxinfo
* taxid : int
* taxname : varchar(50)
* taxlabel : varchar(50)
* percentage : decimal(7,3)
* deleted : int
* method : varchar(10)
* type : varchar(10)
* compoundon : varchar(400)
* regions : text
v digitidefeedbackdb vtiger_inventorytaxinfo_seq
* id : int
v digitidefeedbackdb vtiger_inventory_tandc
* id : int
* type : varchar(30)
* tandc : text
v digitidefeedbackdb vtiger_inventory_tandc_seq
* id : int
v digitidefeedbackdb vtiger_invitees
* activityid : int
* inviteeid : int
* status : varchar(50)
v digitidefeedbackdb vtiger_invoice
* invoiceid : int
* subject : varchar(100)
* salesorderid : int
* customerno : varchar(100)
* contactid : int
* notes : varchar(100)
* invoicedate : date
* duedate : date
* invoiceterms : varchar(100)
* type : varchar(100)
* adjustment : decimal(25,8)
* salescommission : decimal(25,3)
* exciseduty : decimal(25,3)
* subtotal : decimal(25,8)
* total : decimal(25,8)
* taxtype : varchar(25)
* discount_percent : decimal(25,3)
* discount_amount : decimal(25,8)
* s_h_amount : decimal(25,8)
* shipping : varchar(100)
* accountid : int
* terms_conditions : text
* purchaseorder : varchar(200)
* invoicestatus : varchar(200)
* invoice_no : varchar(100)
* currency_id : int
* conversion_rate : decimal(10,3)
* compound_taxes_info : text
* pre_tax_total : decimal(25,8)
* received : decimal(25,8)
* balance : decimal(25,8)
* s_h_percent : decimal(25,8)
* potential_id : varchar(100)
* tags : varchar(1)
* region_id : int
v digitidefeedbackdb vtiger_invoicebillads
* invoicebilladdressid : int
* bill_city : varchar(30)
* bill_code : varchar(30)
* bill_country : varchar(30)
* bill_state : varchar(30)
* bill_street : varchar(250)
* bill_pobox : varchar(30)
v digitidefeedbackdb vtiger_invoicecf
* invoiceid : int
v digitidefeedbackdb vtiger_invoiceshipads
* invoiceshipaddressid : int
* ship_city : varchar(30)
* ship_code : varchar(30)
* ship_country : varchar(30)
* ship_state : varchar(30)
* ship_street : varchar(250)
* ship_pobox : varchar(30)
v digitidefeedbackdb vtiger_invoicestatus
* invoicestatusid : int
* invoicestatus : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_invoicestatushistory
* historyid : int
* invoiceid : int
* accountname : varchar(100)
* total : decimal(10,0)
* invoicestatus : varchar(200)
* lastmodified : datetime
v digitidefeedbackdb vtiger_invoicestatus_seq
* id : int
v digitidefeedbackdb vtiger_invoice_recurring_info
* salesorderid : int
* recurring_frequency : varchar(200)
* start_period : date
* end_period : date
* last_recurring_date : date
* payment_duration : varchar(200)
* invoice_status : varchar(200)
v digitidefeedbackdb vtiger_language
* id : int
* name : varchar(50)
* prefix : varchar(10)
* label : varchar(30)
* lastupdated : datetime
* sequence : int
* isdefault : int
* active : int
v digitidefeedbackdb vtiger_language_seq
* id : int
v digitidefeedbackdb vtiger_leadaddress
* leadaddressid : int
* city : varchar(30)
* code : varchar(30)
* state : varchar(30)
* pobox : varchar(30)
* country : varchar(30)
* phone : varchar(50)
* mobile : varchar(50)
* fax : varchar(50)
* lane : varchar(250)
* leadaddresstype : varchar(30)
v digitidefeedbackdb vtiger_leaddetails
* leadid : int
* lead_no : varchar(100)
* email : varchar(100)
* interest : varchar(50)
* firstname : varchar(40)
* salutation : varchar(200)
* lastname : varchar(80)
* company : varchar(100)
* annualrevenue : decimal(25,8)
* industry : varchar(200)
* campaign : varchar(30)
* rating : varchar(200)
* leadstatus : varchar(200)
* leadsource : varchar(200)
* converted : int
* designation : varchar(50)
* licencekeystatus : varchar(50)
* space : varchar(250)
* comments : text
* priority : varchar(50)
* demorequest : varchar(50)
* partnercontact : varchar(50)
* productversion : varchar(20)
* product : varchar(50)
* maildate : date
* nextstepdate : date
* fundingsituation : varchar(50)
* purpose : varchar(50)
* evaluationstatus : varchar(50)
* transferdate : date
* revenuetype : varchar(50)
* noofemployees : int
* secondaryemail : varchar(100)
* assignleadchk : int
* emailoptout : varchar(3)
* tags : varchar(1)
v digitidefeedbackdb vtiger_leadscf
* leadid : int
* cf_906 : varchar(30)
* cf_908 : varchar(20)
* cf_910 : varchar(20)
* cf_912 : varchar(255)
* cf_914 : varchar(255)
* cf_916 : varchar(255)
* cf_1030 : varchar(255)
* cf_1032 : varchar(100)
* cf_1034 : varchar(255)
* cf_1036 : varchar(100)
* cf_1038 : varchar(255)
* cf_1040 : varchar(100)
* cf_1042 : date
* cf_1044 : decimal(15,5)
* cf_1046 : decimal(15,5)
* cf_1048 : date
* cf_1050 : varchar(100)
* cf_1052 : varchar(50)
* cf_1054 : varchar(255)
* cf_1056 : varchar(255)
* cf_1058 : varchar(255)
* cf_1060 : varchar(255)
* cf_1062 : varchar(255)
* cf_1064 : varchar(3)
* cf_1066 : varchar(3)
* cf_1068 : varchar(3)
* cf_1070 : varchar(255)
* cf_1072 : varchar(255)
* cf_1074 : varchar(255)
* cf_1076 : text
* cf_1078 : varchar(100)
* cf_1080 : varchar(40)
* cf_1082 : varchar(100)
* cf_1084 : varchar(100)
* cf_1086 : varchar(30)
* cf_1088 : decimal(15,5)
* cf_1090 : varchar(100)
* cf_1092 : varchar(100)
* cf_1094 : varchar(30)
* cf_1096 : varchar(255)
* cf_1098 : varchar(50)
* cf_1100 : date
* cf_1102 : time
* cf_1104 : varchar(20)
* cf_1106 : varchar(100)
* cf_1108 : varchar(50)
* cf_1110 : varchar(100)
* cf_1112 : text
* cf_1114 : varchar(30)
* cf_1116 : decimal(15,5)
* cf_1118 : date
* cf_1120 : varchar(255)
* cf_1122 : time
* cf_1124 : date
* cf_1126 : time
* cf_1128 : varchar(20)
* cf_1130 : date
* cf_1132 : time
* cf_1134 : varchar(20)
* cf_1136 : text
* cf_1138 : varchar(50)
* cf_1140 : varchar(50)
* cf_1142 : date
* cf_1144 : text
v digitidefeedbackdb vtiger_leadsource
* leadsourceid : int
* leadsource : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_leadsource_seq
* id : int
v digitidefeedbackdb vtiger_leadstage
* leadstageid : int
* stage : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_leadstatus
* leadstatusid : int
* leadstatus : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_leadstatus_seq
* id : int
v digitidefeedbackdb vtiger_leadsubdetails
* leadsubscriptionid : int
* website : varchar(255)
* callornot : int
* readornot : int
* empct : int
v digitidefeedbackdb vtiger_lead_view
* lead_viewid : int
* lead_view : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_lead_view_seq
* id : int
v digitidefeedbackdb vtiger_loginhistory
* login_id : int
* user_name : varchar(255)
* user_ip : varchar(25)
* logout_time : timestamp
* login_time : datetime
* status : varchar(25)
v digitidefeedbackdb vtiger_mailer_queue
* id : int
* fromname : varchar(100)
* fromemail : varchar(100)
* mailer : varchar(10)
* content_type : varchar(15)
* subject : varchar(999)
* body : text
* relcrmid : int
* failed : int
* failreason : varchar(255)
v digitidefeedbackdb vtiger_mailer_queueattachments
* id : int
* path : text
* name : varchar(100)
* encoding : varchar(50)
* type : varchar(100)
v digitidefeedbackdb vtiger_mailer_queueinfo
* id : int
* name : varchar(100)
* email : varchar(100)
* type : varchar(7)
v digitidefeedbackdb vtiger_mailmanager_mailattachments
* userid : int
* muid : int
* aname : varchar(100)
* lastsavedtime : int
* attachid : int
* path : varchar(200)
* cid : varchar(100)
v digitidefeedbackdb vtiger_mailmanager_mailrecord
* userid : int
* mfrom : varchar(255)
* mto : varchar(255)
* mcc : varchar(500)
* mbcc : varchar(500)
* mdate : varchar(20)
* msubject : varchar(500)
* mbody : text
* mcharset : varchar(10)
* misbodyhtml : int
* mplainmessage : int
* mhtmlmessage : int
* muniqueid : varchar(500)
* mbodyparsed : int
* muid : int
* lastsavedtime : int
* folder : varchar(250)
* mfolder : varchar(250)
v digitidefeedbackdb vtiger_mailmanager_mailrel
* mailuid : varchar(999)
* crmid : int
* emailid : int
v digitidefeedbackdb vtiger_mailscanner
* scannerid : int
* scannername : varchar(30)
* server : varchar(100)
* protocol : varchar(10)
* username : varchar(255)
* password : varchar(255)
* ssltype : varchar(10)
* sslmethod : varchar(30)
* auth_type : varchar(20)
* auth_expireson : tinyint
* mail_proxy : varchar(50)
* connecturl : varchar(255)
* searchfor : varchar(10)
* markas : varchar(10)
* isvalid : int
* scanfrom : varchar(10)
* time_zone : varchar(10)
v digitidefeedbackdb vtiger_mailscanner_actions
* actionid : int
* scannerid : int
* actiontype : varchar(10)
* module : varchar(30)
* lookup : varchar(30)
* sequence : int
v digitidefeedbackdb vtiger_mailscanner_folders
* folderid : int
* scannerid : int
* foldername : varchar(255)
* lastscan : varchar(30)
* rescan : int
* enabled : int
v digitidefeedbackdb vtiger_mailscanner_ids
* scannerid : int
* messageid : varchar(512)
* crmid : int
* refids : text
v digitidefeedbackdb vtiger_mailscanner_ruleactions
* ruleid : int
* actionid : int
v digitidefeedbackdb vtiger_mailscanner_rules
* ruleid : int
* scannerid : int
* fromaddress : varchar(255)
* toaddress : varchar(255)
* subjectop : varchar(20)
* subject : varchar(255)
* bodyop : varchar(20)
* body : varchar(255)
* matchusing : varchar(5)
* sequence : int
* assigned_to : int
* cc : varchar(255)
* bcc : varchar(255)
v digitidefeedbackdb vtiger_mail_accounts
* account_id : int
* user_id : int
* display_name : varchar(50)
* mail_id : varchar(50)
* account_name : varchar(50)
* mail_protocol : varchar(20)
* mail_username : varchar(50)
* mail_password : text
* mail_servername : varchar(50)
* auth_type : varchar(20)
* auth_expireson : tinyint
* mail_proxy : varchar(50)
* box_refresh : int
* mails_per_page : int
* ssltype : varchar(50)
* sslmeth : varchar(50)
* int_mailer : int
* status : varchar(10)
* set_default : int
* sent_folder : varchar(50)
v digitidefeedbackdb vtiger_manufacturer
* manufacturerid : int
* manufacturer : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_manufacturer_seq
* id : int
v digitidefeedbackdb vtiger_mobile_alerts
* id : int
* handler_path : varchar(500)
* handler_class : varchar(50)
* sequence : int
* deleted : int
v digitidefeedbackdb vtiger_modcomments
* modcommentsid : int
* commentcontent : text
* related_to : int
* parent_comments : int
* customer : int
* userid : int
* reasontoedit : varchar(100)
* is_private : int
* filename : varchar(255)
* related_email_id : int
v digitidefeedbackdb vtiger_modcommentscf
* modcommentsid : int
v digitidefeedbackdb vtiger_modentity_num
* num_id : int
* semodule : varchar(100)
* prefix : varchar(50)
* start_id : varchar(50)
* cur_id : varchar(50)
* active : varchar(2)
v digitidefeedbackdb vtiger_modentity_num_seq
* id : int
v digitidefeedbackdb vtiger_modtracker_basic
* id : int
* crmid : int
* module : varchar(50)
* whodid : int
* changedon : datetime
* status : int
v digitidefeedbackdb vtiger_modtracker_basic_seq
* id : int
v digitidefeedbackdb vtiger_modtracker_detail
* id : int
* fieldname : varchar(100)
* prevalue : text
* postvalue : text
v digitidefeedbackdb vtiger_modtracker_relations
* id : int
* targetmodule : varchar(100)
* targetid : int
* changedon : datetime
v digitidefeedbackdb vtiger_modtracker_tabs
* tabid : int
* visible : int
v digitidefeedbackdb vtiger_module_dashboard_widgets
* id : int
* linkid : int
* userid : int
* filterid : int
* title : varchar(100)
* data : text
* position : varchar(50)
* reportid : int
* dashboardtabid : int
* size : varchar(50)
v digitidefeedbackdb vtiger_notebook_contents
* userid : int
* notebookid : int
* contents : text
v digitidefeedbackdb vtiger_notes
* notesid : int
* note_no : varchar(100)
* title : varchar(50)
* filename : varchar(200)
* notecontent : text
* folderid : int
* filetype : varchar(50)
* filelocationtype : varchar(5)
* filedownloadcount : int
* filestatus : int
* filesize : int
* fileversion : varchar(50)
* tags : varchar(1)
v digitidefeedbackdb vtiger_notescf
* notesid : int
v digitidefeedbackdb vtiger_notificationscheduler
* schedulednotificationid : int
* schedulednotificationname : varchar(200)
* active : int
* notificationsubject : varchar(200)
* notificationbody : text
* label : varchar(50)
* type : varchar(10)
v digitidefeedbackdb vtiger_notificationscheduler_seq
* id : int
v digitidefeedbackdb vtiger_no_of_currency_decimals
* no_of_currency_decimalsid : int
* no_of_currency_decimals : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_no_of_currency_decimals_seq
* id : int
v digitidefeedbackdb vtiger_opportunitystage
* potstageid : int
* stage : varchar(200)
* sortorderid : int
* presence : int
* probability : decimal(3,2)
v digitidefeedbackdb vtiger_opportunity_type
* opptypeid : int
* opportunity_type : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_opportunity_type_seq
* id : int
v digitidefeedbackdb vtiger_organizationdetails
* organization_id : int
* organizationname : varchar(60)
* address : varchar(150)
* city : varchar(100)
* state : varchar(100)
* country : varchar(100)
* code : varchar(30)
* phone : varchar(30)
* fax : varchar(30)
* website : varchar(100)
* logoname : varchar(50)
* vatid : varchar(100)
v digitidefeedbackdb vtiger_organizationdetails_seq
* id : int
v digitidefeedbackdb vtiger_org_share_action2tab
* share_action_id : int
* tabid : int
v digitidefeedbackdb vtiger_org_share_action_mapping
* share_action_id : int
* share_action_name : varchar(200)
v digitidefeedbackdb vtiger_othereventduration
* othereventdurationid : int
* othereventduration : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_othereventduration_seq
* id : int
v digitidefeedbackdb vtiger_parenttab
* parenttabid : int
* parenttab_label : varchar(100)
* sequence : int
* visible : int
v digitidefeedbackdb vtiger_parenttabrel
* parenttabid : int
* tabid : int
* sequence : int
v digitidefeedbackdb vtiger_payment_duration
* payment_duration_id : int
* payment_duration : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_payment_duration_seq
* id : int
v digitidefeedbackdb vtiger_pbxmanager
* pbxmanagerid : int
* direction : varchar(10)
* callstatus : varchar(20)
* starttime : datetime
* endtime : datetime
* totalduration : int
* billduration : int
* recordingurl : varchar(200)
* sourceuuid : varchar(100)
* gateway : varchar(20)
* customer : varchar(100)
* user : varchar(100)
* customernumber : varchar(100)
* customertype : varchar(100)
v digitidefeedbackdb vtiger_pbxmanagercf
* pbxmanagerid : int
v digitidefeedbackdb vtiger_pbxmanager_gateway
* id : int
* gateway : varchar(20)
* parameters : text
v digitidefeedbackdb vtiger_pbxmanager_phonelookup
* crmid : int
* setype : varchar(30)
* fnumber : varchar(100)
* rnumber : varchar(100)
* fieldname : varchar(50)
v digitidefeedbackdb vtiger_picklist
* picklistid : int
* name : varchar(200)
v digitidefeedbackdb vtiger_picklistvalues_seq
* id : int
v digitidefeedbackdb vtiger_picklist_dependency
* id : int
* tabid : int
* sourcefield : varchar(255)
* targetfield : varchar(255)
* sourcevalue : varchar(100)
* targetvalues : text
* criteria : text
v digitidefeedbackdb vtiger_picklist_seq
* id : int
v digitidefeedbackdb vtiger_picklist_transitions
* fieldname : varchar(255)
* module : varchar(100)
* transition_data : varchar(1000)
v digitidefeedbackdb vtiger_pobillads
* pobilladdressid : int
* bill_city : varchar(30)
* bill_code : varchar(30)
* bill_country : varchar(30)
* bill_state : varchar(30)
* bill_street : varchar(250)
* bill_pobox : varchar(30)
v digitidefeedbackdb vtiger_portal
* portalid : int
* portalname : varchar(200)
* portalurl : varchar(255)
* sequence : int
* setdefault : int
* createdtime : datetime
v digitidefeedbackdb vtiger_portalinfo
* id : int
* user_name : varchar(50)
* user_password : varchar(255)
* type : varchar(5)
* cryptmode : varchar(20)
* last_login_time : datetime
* login_time : datetime
* logout_time : datetime
* isactive : int
v digitidefeedbackdb vtiger_poshipads
* poshipaddressid : int
* ship_city : varchar(30)
* ship_code : varchar(30)
* ship_country : varchar(30)
* ship_state : varchar(30)
* ship_street : varchar(250)
* ship_pobox : varchar(30)
v digitidefeedbackdb vtiger_postatus
* postatusid : int
* postatus : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_postatushistory
* historyid : int
* purchaseorderid : int
* vendorname : varchar(100)
* total : decimal(10,0)
* postatus : varchar(200)
* lastmodified : datetime
v digitidefeedbackdb vtiger_postatus_seq
* id : int
v digitidefeedbackdb vtiger_potential
* potentialid : int
* potential_no : varchar(100)
* related_to : int
* potentialname : varchar(120)
* amount : decimal(25,8)
* currency : varchar(20)
* closingdate : date
* typeofrevenue : varchar(50)
* nextstep : varchar(100)
* private : int
* probability : decimal(7,3)
* campaignid : int
* sales_stage : varchar(200)
* potentialtype : varchar(200)
* leadsource : varchar(200)
* productid : int
* productversion : varchar(50)
* quotationref : varchar(50)
* partnercontact : varchar(50)
* remarks : varchar(50)
* runtimefee : int
* followupdate : date
* evaluationstatus : varchar(50)
* description : text
* forecastcategory : int
* outcomeanalysis : int
* forecast_amount : decimal(25,8)
* isconvertedfromlead : varchar(3)
* contact_id : int
* tags : varchar(1)
* converted : int
v digitidefeedbackdb vtiger_potentialscf
* potentialid : int
v digitidefeedbackdb vtiger_potstagehistory
* historyid : int
* potentialid : int
* amount : decimal(10,0)
* stage : varchar(100)
* probability : decimal(7,3)
* expectedrevenue : decimal(10,0)
* closedate : date
* lastmodified : datetime
v digitidefeedbackdb vtiger_pricebook
* pricebookid : int
* pricebook_no : varchar(100)
* bookname : varchar(100)
* active : int
* currency_id : int
* tags : varchar(1)
v digitidefeedbackdb vtiger_pricebookcf
* pricebookid : int
v digitidefeedbackdb vtiger_pricebookproductrel
* pricebookid : int
* productid : int
* listprice : decimal(27,8)
* usedcurrency : int
v digitidefeedbackdb vtiger_priority
* priorityid : int
* priority : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_productcategory
* productcategoryid : int
* productcategory : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_productcategory_seq
* id : int
v digitidefeedbackdb vtiger_productcf
* productid : int
v digitidefeedbackdb vtiger_productcurrencyrel
* productid : int
* currencyid : int
* converted_price : decimal(28,8)
* actual_price : decimal(28,8)
v digitidefeedbackdb vtiger_products
* productid : int
* product_no : varchar(100)
* productname : varchar(255)
* productcode : varchar(40)
* productcategory : varchar(200)
* manufacturer : varchar(200)
* qty_per_unit : decimal(11,2)
* unit_price : decimal(25,8)
* weight : decimal(11,3)
* pack_size : int
* sales_start_date : date
* sales_end_date : date
* start_date : date
* expiry_date : date
* cost_factor : int
* commissionrate : decimal(7,3)
* commissionmethod : varchar(50)
* discontinued : int
* usageunit : varchar(200)
* reorderlevel : int
* website : varchar(100)
* taxclass : varchar(200)
* mfr_part_no : varchar(200)
* vendor_part_no : varchar(200)
* serialno : varchar(200)
* qtyinstock : decimal(25,3)
* productsheet : varchar(200)
* qtyindemand : int
* glacct : varchar(200)
* vendor_id : int
* imagename : text
* currency_id : int
* is_subproducts_viewable : int
* purchase_cost : decimal(27,8)
* tags : varchar(1)
v digitidefeedbackdb vtiger_producttaxrel
* productid : int
* taxid : int
* taxpercentage : decimal(7,3)
* regions : text
v digitidefeedbackdb vtiger_profile
* profileid : int
* profilename : varchar(50)
* description : text
v digitidefeedbackdb vtiger_profile2field
* profileid : int
* tabid : int
* fieldid : int
* visible : int
* readonly : int
v digitidefeedbackdb vtiger_profile2globalpermissions
* profileid : int
* globalactionid : int
* globalactionpermission : int
v digitidefeedbackdb vtiger_profile2standardpermissions
* profileid : int
* tabid : int
* operation : int
* permissions : int
v digitidefeedbackdb vtiger_profile2tab
* profileid : int
* tabid : int
* permissions : int
v digitidefeedbackdb vtiger_profile2utility
* profileid : int
* tabid : int
* activityid : int
* permission : int
v digitidefeedbackdb vtiger_profile_seq
* id : int
v digitidefeedbackdb vtiger_progress
* progressid : int
* progress : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_progress_seq
* id : int
v digitidefeedbackdb vtiger_project
* projectid : int
* projectname : varchar(255)
* project_no : varchar(100)
* startdate : date
* targetenddate : date
* actualenddate : date
* targetbudget : varchar(255)
* projecturl : varchar(255)
* projectstatus : varchar(100)
* projectpriority : varchar(100)
* projecttype : varchar(100)
* progress : varchar(100)
* linktoaccountscontacts : varchar(100)
* tags : varchar(1)
* isconvertedfrompotential : int
* potentialid : varchar(100)
v digitidefeedbackdb vtiger_projectcf
* projectid : int
v digitidefeedbackdb vtiger_projectmilestone
* projectmilestoneid : int
* projectmilestonename : varchar(255)
* projectmilestone_no : varchar(100)
* projectmilestonedate : varchar(255)
* projectid : varchar(100)
* projectmilestonetype : varchar(100)
* tags : varchar(1)
v digitidefeedbackdb vtiger_projectmilestonecf
* projectmilestoneid : int
v digitidefeedbackdb vtiger_projectmilestonetype
* projectmilestonetypeid : int
* projectmilestonetype : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_projectmilestonetype_seq
* id : int
v digitidefeedbackdb vtiger_projectpriority
* projectpriorityid : int
* projectpriority : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_projectpriority_seq
* id : int
v digitidefeedbackdb vtiger_projectstatus
* projectstatusid : int
* projectstatus : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_projectstatus_seq
* id : int
v digitidefeedbackdb vtiger_projecttask
* projecttaskid : int
* projecttaskname : varchar(255)
* projecttask_no : varchar(100)
* projecttasktype : varchar(100)
* projecttaskpriority : varchar(100)
* projecttaskprogress : varchar(100)
* projecttaskhours : varchar(255)
* startdate : date
* enddate : date
* projectid : varchar(100)
* projecttasknumber : int
* tags : varchar(1)
* projecttaskstatus : varchar(100)
v digitidefeedbackdb vtiger_projecttaskcf
* projecttaskid : int
v digitidefeedbackdb vtiger_projecttaskpriority
* projecttaskpriorityid : int
* projecttaskpriority : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_projecttaskpriority_seq
* id : int
v digitidefeedbackdb vtiger_projecttaskprogress
* projecttaskprogressid : int
* projecttaskprogress : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_projecttaskprogress_seq
* id : int
v digitidefeedbackdb vtiger_projecttaskstatus
* projecttaskstatusid : int
* projecttaskstatus : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_projecttaskstatus_seq
* id : int
v digitidefeedbackdb vtiger_projecttasktype
* projecttasktypeid : int
* projecttasktype : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_projecttasktype_seq
* id : int
v digitidefeedbackdb vtiger_projecttask_status_color
* status : varchar(255)
* defaultcolor : varchar(50)
* color : varchar(50)
v digitidefeedbackdb vtiger_projecttype
* projecttypeid : int
* projecttype : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_projecttype_seq
* id : int
v digitidefeedbackdb vtiger_purchaseorder
* purchaseorderid : int
* subject : varchar(100)
* quoteid : int
* vendorid : int
* requisition_no : varchar(100)
* purchaseorder_no : varchar(100)
* tracking_no : varchar(100)
* contactid : int
* duedate : date
* carrier : varchar(200)
* type : varchar(100)
* adjustment : decimal(25,8)
* salescommission : decimal(25,3)
* exciseduty : decimal(25,3)
* total : decimal(25,8)
* subtotal : decimal(25,8)
* taxtype : varchar(25)
* discount_percent : decimal(25,3)
* discount_amount : decimal(25,8)
* s_h_amount : decimal(25,8)
* terms_conditions : text
* postatus : varchar(200)
* currency_id : int
* conversion_rate : decimal(10,3)
* compound_taxes_info : text
* pre_tax_total : decimal(25,8)
* paid : decimal(25,8)
* balance : decimal(25,8)
* s_h_percent : decimal(25,3)
* tags : varchar(1)
* region_id : int
v digitidefeedbackdb vtiger_purchaseordercf
* purchaseorderid : int
v digitidefeedbackdb vtiger_query
* queryid : int
v digitidefeedbackdb vtiger_querycf
* queryid : int
v digitidefeedbackdb vtiger_quotes
* quoteid : int
* subject : varchar(100)
* potentialid : int
* quotestage : varchar(200)
* validtill : date
* contactid : int
* quote_no : varchar(100)
* subtotal : decimal(25,8)
* carrier : varchar(200)
* shipping : varchar(100)
* inventorymanager : int
* type : varchar(100)
* adjustment : decimal(25,8)
* total : decimal(25,8)
* taxtype : varchar(25)
* discount_percent : decimal(25,3)
* discount_amount : decimal(25,8)
* s_h_amount : decimal(25,8)
* accountid : int
* terms_conditions : text
* currency_id : int
* conversion_rate : decimal(10,3)
* compound_taxes_info : text
* pre_tax_total : decimal(25,8)
* s_h_percent : decimal(25,3)
* tags : varchar(1)
* region_id : int
v digitidefeedbackdb vtiger_quotesbillads
* quotebilladdressid : int
* bill_city : varchar(30)
* bill_code : varchar(30)
* bill_country : varchar(30)
* bill_state : varchar(30)
* bill_street : varchar(250)
* bill_pobox : varchar(30)
v digitidefeedbackdb vtiger_quotescf
* quoteid : int
v digitidefeedbackdb vtiger_quotesshipads
* quoteshipaddressid : int
* ship_city : varchar(30)
* ship_code : varchar(30)
* ship_country : varchar(30)
* ship_state : varchar(30)
* ship_street : varchar(250)
* ship_pobox : varchar(30)
v digitidefeedbackdb vtiger_quotestage
* quotestageid : int
* quotestage : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_quotestagehistory
* historyid : int
* quoteid : int
* accountname : varchar(100)
* total : decimal(10,0)
* quotestage : varchar(200)
* lastmodified : datetime
v digitidefeedbackdb vtiger_quotestage_seq
* id : int
v digitidefeedbackdb vtiger_rating
* rating_id : int
* rating : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_rating_seq
* id : int
v digitidefeedbackdb vtiger_recurringevents
* recurringid : int
* activityid : int
* recurringdate : date
* recurringtype : varchar(30)
* recurringfreq : int
* recurringinfo : varchar(50)
* recurringenddate : date
v digitidefeedbackdb vtiger_recurringtype
* recurringeventid : int
* recurringtype : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_recurringtype_seq
* id : int
v digitidefeedbackdb vtiger_recurring_frequency
* recurring_frequency_id : int
* recurring_frequency : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_recurring_frequency_seq
* id : int
v digitidefeedbackdb vtiger_relatedlists
* relation_id : int
* tabid : int
* related_tabid : int
* name : varchar(100)
* sequence : int
* label : varchar(100)
* presence : int
* actions : varchar(50)
* relationfieldid : int
* source : varchar(25)
* relationtype : varchar(10)
v digitidefeedbackdb vtiger_relatedlists_rb
* entityid : int
* action : varchar(50)
* rel_table : varchar(200)
* rel_column : varchar(200)
* ref_column : varchar(200)
* related_crm_ids : text
v digitidefeedbackdb vtiger_relatedlists_seq
* id : int
v digitidefeedbackdb vtiger_relcriteria
* queryid : int
* columnindex : int
* columnname : varchar(250)
* comparator : varchar(20)
* value : varchar(512)
* groupid : int
* column_condition : varchar(256)
v digitidefeedbackdb vtiger_relcriteria_grouping
* groupid : int
* queryid : int
* group_condition : varchar(256)
* condition_expression : text
v digitidefeedbackdb vtiger_reminder_interval
* reminder_intervalid : int
* reminder_interval : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_reminder_interval_seq
* id : int
v digitidefeedbackdb vtiger_report
* reportid : int
* folderid : int
* reportname : varchar(100)
* description : varchar(250)
* reporttype : varchar(50)
* queryid : int
* state : varchar(50)
* customizable : int
* category : int
* owner : int
* sharingtype : varchar(200)
v digitidefeedbackdb vtiger_reportdatefilter
* datefilterid : int
* datecolumnname : varchar(250)
* datefilter : varchar(250)
* startdate : date
* enddate : date
v digitidefeedbackdb vtiger_reportfilters
* filterid : int
* name : varchar(200)
v digitidefeedbackdb vtiger_reportfolder
* folderid : int
* foldername : varchar(100)
* description : varchar(250)
* state : varchar(50)
v digitidefeedbackdb vtiger_reportgroupbycolumn
* reportid : int
* sortid : int
* sortcolname : varchar(250)
* dategroupbycriteria : varchar(250)
v digitidefeedbackdb vtiger_reportmodules
* reportmodulesid : int
* primarymodule : varchar(100)
* secondarymodules : varchar(250)
v digitidefeedbackdb vtiger_reportsharing
* reportid : int
* shareid : int
* setype : varchar(200)
v digitidefeedbackdb vtiger_reportsortcol
* sortcolid : int
* reportid : int
* columnname : varchar(250)
* sortorder : varchar(250)
v digitidefeedbackdb vtiger_reportsummary
* reportsummaryid : int
* summarytype : int
* columnname : varchar(250)
v digitidefeedbackdb vtiger_reporttype
* reportid : int
* data : text
v digitidefeedbackdb vtiger_report_sharegroups
* reportid : int
* groupid : int
v digitidefeedbackdb vtiger_report_sharerole
* reportid : int
* roleid : varchar(255)
v digitidefeedbackdb vtiger_report_sharers
* reportid : int
* rsid : varchar(255)
v digitidefeedbackdb vtiger_report_shareusers
* reportid : int
* userid : int
v digitidefeedbackdb vtiger_role
* roleid : varchar(255)
* rolename : varchar(200)
* parentrole : varchar(255)
* depth : int
* allowassignedrecordsto : int
v digitidefeedbackdb vtiger_role2picklist
* roleid : varchar(255)
* picklistvalueid : int
* picklistid : int
* sortid : int
v digitidefeedbackdb vtiger_role2profile
* roleid : varchar(255)
* profileid : int
v digitidefeedbackdb vtiger_role_seq
* id : int
v digitidefeedbackdb vtiger_rollupcomments_settings
* rollupid : int
* userid : int
* tabid : int
* rollup_status : int
v digitidefeedbackdb vtiger_rowheight
* rowheightid : int
* rowheight : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_rowheight_seq
* id : int
v digitidefeedbackdb vtiger_rss
* rssid : int
* rssurl : varchar(200)
* rsstitle : varchar(200)
* rsstype : int
* starred : int
v digitidefeedbackdb vtiger_salesmanactivityrel
* smid : int
* activityid : int
v digitidefeedbackdb vtiger_salesmanattachmentsrel
* smid : int
* attachmentsid : int
v digitidefeedbackdb vtiger_salesmanticketrel
* smid : int
* id : int
v digitidefeedbackdb vtiger_salesorder
* salesorderid : int
* subject : varchar(100)
* potentialid : int
* customerno : varchar(100)
* salesorder_no : varchar(100)
* quoteid : int
* vendorterms : varchar(100)
* contactid : int
* vendorid : int
* duedate : date
* carrier : varchar(200)
* pending : varchar(200)
* type : varchar(100)
* adjustment : decimal(25,8)
* salescommission : decimal(25,3)
* exciseduty : decimal(25,3)
* total : decimal(25,8)
* subtotal : decimal(25,8)
* taxtype : varchar(25)
* discount_percent : decimal(25,3)
* discount_amount : decimal(25,8)
* s_h_amount : decimal(25,8)
* accountid : int
* terms_conditions : text
* purchaseorder : varchar(200)
* sostatus : varchar(200)
* currency_id : int
* conversion_rate : decimal(10,3)
* enable_recurring : int
* compound_taxes_info : text
* pre_tax_total : decimal(25,8)
* s_h_percent : decimal(25,3)
* tags : varchar(1)
* region_id : int
v digitidefeedbackdb vtiger_salesordercf
* salesorderid : int
v digitidefeedbackdb vtiger_sales_stage
* sales_stage_id : int
* sales_stage : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_sales_stage_seq
* id : int
v digitidefeedbackdb vtiger_salutationtype
* salutationid : int
* salutationtype : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_salutationtype_seq
* id : int
v digitidefeedbackdb vtiger_scheduled_reports
* reportid : int
* recipients : text
* schedule : text
* format : varchar(10)
* next_trigger_time : timestamp
v digitidefeedbackdb vtiger_schedulereports
* reportid : int
* scheduleid : int
* recipients : text
* schdate : varchar(20)
* schtime : time
* schdayoftheweek : varchar(100)
* schdayofthemonth : varchar(100)
* schannualdates : varchar(500)
* specificemails : varchar(500)
* next_trigger_time : timestamp
* fileformat : varchar(10)
v digitidefeedbackdb vtiger_seactivityrel
* crmid : int
* activityid : int
v digitidefeedbackdb vtiger_seactivityrel_seq
* id : int
v digitidefeedbackdb vtiger_seattachmentsrel
* crmid : int
* attachmentsid : int
v digitidefeedbackdb vtiger_selectcolumn
* queryid : int
* columnindex : int
* columnname : varchar(250)
v digitidefeedbackdb vtiger_selectquery
* queryid : int
* startindex : int
* numofobjects : int
v digitidefeedbackdb vtiger_selectquery_seq
* id : int
v digitidefeedbackdb vtiger_senotesrel
* crmid : int
* notesid : int
v digitidefeedbackdb vtiger_seproductsrel
* crmid : int
* productid : int
* setype : varchar(30)
* quantity : int
v digitidefeedbackdb vtiger_service
* serviceid : int
* service_no : varchar(100)
* servicename : varchar(255)
* servicecategory : varchar(200)
* qty_per_unit : decimal(11,2)
* unit_price : decimal(25,8)
* sales_start_date : date
* sales_end_date : date
* start_date : date
* expiry_date : date
* discontinued : int
* service_usageunit : varchar(200)
* website : varchar(100)
* taxclass : varchar(200)
* currency_id : int
* commissionrate : decimal(7,3)
* tags : varchar(1)
* purchase_cost : decimal(27,8)
v digitidefeedbackdb vtiger_servicecategory
* servicecategoryid : int
* servicecategory : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_servicecategory_seq
* id : int
v digitidefeedbackdb vtiger_servicecf
* serviceid : int
v digitidefeedbackdb vtiger_servicecontracts
* servicecontractsid : int
* start_date : date
* end_date : date
* tracking_unit : varchar(100)
* total_units : decimal(5,2)
* used_units : decimal(5,2)
* subject : varchar(100)
* due_date : date
* planned_duration : varchar(256)
* actual_duration : varchar(256)
* contract_status : varchar(200)
* priority : varchar(200)
* contract_type : varchar(200)
* progress : decimal(5,2)
* contract_no : varchar(100)
* tags : varchar(1)
v digitidefeedbackdb vtiger_servicecontractscf
* servicecontractsid : int
v digitidefeedbackdb vtiger_service_usageunit
* service_usageunitid : int
* service_usageunit : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_service_usageunit_seq
* id : int
v digitidefeedbackdb vtiger_seticketsrel
* crmid : int
* ticketid : int
v digitidefeedbackdb vtiger_settings_blocks
* blockid : int
* label : varchar(250)
* sequence : int
v digitidefeedbackdb vtiger_settings_blocks_seq
* id : int
v digitidefeedbackdb vtiger_settings_field
* fieldid : int
* blockid : int
* name : varchar(250)
* iconpath : varchar(300)
* description : text
* linkto : text
* sequence : int
* active : int
* pinned : int
v digitidefeedbackdb vtiger_settings_field_seq
* id : int
v digitidefeedbackdb vtiger_sharedcalendar
* userid : int
* sharedid : int
v digitidefeedbackdb vtiger_shareduserinfo
* userid : int
* shareduserid : int
* color : varchar(50)
* visible : int
v digitidefeedbackdb vtiger_shippingtaxinfo
* taxid : int
* taxname : varchar(50)
* taxlabel : varchar(50)
* percentage : decimal(7,3)
* deleted : int
* method : varchar(10)
* type : varchar(10)
* compoundon : varchar(400)
* regions : text
v digitidefeedbackdb vtiger_shippingtaxinfo_seq
* id : int
v digitidefeedbackdb vtiger_shorturls
* id : int
* uid : varchar(50)
* handler_path : varchar(400)
* handler_class : varchar(100)
* handler_function : varchar(100)
* handler_data : text
* onetime : int
v digitidefeedbackdb vtiger_smslog
* smslogid : int
* customermobile : varchar(255)
v digitidefeedbackdb vtiger_smslogcf
* smslogid : int
v digitidefeedbackdb vtiger_smsnotifier
* smsnotifierid : int
* message : text
* status : varchar(100)
v digitidefeedbackdb vtiger_smsnotifiercf
* smsnotifierid : int
v digitidefeedbackdb vtiger_smsnotifier_servers
* id : int
* password : varchar(255)
* isactive : int
* providertype : varchar(50)
* username : varchar(255)
* parameters : text
v digitidefeedbackdb vtiger_smsnotifier_status
* smsnotifierid : int
* tonumber : varchar(20)
* status : varchar(10)
* smsmessageid : varchar(50)
* needlookup : int
* statusid : int
* statusmessage : varchar(100)
v digitidefeedbackdb vtiger_soapservice
* id : int
* type : varchar(25)
* sessionid : varchar(100)
v digitidefeedbackdb vtiger_sobillads
* sobilladdressid : int
* bill_city : varchar(30)
* bill_code : varchar(30)
* bill_country : varchar(30)
* bill_state : varchar(30)
* bill_street : varchar(250)
* bill_pobox : varchar(30)
v digitidefeedbackdb vtiger_soshipads
* soshipaddressid : int
* ship_city : varchar(30)
* ship_code : varchar(30)
* ship_country : varchar(30)
* ship_state : varchar(30)
* ship_street : varchar(250)
* ship_pobox : varchar(30)
v digitidefeedbackdb vtiger_sostatus
* sostatusid : int
* sostatus : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_sostatushistory
* historyid : int
* salesorderid : int
* accountname : varchar(100)
* total : decimal(10,0)
* sostatus : varchar(200)
* lastmodified : datetime
v digitidefeedbackdb vtiger_sostatus_seq
* id : int
v digitidefeedbackdb vtiger_sqltimelog
* id : int
* type : varchar(10)
* data : text
* started : decimal(20,6)
* ended : decimal(20,6)
* loggedon : datetime
v digitidefeedbackdb vtiger_start_hour
* start_hourid : int
* start_hour : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_start_hour_seq
* id : int
v digitidefeedbackdb vtiger_state_master
* stId : int
* country : varchar(50)
* state : varchar(50)
v digitidefeedbackdb vtiger_status
* statusid : int
* status : varchar(200)
* presence : int
* picklist_valueid : int
v digitidefeedbackdb vtiger_status_seq
* id : int
v digitidefeedbackdb vtiger_systems
* id : int
* server : varchar(100)
* server_port : int
* server_username : varchar(100)
* server_password : text
* server_type : varchar(20)
* smtp_auth : varchar(5)
* smtp_auth_type : varchar(20)
* smtp_auth_expireson : tinyint
* server_path : varchar(256)
* from_email_field : varchar(50)
v digitidefeedbackdb vtiger_tab
* tabid : int
* name : varchar(25)
* presence : int
* tabsequence : int
* tablabel : varchar(100)
* modifiedby : int
* modifiedtime : int
* customized : int
* ownedby : int
* isentitytype : int
* trial : int
* version : varchar(10)
* parent : varchar(30)
* source : varchar(255)
* issyncable : tinyint(1)
* allowduplicates : tinyint(1)
* sync_action_for_duplicates : int
v digitidefeedbackdb vtiger_tab_info
* tabid : int
* prefname : varchar(256)
* prefvalue : varchar(256)
v digitidefeedbackdb vtiger_taskpriority
* taskpriorityid : int
* taskpriority : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_taskpriority_seq
* id : int
v digitidefeedbackdb vtiger_taskstatus
* taskstatusid : int
* taskstatus : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_taskstatus_seq
* id : int
v digitidefeedbackdb vtiger_taxclass
* taxclassid : int
* taxclass : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_taxclass_seq
* id : int
v digitidefeedbackdb vtiger_taxregions
* regionid : int
* name : varchar(100)
v digitidefeedbackdb vtiger_ticketcategories
* ticketcategories_id : int
* ticketcategories : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_ticketcategories_seq
* id : int
v digitidefeedbackdb vtiger_ticketcf
* ticketid : int
* from_portal : varchar(3)
* cf_918 : varchar(255)
* cf_920 : varchar(255)
* cf_922 : varchar(255)
* cf_924 : varchar(255)
* cf_926 : varchar(255)
* cf_928 : varchar(100)
* cf_930 : varchar(100)
* cf_932 : varchar(30)
* cf_934 : varchar(30)
* cf_936 : varchar(255)
* cf_938 : date
* cf_940 : text
* cf_942 : varchar(100)
* cf_944 : varchar(100)
* cf_946 : varchar(255)
* cf_948 : varchar(50)
* cf_950 : date
* cf_952 : time
* cf_954 : varchar(100)
* cf_956 : varchar(30)
* cf_958 : varchar(100)
* cf_960 : varchar(100)
* cf_962 : varchar(100)
* cf_964 : varchar(100)
* cf_966 : varchar(100)
* cf_968 : varchar(100)
* cf_970 : varchar(100)
* cf_972 : varchar(100)
* cf_974 : varchar(100)
* cf_976 : text
* cf_978 : varchar(255)
* cf_980 : varchar(100)
* cf_982 : varchar(100)
* cf_984 : date
* cf_986 : varchar(50)
* cf_988 : time
* cf_990 : varchar(100)
* cf_992 : date
* cf_994 : varchar(50)
* cf_996 : time
* cf_998 : date
* cf_1000 : varchar(50)
* cf_1002 : text
* cf_1004 : varchar(100)
* cf_1006 : varchar(50)
* cf_1008 : date
* cf_1010 : text
* cf_1012 : date
* cf_1014 : time
* cf_1016 : text
* cf_1018 : varchar(255)
* cf_1020 : date
* cf_1022 : time
* cf_1024 : text
* cf_1026 : varchar(100)
* cf_1028 : varchar(100)
v digitidefeedbackdb vtiger_ticketcomments
* commentid : int
* ticketid : int
* comments : text
* ownerid : int
* ownertype : varchar(10)
* createdtime : datetime
v digitidefeedbackdb vtiger_ticketpriorities
* ticketpriorities_id : int
* ticketpriorities : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_ticketpriorities_seq
* id : int
v digitidefeedbackdb vtiger_ticketseverities
* ticketseverities_id : int
* ticketseverities : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_ticketseverities_seq
* id : int
v digitidefeedbackdb vtiger_ticketstatus
* ticketstatus_id : int
* ticketstatus : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_ticketstatus_seq
* id : int
v digitidefeedbackdb vtiger_ticket_title
* ticket_titleid : int
* ticket_title : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_ticket_title_seq
* id : int
v digitidefeedbackdb vtiger_time_zone
* time_zoneid : int
* time_zone : varchar(200)
* sortorderid : int
* presence : int
v digitidefeedbackdb vtiger_time_zone_seq
* id : int
v digitidefeedbackdb vtiger_tmp_read_group_rel_sharing_per
* userid : int
* tabid : int
* relatedtabid : int
* sharedgroupid : int
v digitidefeedbackdb vtiger_tmp_read_group_sharing_per
* userid : int
* tabid : int
* sharedgroupid : int
v digitidefeedbackdb vtiger_tmp_read_user_rel_sharing_per
* userid : int
* tabid : int
* relatedtabid : int
* shareduserid : int
v digitidefeedbackdb vtiger_tmp_read_user_sharing_per
* userid : int
* tabid : int
* shareduserid : int
v digitidefeedbackdb vtiger_tmp_write_group_rel_sharing_per
* userid : int
* tabid : int
* relatedtabid : int
* sharedgroupid : int
v digitidefeedbackdb vtiger_tmp_write_group_sharing_per
* userid : int
* tabid : int
* sharedgroupid : int
v digitidefeedbackdb vtiger_tmp_write_user_rel_sharing_per
* userid : int
* tabid : int
* relatedtabid : int
* shareduserid : int
v digitidefeedbackdb vtiger_tmp_write_user_sharing_per
* userid : int
* tabid : int
* shareduserid : int
v digitidefeedbackdb vtiger_tracker
* id : int
* user_id : varchar(36)
* module_name : varchar(25)
* item_id : varchar(36)
* item_summary : varchar(255)
v digitidefeedbackdb vtiger_tracking_unit
* tracking_unitid : int
* tracking_unit : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_tracking_unit_seq
* id : int
v digitidefeedbackdb vtiger_troubletickets
* ticketid : int
* ticket_no : varchar(100)
* groupname : varchar(100)
* parent_id : varchar(100)
* product_id : varchar(100)
* priority : varchar(200)
* severity : varchar(200)
* status : varchar(200)
* category : varchar(200)
* title : varchar(255)
* solution : text
* update_log : text
* version_id : int
* hours : decimal(25,8)
* days : decimal(25,8)
* contact_id : int
* tags : varchar(1)
v digitidefeedbackdb vtiger_usageunit
* usageunitid : int
* usageunit : varchar(200)
* presence : int
* picklist_valueid : int
* sortorderid : int
* color : varchar(10)
v digitidefeedbackdb vtiger_usageunit_seq
* id : int
v digitidefeedbackdb vtiger_user2mergefields
* userid : int
* tabid : int
* fieldid : int
* visible : int
v digitidefeedbackdb vtiger_user2role
* userid : int
* roleid : varchar(255)
v digitidefeedbackdb vtiger_users
* id : int
* user_name : varchar(255)
* user_password : varchar(200)
* cal_color : varchar(25)
* first_name : varchar(30)
* last_name : varchar(30)
* reports_to_id : varchar(36)
* is_admin : varchar(3)
* currency_id : int
* description : text
* date_entered : timestamp
* date_modified : datetime
* modified_user_id : varchar(36)
* title : varchar(50)
* department : varchar(50)
* phone_home : varchar(50)
* phone_mobile : varchar(50)
* phone_work : varchar(50)
* phone_other : varchar(50)
* phone_fax : varchar(50)
* email1 : varchar(100)
* email2 : varchar(100)
* secondaryemail : varchar(100)
* status : varchar(25)
* signature : text
* address_street : varchar(150)
* address_city : varchar(100)
* address_state : varchar(100)
* address_country : varchar(25)
* address_postalcode : varchar(9)
* user_preferences : text
* tz : varchar(30)
* holidays : varchar(60)
* namedays : varchar(60)
* workdays : varchar(30)
* weekstart : int
* date_format : varchar(200)
* hour_format : varchar(30)
* start_hour : varchar(30)
* end_hour : varchar(30)
* is_owner : varchar(100)
* activity_view : varchar(200)
* lead_view : varchar(200)
* imagename : varchar(250)
* deleted : int
* confirm_password : varchar(300)
* internal_mailer : varchar(3)
* reminder_interval : varchar(100)
* reminder_next_time : varchar(100)
* crypt_type : varchar(20)
* accesskey : varchar(36)
* theme : varchar(100)
* language : varchar(36)
* time_zone : varchar(200)
* currency_grouping_pattern : varchar(100)
* currency_decimal_separator : varchar(2)
* currency_grouping_separator : varchar(2)
* currency_symbol_placement : varchar(20)
* userlabel : varchar(255)
* defaultlandingpage : varchar(200)
* phone_crm_extension : varchar(100)
* no_of_currency_decimals : varchar(2)
* truncate_trailing_zeros : varchar(3)
* dayoftheweek : varchar(100)
* callduration : varchar(100)
* othereventduration : varchar(100)
* calendarsharedtype : varchar(100)
* default_record_view : varchar(10)
* leftpanelhide : varchar(3)
* rowheight : varchar(10)
* defaulteventstatus : varchar(50)
* defaultactivitytype : varchar(50)
* hidecompletedevents : int
* defaultcalendarview : varchar(100)
* createdon : datetime
* deactivatedon : datetime
v digitidefeedbackdb vtiger_users2group
* groupid : int
* userid : int
v digitidefeedbackdb vtiger_users_last_import
* id : int
* assigned_user_id : varchar(36)
* bean_type : varchar(36)
* bean_id : varchar(36)
* deleted : int
v digitidefeedbackdb vtiger_users_seq
* id : int
v digitidefeedbackdb vtiger_user_audit_log
* log_id : int
* user_id : int
* user_name : varchar(255)
* user_full_name : varchar(255)
* action : varchar(32)
* performed_by_id : int
* performed_by_name : varchar(255)
* performed_by_full_name : varchar(255)
* ip_address : varchar(64)
* action_time : datetime
* remarks : varchar(500)
v digitidefeedbackdb vtiger_user_module_preferences
* userid : int
* tabid : int
* default_cvid : int
v digitidefeedbackdb vtiger_vendor
* vendorid : int
* vendor_no : varchar(100)
* vendorname : varchar(100)
* phone : varchar(100)
* email : varchar(100)
* website : varchar(100)
* glacct : varchar(200)
* category : varchar(50)
* street : text
* city : varchar(30)
* state : varchar(30)
* pobox : varchar(30)
* postalcode : varchar(100)
* country : varchar(100)
* description : text
* tags : varchar(1)
v digitidefeedbackdb vtiger_vendorcf
* vendorid : int
v digitidefeedbackdb vtiger_vendorcontactrel
* vendorid : int
* contactid : int
v digitidefeedbackdb vtiger_version
* id : int
* old_version : varchar(30)
* current_version : varchar(30)
v digitidefeedbackdb vtiger_version_seq
* id : int
v digitidefeedbackdb vtiger_visibility
* visibilityid : int
* visibility : varchar(200)
* sortorderid : int
* presence : int
* color : varchar(10)
v digitidefeedbackdb vtiger_visibility_seq
* id : int
v digitidefeedbackdb vtiger_webforms
* id : int
* name : varchar(100)
* publicid : varchar(100)
* enabled : int
* targetmodule : varchar(50)
* description : text
* ownerid : int
* returnurl : varchar(250)
* captcha : int
* roundrobin : int
* roundrobin_userid : varchar(256)
* roundrobin_logic : int
v digitidefeedbackdb vtiger_webforms_field
* id : int
* webformid : int
* fieldid : int
* fieldname : varchar(50)
* neutralizedfield : varchar(50)
* defaultvalue : text
* required : int
* sequence : int
* hidden : int
v digitidefeedbackdb vtiger_webform_file_fields
* id : int
* webformid : int
* fieldname : varchar(100)
* fieldlabel : varchar(100)
* required : int
v digitidefeedbackdb vtiger_wordtemplates
* templateid : int
* filename : varchar(100)
* module : varchar(30)
* date_entered : timestamp
* parent_type : varchar(50)
* data : longblob
* description : text
* filesize : varchar(50)
* filetype : varchar(20)
* deleted : int
v digitidefeedbackdb vtiger_wsapp
* appid : int
* name : varchar(200)
* appkey : varchar(255)
* type : varchar(100)
v digitidefeedbackdb vtiger_wsapp_handlerdetails
* type : varchar(200)
* handlerclass : varchar(100)
* handlerpath : varchar(300)
v digitidefeedbackdb vtiger_wsapp_logs_basic
* id : int
* extensiontabid : int
* module : varchar(50)
* sync_datetime : datetime
* app_create_count : int
* app_update_count : int
* app_delete_count : int
* app_skip_count : int
* vt_create_count : int
* vt_update_count : int
* vt_delete_count : int
* vt_skip_count : int
* userid : int
v digitidefeedbackdb vtiger_wsapp_logs_details
* id : int
* app_create_ids : mediumtext
* app_update_ids : mediumtext
* app_delete_ids : mediumtext
* app_skip_info : mediumtext
* vt_create_ids : mediumtext
* vt_update_ids : mediumtext
* vt_delete_ids : mediumtext
* vt_skip_info : mediumtext
v digitidefeedbackdb vtiger_wsapp_queuerecords
* syncserverid : int
* details : varchar(300)
* flag : varchar(100)
* appid : int
v digitidefeedbackdb vtiger_wsapp_recordmapping
* id : int
* serverid : varchar(10)
* clientid : varchar(255)
* clientmodifiedtime : datetime
* appid : int
* servermodifiedtime : datetime
* serverappid : int
v digitidefeedbackdb vtiger_wsapp_sync_state
* id : int
* name : varchar(200)
* stateencodedvalues : varchar(300)
* userid : int
v digitidefeedbackdb vtiger_ws_entity
* id : int
* name : varchar(25)
* handler_path : varchar(255)
* handler_class : varchar(64)
* ismodule : int
v digitidefeedbackdb vtiger_ws_entity_fieldtype
* fieldtypeid : int
* table_name : varchar(50)
* field_name : varchar(50)
* fieldtype : varchar(200)
v digitidefeedbackdb vtiger_ws_entity_fieldtype_seq
* id : int
v digitidefeedbackdb vtiger_ws_entity_name
* entity_id : int
* name_fields : varchar(50)
* index_field : varchar(50)
* table_name : varchar(50)
v digitidefeedbackdb vtiger_ws_entity_referencetype
* fieldtypeid : int
* type : varchar(25)
v digitidefeedbackdb vtiger_ws_entity_seq
* id : int
v digitidefeedbackdb vtiger_ws_entity_tables
* webservice_entity_id : int
* table_name : varchar(50)
v digitidefeedbackdb vtiger_ws_fieldinfo
* id : varchar(64)
* property_name : varchar(32)
* property_value : varchar(64)
v digitidefeedbackdb vtiger_ws_fieldtype
* fieldtypeid : int
* uitype : varchar(30)
* fieldtype : varchar(200)
v digitidefeedbackdb vtiger_ws_operation
* operationid : int
* name : varchar(128)
* handler_path : varchar(255)
* handler_method : varchar(64)
* type : varchar(8)
* prelogin : int
v digitidefeedbackdb vtiger_ws_operation_parameters
* operationid : int
* name : varchar(128)
* type : varchar(64)
* sequence : int
v digitidefeedbackdb vtiger_ws_operation_seq
* id : int
v digitidefeedbackdb vtiger_ws_referencetype
* fieldtypeid : int
* type : varchar(25)
v digitidefeedbackdb vtiger_ws_userauthtoken
* userid : int
* token : varchar(36)
* expiretime : int
v digitidefeedbackdb vtiger_zone
* zoneid : int
* zonename : varchar(255)
v digitidefeedbackdb vtiger_zonecf
* zoneid : int
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship