orders

'CREATE TABLE `orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT NULL,
  `company_id` int(10) unsigned DEFAULT NULL,
  `action_menu` text COLLATE utf8_unicode_ci,
  `oCity` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `oState` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `oAddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `oZone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `oLat` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `oLon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `oAvailableTime` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dCity` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dState` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dAddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dZone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dLat` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dLon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dAvailableTime` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mcleodEquipmentCode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dropTrailer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `volume` int(11) DEFAULT NULL,
  `volumeType` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `oStateZone` int(11) DEFAULT NULL,
  `dStateZone` int(11) DEFAULT NULL,
  `customerId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `filepath` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `orderType` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rate` double(8,2) NOT NULL DEFAULT ''0.00'',
  `rateType` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fsc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `originalFile` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `owner_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `latitude` double(8,2) DEFAULT NULL,
  `longitude` double(8,2) DEFAULT NULL,
  `destLatitude` double(8,2) DEFAULT NULL,
  `destLongitude` double(8,2) DEFAULT NULL,
  `max_dead_head` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT ''0000-00-00 00:00:00'',
  `updated_at` timestamp NOT NULL DEFAULT ''0000-00-00 00:00:00'',
  `d_max_dead_head` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `commodity` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hasMatches` varchar(5) COLLATE utf8_unicode_ci DEFAULT ''false'',
  PRIMARY KEY (`id`),
  KEY `orders_company_id_foreign` (`company_id`),
  CONSTRAINT `orders_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=70120 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci'