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
1Accountsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressAccountsvarchar2550 2023-09-20 10:17:1200001true    
2Accountsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusAccountsvarchar2550 2023-09-20 10:17:1200001true    
3Accountsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeAccountsfloat1000.000000002023-09-20 10:17:1200001true8   
4Accountsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeAccountsfloat1100.000000002023-09-20 10:17:1200001true8   
5Casesjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressCasesvarchar2550 2023-09-20 10:17:1200001true    
6Casesjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusCasesvarchar2550 2023-09-20 10:17:1200001true    
7Casesjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeCasesfloat1000.000000002023-09-20 10:17:1200001true8   
8Casesjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeCasesfloat1100.000000002023-09-20 10:17:1200001true8   
9Contactsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressContactsvarchar2550 2023-09-20 10:17:1200001true    
10Contactsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusContactsvarchar2550 2023-09-20 10:17:1200001true    
11Contactsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeContactsfloat1000.000000002023-09-20 10:17:1200001true8   
12Contactsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeContactsfloat1100.000000002023-09-20 10:17:1200001true8   
13Leadsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressLeadsvarchar2550 2023-09-20 10:17:1200001true    
14Leadsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusLeadsvarchar2550 2023-09-20 10:17:1200001true    
15Leadsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeLeadsfloat1000.000000002023-09-20 10:17:1200001true8   
16Leadsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeLeadsfloat1100.000000002023-09-20 10:17:1200001true8   
17Meetingsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressMeetingsvarchar2550 2023-09-20 10:17:1200001true    
18Meetingsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusMeetingsvarchar2550 2023-09-20 10:17:1200001true    
19Meetingsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeMeetingsfloat1000.000000002023-09-20 10:17:1200001true8   
20Meetingsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeMeetingsfloat1100.000000002023-09-20 10:17:1200001true8   
21Opportunitiesjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressOpportunitiesvarchar2550 2023-09-20 10:17:1200001true    
22Opportunitiesjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusOpportunitiesvarchar2550 2023-09-20 10:17:1200001true    
23Opportunitiesjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeOpportunitiesfloat1000.000000002023-09-20 10:17:1200001true8   
24Opportunitiesjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeOpportunitiesfloat1100.000000002023-09-20 10:17:1200001true8   
25Projectjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressProjectvarchar2550 2023-09-20 10:17:1200001true    
26Projectjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusProjectvarchar2550 2023-09-20 10:17:1200001true    
27Projectjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeProjectfloat1000.000000002023-09-20 10:17:1200001true8   
28Projectjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeProjectfloat1100.000000002023-09-20 10:17:1200001true8   
29Prospectsjjwg_maps_address_cjjwg_maps_address_cLBL_JJWG_MAPS_ADDRESSAddressAddressProspectsvarchar2550 2023-09-20 10:17:1200001true    
30Prospectsjjwg_maps_geocode_status_cjjwg_maps_geocode_status_cLBL_JJWG_MAPS_GEOCODE_STATUSGeocode StatusGeocode StatusProspectsvarchar2550 2023-09-20 10:17:1200001true    
31Prospectsjjwg_maps_lat_cjjwg_maps_lat_cLBL_JJWG_MAPS_LAT LatitudeProspectsfloat1000.000000002023-09-20 10:17:1200001true8   
32Prospectsjjwg_maps_lng_cjjwg_maps_lng_cLBL_JJWG_MAPS_LNG LongitudeProspectsfloat1100.000000002023-09-20 10:17:1200001true8