MySQL fields_meta_data Definitions:
nametypelen
idvarchar255
namevarchar255
vnamevarchar255
commentsvarchar255
helpvarchar255
custom_modulevarchar255
typevarchar255
lenint11
requiredtinyint
default_valuevarchar255
date_modifieddatetime
deletedtinyint
auditedtinyint
massupdatetinyint
duplicate_mergesmallint
reportabletinyint1
importablevarchar255
ext1varchar255
ext2varchar255
ext3varchar255
ext4text
MySQL fields_meta_data Keys:
nametypefields
primaryprimaryid
idx_meta_id_delindexid,deleted
idx_meta_cm_delindexcustom_module,deleted


#idnamevnamecommentshelpcustom_moduletypelenrequireddefault_valuedate_modifieddeletedauditedmassupdateduplicate_mergereportableimportableext1ext2ext3ext4
1Accountscom_map_ccom_map_cLBL_COM_MAP  Accountsiframe2550https://www.google.com/maps/embed/v1/place?key=AIzaSyA5O3UXVlBQ6x4RNFdhCyUx1K_caFw2eIk&q={billing_address_street}, {billing_address_city}, {billing_address_state}{billing_address_country}2017-12-07 23:33:5300001false  1400
2Accountsfacebook_user_cfacebook_user_cLBL_FACEBOOK_USER_C  Accountsvarchar2550 2017-12-13 00:51:1400000falseLIST   
3Accountsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressAccountsvarchar2550 2016-09-27 18:54:4900001true    
4Accountsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusAccountsvarchar2550 2016-09-27 18:54:4900001true    
5Accountsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeAccountsfloat1000.000000002016-09-27 18:54:4900001true8   
6Accountsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeAccountsfloat1100.000000002016-09-27 18:54:4900001true8   
7Accountslinkedin_clinkedin_cLBL_LINKEDINLinkedIn ProfileLinkedIn ProfileAccountsvarchar2550 2016-02-15 21:01:1500001true    
8Accountsstart_date_cstart_date_cLBL_START_DATE  Accountsdate 0 2017-12-18 21:01:5900001true    
9Casesjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressCasesvarchar2550 2016-09-27 18:54:4900001true    
10Casesjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusCasesvarchar2550 2016-09-27 18:54:4900001true    
11Casesjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeCasesfloat1000.000000002016-09-27 18:54:4900001true8   
12Casesjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeCasesfloat1100.000000002016-09-27 18:54:4900001true8   
13Contactscontactsmap_ccontactsmap_cLBL_CONTACTSMAP  Contactsiframe2550https://www.google.com/maps/embed/v1/place?key=AIzaSyA5O3UXVlBQ6x4RNFdhCyUx1K_caFw2eIk&q= {primary_address_street}, {primary_address_city}, {primary_address_postalcode}, {primary_address_country}2017-12-18 21:00:1700001false  1400
14Contactsc_linked_in_cc_linked_in_cLBL_C_LINKED_IN  Contactsvarchar2550 2016-02-18 22:00:1900001true    
15Contactsfacebook_user_cfacebook_user_cLBL_FACEBOOK_USER_C  Contactsvarchar2550 2017-12-13 00:46:4100000falseLIST   
16Contactsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressContactsvarchar2550 2016-09-27 18:54:4900001true    
17Contactsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusContactsvarchar2550 2016-09-27 18:54:4900001true    
18Contactsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeContactsfloat1000.000000002016-09-27 18:54:4900001true8   
19Contactsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeContactsfloat1100.000000002016-09-27 18:54:4900001true8   
20Contactsmonthdate_cmonthdate_cLBL_MONTHDATE  Contactsdate 0 2018-04-26 01:05:3600001true    
21CS01_client_Dbasecompany_info_ccompany_info_cLBL_COMPANY_INFO  CS01_client_Dbaserelate2550 2016-02-05 06:35:4200001true CS01_company_informationcs01_company_information_id_c 
22CS01_client_Dbasecs01_company_information_id_ccs01_company_information_id_cLBL_COMPANY_INFO_CS01_COMPANY_INFORMATION_ID  CS01_client_Dbaseid360 2016-02-05 06:35:4200000true    
23CS01_company_informationcs01_contact_information_id_ccs01_contact_information_id_cLBL_RELATED_CONTACT_CS01_CONTACT_INFORMATION_ID  CS01_company_informationid360 2016-02-05 06:37:0400000true    
24CS01_company_informationparent_idparent_idLBL_PARENT_ID  CS01_company_informationid360 2016-02-05 06:29:3600001true    
25CS01_company_informationparent_nameparent_nameLBL_FLEX_RELATE  CS01_company_informationparent1000 2016-02-05 06:29:3600001trueparent_type_display   
26CS01_company_informationparent_typeparent_typeLBL_PARENT_TYPE  CS01_company_informationparent_type2550 2016-02-05 06:29:3600001true    
27CS01_company_informationrelated_contact_crelated_contact_cLBL_RELATED_CONTACT  CS01_company_informationrelate2550 2016-02-05 06:40:3700001true CS01_Contact_informationcs01_contact_information_id_c 
28CS01_Contact_informationparent_idparent_idLBL_PARENT_ID  CS01_Contact_informationid360 2016-02-05 06:31:2100001true    
29CS01_Contact_informationparent_nameparent_nameLBL_FLEX_RELATE  CS01_Contact_informationparent1000 2016-02-05 06:31:2100001trueparent_type_display   
30CS01_Contact_informationparent_typeparent_typeLBL_PARENT_TYPE  CS01_Contact_informationparent_type2550 2016-02-05 06:31:2100001true    
31Leadsarrival_date_carrival_date_cLBL_ARRIVAL_DATE  Leadsdate 1 2018-06-06 21:32:0401001true    
32Leadsfacebook_user_cfacebook_user_cLBL_FACEBOOK_USER_C  Leadsvarchar2550 2017-12-13 00:51:1400000falseLIST   
33Leadsindustry_cindustry_cLBL_INDUSTRY  Leadsenum1001 2018-06-05 22:37:2000001trueindustry_dom   
34Leadsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressLeadsvarchar2550 2016-09-27 18:54:4900001true    
35Leadsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusLeadsvarchar2550 2016-09-27 18:54:4900001true    
36Leadsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeLeadsfloat1000.000000002016-09-27 18:54:4900001true8   
37Leadsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeLeadsfloat1100.000000002016-09-27 18:54:4900001true8   
38Leadslead_map_clead_map_cLBL_LEAD_MAP  Leadsiframe2550https://www.google.com/maps/embed/v1/place?key=AIzaSyA5O3UXVlBQ6x4RNFdhCyUx1K_caFw2eIk&q={primary_address_street}, {primary_address_city}, {primary_address_state}, {primary_address_postalcode}, {primary_address_country}2017-12-07 23:34:3200001false  1400
39Leadslead_source_person_clead_source_person_cLBL_LEAD_SOURCE_PERSON  Leadsvarchar2551 2018-06-05 22:30:1400001true    
40Leadsmass_email_desc_cmass_email_desc_cLBL_MASS_EMAIL_DESC Add something about their industry that can be used for mass emailingLeadsvarchar2551 2018-06-05 20:23:0700001true    
41Meetingsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressMeetingsvarchar2550 2016-09-27 18:54:4900001true    
42Meetingsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusMeetingsvarchar2550 2016-09-27 18:54:4900001true    
43Meetingsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeMeetingsfloat1000.000000002016-09-27 18:54:4900001true8   
44Meetingsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeMeetingsfloat1100.000000002016-09-27 18:54:4900001true8   
45Opportunitiesjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressOpportunitiesvarchar2550 2016-09-27 18:54:4900001true    
46Opportunitiesjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusOpportunitiesvarchar2550 2016-09-27 18:54:4900001true    
47Opportunitiesjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeOpportunitiesfloat1000.000000002016-09-27 18:54:4900001true8   
48Opportunitiesjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeOpportunitiesfloat1100.000000002016-09-27 18:54:4900001true8   
49Opportunitiesrate_type_crate_type_cLBL_RATE_TYPE  Opportunitiesenum1000 2016-03-01 21:35:2800001truerate_type_list   
50Opportunitiesservice_type_cservice_type_cLBL_SERVICE_TYPE  Opportunitiesenum1000 2016-03-10 22:05:5400001trueservice_type_list   
51Projectjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressProjectvarchar2550 2016-09-27 18:54:4900001true    
52Projectjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusProjectvarchar2550 2016-09-27 18:54:4900001true    
53Projectjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeProjectfloat1000.000000002016-09-27 18:54:4900001true8   
54Projectjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeProjectfloat1100.000000002016-09-27 18:54:4900001true8   
55Prospectsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressProspectsvarchar2550 2016-09-27 18:54:4900001true    
56Prospectsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusProspectsvarchar2550 2016-09-27 18:54:4900001true    
57Prospectsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeProspectsfloat1000.000000002016-09-27 18:54:4900001true8   
58Prospectsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeProspectsfloat1100.000000002016-09-27 18:54:4900001true8   
59Taskstask_ctask_cLBL_TASK  Tasksenum1000 2018-06-04 22:06:0500001truetask_list