wp_jbusinessdirectory_companies
StaticStores jbusinessdirectory companies data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int | NO |
| name | varchar(100) | YES |
| alias | varchar(100) | YES |
| comercialName | varchar(120) | YES |
| short_description | varchar(500) | YES |
| description | text | YES |
| meta_title | varchar(100) | YES |
| meta_description | text | YES |
| street_number | varchar(100) | YES |
| address | varchar(100) | YES |
| city | varchar(60) | YES |
| county | varchar(60) | YES |
| province | varchar(60) | YES |
| area | varchar(60) | YES |
| countryId | int | YES |
| website | varchar(250) | YES |
| keywords | varchar(250) | YES |
| registrationCode | varchar(20) | YES |
| phone | varchar(20) | YES |
| varchar(100) | YES | |
| fax | varchar(20) | YES |
| state | tinyint | YES |
| typeId | varchar(255) | YES |
| logoLocation | varchar(245) | YES |
| creationDate | timestamp | YES |
| modified | datetime | YES |
| mainSubcategory | int | YES |
| latitude | varchar(45) | YES |
| longitude | varchar(45) | YES |
| activity_radius | decimal(10,0) | NO |
| userId | int | NO |
| created_by | int | NO |
| averageRating | decimal(2,1) | NO |
| review_score | decimal(2,1) | NO |
| approved | tinyint(1) | NO |
| viewCount | int | NO |
| websiteCount | int | NO |
| contactCount | int | NO |
| taxCode | varchar(45) | YES |
| package_id | int | NO |
| varchar(150) | YES | |
| varchar(150) | YES | |
| googlep | varchar(150) | YES |
| skype | varchar(150) | YES |
| varchar(150) | YES | |
| youtube | varchar(150) | YES |
| varchar(150) | YES | |
| varchar(150) | YES | |
| varchar(150) | YES | |
| postalCode | varchar(55) | YES |
| mobile | varchar(55) | YES |
| slogan | varchar(500) | YES |
| publish_only_city | tinyint(1) | YES |
| featured | tinyint(1) | NO |
| business_hours | varchar(255) | YES |
| notes_hours | varchar(255) | YES |
| custom_tab_name | varchar(100) | YES |
| custom_tab_content | text | YES |
| job_tab_name | varchar(100) | YES |
| job_tab_content | text | YES |
| business_cover_image | varchar(245) | YES |
| publish_start_date | date | YES |
| publish_end_date | date | YES |
| notified_date | timestamp | YES |
| time_zone | varchar(15) | YES |
| establishment_year | varchar(10) | YES |
| employees | varchar(100) | YES |
| ad_image | varchar(250) | YES |
| disapproval_text | text | YES |
| yelp_id | varchar(255) | YES |
| enable_request_quote | tinyint(1) | YES |
| trail_weeks_hours | text | YES |
| trail_weeks_status | tinyint(1) | YES |
| trail_weeks_address | varchar(100) | YES |
| ad_caption | varchar(245) | YES |
| recommended | tinyint(1) | YES |
| ordering | tinyint | NO |
| company_view | tinyint(1) | YES |
| opening_status | tinyint | NO |
| min_project_size | varchar(100) | YES |
| hourly_rate | varchar(10) | YES |
| tiktok | varchar(150) | YES |
| areas_served | varchar(455) | YES |
| available_dates | varchar(445) | YES |
| review_status | tinyint(1) | YES |
CREATE TABLE Statement
CREATE TABLE `wp_jbusinessdirectory_companies` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `alias` varchar(100) DEFAULT NULL, `comercialName` varchar(120) DEFAULT NULL, `short_description` varchar(500) DEFAULT NULL, `description` text, `meta_title` varchar(100) DEFAULT NULL, `meta_description` text, `street_number` varchar(100) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `city` varchar(60) DEFAULT NULL, `county` varchar(60) DEFAULT NULL, `province` varchar(60) DEFAULT NULL, `area` varchar(60) DEFAULT NULL, `countryId` int DEFAULT NULL, `website` varchar(250) DEFAULT NULL, `keywords` varchar(250) DEFAULT NULL, `registrationCode` varchar(20) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `fax` varchar(20) DEFAULT NULL, `state` tinyint DEFAULT '1', `typeId` varchar(255) DEFAULT NULL, `logoLocation` varchar(245) DEFAULT NULL, `creationDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `modified` datetime DEFAULT NULL, `mainSubcategory` int DEFAULT NULL, `latitude` varchar(45) DEFAULT NULL, `longitude` varchar(45) DEFAULT NULL, `activity_radius` decimal(10,0) NOT NULL DEFAULT '0', `userId` int NOT NULL DEFAULT '0', `created_by` int NOT NULL DEFAULT '0', `averageRating` decimal(2,1) NOT NULL DEFAULT '0.0', `review_score` decimal(2,1) NOT NULL DEFAULT '0.0', `approved` tinyint(1) NOT NULL DEFAULT '0', `viewCount` int NOT NULL DEFAULT '0', `websiteCount` int NOT NULL DEFAULT '0', `contactCount` int NOT NULL DEFAULT '0', `taxCode` varchar(45) DEFAULT NULL, `package_id` int NOT NULL DEFAULT '0', `facebook` varchar(150) DEFAULT NULL, `twitter` varchar(150) DEFAULT NULL, `googlep` varchar(150) DEFAULT NULL, `skype` varchar(150) DEFAULT NULL, `linkedin` varchar(150) DEFAULT NULL, `youtube` varchar(150) DEFAULT NULL, `instagram` varchar(150) DEFAULT NULL, `pinterest` varchar(150) DEFAULT NULL, `whatsapp` varchar(150) DEFAULT NULL, `postalCode` varchar(55) DEFAULT NULL, `mobile` varchar(55) DEFAULT NULL, `slogan` varchar(500) DEFAULT NULL, `publish_only_city` tinyint(1) DEFAULT '0', `featured` tinyint(1) NOT NULL DEFAULT '0', `business_hours` varchar(255) DEFAULT NULL, `notes_hours` varchar(255) DEFAULT NULL, `custom_tab_name` varchar(100) DEFAULT NULL, `custom_tab_content` text, `job_tab_name` varchar(100) DEFAULT NULL, `job_tab_content` text, `business_cover_image` varchar(245) DEFAULT NULL, `publish_start_date` date DEFAULT NULL, `publish_end_date` date DEFAULT NULL, `notified_date` timestamp NULL DEFAULT NULL, `time_zone` varchar(15) DEFAULT NULL, `establishment_year` varchar(10) DEFAULT NULL, `employees` varchar(100) DEFAULT NULL, `ad_image` varchar(250) DEFAULT NULL, `disapproval_text` text, `yelp_id` varchar(255) DEFAULT NULL, `enable_request_quote` tinyint(1) DEFAULT '1', `trail_weeks_hours` text, `trail_weeks_status` tinyint(1) DEFAULT '1', `trail_weeks_address` varchar(100) DEFAULT NULL, `ad_caption` varchar(245) DEFAULT NULL, `recommended` tinyint(1) DEFAULT '0', `ordering` tinyint NOT NULL DEFAULT '0', `company_view` tinyint(1) DEFAULT '0', `opening_status` tinyint NOT NULL DEFAULT '0', `min_project_size` varchar(100) DEFAULT NULL, `hourly_rate` varchar(10) DEFAULT NULL, `tiktok` varchar(150) DEFAULT NULL, `areas_served` varchar(455) DEFAULT NULL, `available_dates` varchar(445) DEFAULT NULL, `review_status` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_type` (`typeId`), KEY `idx_user` (`userId`), KEY `idx_state` (`state`), KEY `idx_approved` (`approved`), KEY `idx_country` (`countryId`), KEY `idx_package` (`package_id`), KEY `idx_name` (`name`), KEY `idx_keywords` (`keywords`), KEY `idx_description` (`description`(100)), KEY `idx_city` (`city`), KEY `idx_county` (`county`), KEY `idx_maincat` (`mainSubcategory`), KEY `idx_zipcode` (`latitude`,`longitude`), KEY `idx_phone` (`phone`), KEY `idx_creationDate` (`creationDate`), KEY `idx_review_score` (`review_score`), KEY `idx_province` (`province`), KEY `idx_area` (`area`), KEY `idx_publish_start_date` (`publish_start_date`), KEY `idx_publish_end_date` (`publish_end_date`), KEY `idx_alias` (`alias`) ) ENGINE
Safe to delete?
If you have uninstalled WP-BusinessDirectory – Business directory plugin for WordPress, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_jbusinessdirectory_companies`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-BusinessDirectory – Business directory plugin for WordPress